Ankur Shah

Software Engineer, Web Developer, and Project Manager in Jacksonville, Florida

Hire me

I am a software engineer living in Jacksonville, Florida. My interests range from technology to innovation. I am also interested in cricket, programming, and web development.

You can click the button above to hire me.

ETL Tools: SQL Server 2000-DTS, SQL Server 2005/2008 R2-SSIS, Ab-Initio.

OLAP Tools: SSRS, SSAS

Databases: Oracle 8i/9i/10g, MS SQL Server 2000/2005/2008/2008 R2, DB2, MS Access

Others: VSS, TFS, RED GATE, SQL-Navigator, Test Director, Win Runner

Database Skills: Stored Procedures, Cursors, functions, Database Triggers and packages

Languages: VB 6.0, Visual Studio.NET, SQL, PL/SQL, C, C++, UNIX shell scripts,

XML, HTML, .NET Framework 2.0/3.5

Operating Systems: Windows NT, Windows Server 2003/2008/2008 R2, Windows 2000, XP, Windows 7, UNIX

· 7+ years of extensive experience in Designing, Developing, Administrating and Support of Database using SQL Server 2008/2005/2000.

· Experienced in E-R modeling and Relational & Object Relational Database concepts, coding and excellent database normalization skills.

· Hands of experience in writing Transact SQL (T-SQL) queries using Joins, Cursors and Triggers

· Extensive experience in writing Stored Procedures, Functions, Views, DDLand DML using SQL Server.

· 7+ years of ETL Experience using SSIS (SQL Server Integration Services),DTS (Data Transformation Services) and Ab Initio in both Development and Production environments.

· Experience in design anddevelopment of reports using and SQL Server Reporting Services (SSRS).

· Expertise in developing and designing Cubes using SSAS and Reports using SSRS.

· Experience in SQL Admin activities such as Installation, Configuration, maintenance, support, backup, recovery, Performance Tuning of SQL Server and Clustered Keys, constraints DDL, proper indexing, Database Job Scheduling, Troubleshooting and Debugging.

· Experience in exhaustive Performance Tuning, Monitoring and Optimization of T-SQL blocks in both Development and Production environments for SQL server database.

· Experienced in Business Data analysis, Design, Modeling and Implementation on major RDBMS (SQL Server 2008/2000/2005). Worked extensively with Stored Procedures, Triggers, Dynamic SQL and Indexes.

· Extensive experience through all the phases of Full life Cycle Development including requirements gathering, technical specifications, analysis, design, implementation, testing, and operations.

Graduated from University of Pune, Pune, India - Masters in Computer Management.