8 years of in-depth experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008/2008R2/2005/2000 large scale databases.
Hands on experience in installing, configuring managing, upgrading, migrating, monitoring and troubleshooting SQL Server 2012/2008/2005/2000.
Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate, Triggers to facilitate efficient data manipulation and data consistency.
Highly motivated SQL server Developer with eight Years of IT Experience in Database and Business Intelligence Technologies with expertise on ETL process and Reporting using SQL Server 2008/2005, SSIS and SSRS.
Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
Experience in writing complex SQL queries involving multiple tables inner and outer joins.
Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views.
Worked Extensively on ETL process using SSIS package.
Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP.
Expert in design and development of SQL Server Integration Services (SSIS) packages and using various control flow task and data flow transformation.
Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision.
Good understanding of Health care, Financial and Retail domains.
Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
Experience in all phases of the Software Development Life Cycle (SDLC).
Proficient in Conceptual, Logical and Physical Modeling
Experienced with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
Experienced in designing, developing and deploying SQL Server SSAS cubes.
Experienced in database server performance tuning and optimization of Complex SQL queries.
An excellent team player & technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project.
Flexible and versatile to adapt to any new environment and work on any project.