Profile

Over six 6 years of experience as a SQL Server Developer/Business Intelligence/ETL Developer having strong understanding in business requirements, detail oriented, analytical, trouble shooting and SQL performance tuning experience. Depth knowledge and experience in writing SQL/TSQL, Stored Procedures, functions, triggers, constraints and views, SSIS package related tasks, developing and managing reports using SQL Reporting Services SSRS , stored procedures, triggers, functions, constraints and views etc.

SHORT SUMMARY OF TECHNICAL SKILLS:

Quick Overview:

• Experience in OLTP, OLAP/Data Warehouse, and Data Mart Databases.
• Experience in installing, upgrading, configuring, managing, monitoring and troubleshooting of Microsoft SQL Server and Databases.
• Experience with SQL Server 2012, 2080 R2, and 2005
• Proficient in T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Triggers, Cursors, CTE, DML, DDL and etc.
• Proficient in Performance Tuning of SQL query.
• Good Understanding of Isolation Level, MOLAP, ROLAP, HOLAP, Normalization, De Normalization,
• Partitioning, ACID Property, Data Warehouse, Star flake schema, Snowflake Schema etc.
• Excellent in MS SQL Server 2012, 2080 R2, 2005 suite of products like SSIS, SSAS and SSRS
• Good experience in developing reports using SQL Server SSRS
• Good experience in creating pivot tables and charts in Excel using data sources SQL Server, SSAS cubes, Access and power pivot
• Experience in Visual Studio Team Foundation Server, Visio
• Good knowledge in Database Administration
• Experience in making formal and informal presentations to technical and non-technical staff
• Expert in Creating and managing roles for security in SSRS reports.
• Knowledge in Database Backup, Recovery and Disaster Recovery procedures.
• Knowledge in implementing high availability process like log shipping, Mirroring, and Clustering.

Professional Summary:

Confidential

Role: SQL Server ETL/SSIS/SSRS Developer

Environment: MS SQL Server 2008 R2, 2005, MS SQL Server Management Studio, SSIS, SSRS, Microsoft Excel, Windows Server 2003 R2 and 2008 R2

Med Assurant Company focuses on developing tools that enable rapid health care data aggregation and validation from medical facilities for clients that include health-insurance plans, hospitals, pharmaceutical companies and regulatory agencies. Med Assurant uses the aggregated data to help customers to manage risk and identify more cost-efficient care options. Med Assurant focuses on four main areas of operation, which include claims and payment integrity, disease management, clinical and quality outcomes and health care data intelligence.

Responsibilities:

• Migrating SQL Server 2005 databases into SQL Server 2008 R2
• Designing and developing SQL Server Database, Tables, Indexes, Stored procedures, Views, Triggers.
• Design/Build Extract Transform Load procedures in SQL Server Integration Services
• Worked on creating SSIS packages to upgrade SQL Server 2005 to SQL Server 2008 R2
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Took part in the preparation of Project plan, user acceptance testing. Got a detailed understanding of business functionality and took the responsibility of preparing the Functionality.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Got a detailed understanding of business functionality and took the responsibility of preparing the
• Functionality Test Plan which was used by testing team while doing their testing process.
• Designed the packages in order to extract data from SQL db, flat files and loaded into Oracle database.
• Involved in re-design, re-code, and deploy new data extractions using SSIS, and designed and produced documentation of data transformations for all extractions.
• Developed user defined financial reports to provide on demand financial data analysis using SSRS
• Performed data conversions from flat files into a normalized database structure
• Developed numerous ad-hoc reports using SSRS for day to day financial reporting
• Installed and configured the components required to integrate SSRS with MOSS Enterprise Edition
• Experience in creating and maintaining MS SQL Server installation, performance tuning, backup, restore, security and disaster recovery.
• Experience in Dimensional Modeling, Star Schema / Snowflake Schema, FACT and Dimensional Tables.
• Monitored database status including CPU, memory, I/O, space and dead lock using SQL Server Utilities.
• Wrote DTS scripts for data transfer and Involved in System testing.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing.
• Worked on SSIS and DTS Packages, DTS Import/Export for transferring data from Heterogeneous Database Text format data to SQL Server
• Data migration import export BCP from Text to SQL Server.
• Created interactive reports with SSRS, using the report parameters, query parameters, Filters and Expressions.
• Involved in design, programming, deploy and Unit Testing of requested Reports

Confidential

Role: SQL Server SSIS/SSRS Developer

Environment: SQL Server 2012, 2008 R2 Enterprise Edition, SQL Server Business Intelligence Development Studio SSAS, SSIS, SSRS , .Net framework, SharePoint Server 2010,2013, XML, MS Visual Source Safe and Windows Servers 2012, and 2008 R2

Responsibilities:

• Involved in complete Software Development Life Cycle SDLC process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Designed and developed SSIS Packages to import and export data from MS Excel, and Flat files
• Involved in daily batch loads Full Incremental into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services SSIS
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments Development and Production
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups
• Implemented Event Handlers and Error Handling in SSIS packages. Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user reporting requirements.
• Advanced extensible reporting skills using SQL Server Reporting Services SSRS .
• Developed a High level dashboard using SSRS
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Defined Key Performance Indicator metrics to create scorecards.
• Involved in creating report models and applying row level security filters for report model.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval. Involved in upgrading from SQL Server 2005 to SQL Server 2008 R2
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.