PROFESSIONAL SUMMARY:

• MS SQL Server Developer with Over 7 years of strong experience in Investment Banking, Finance, Insurance, Healthcare services.
• Highly proficient in operating MS SQL Server 2012/2008 R2/2008/2005/2000 suite of products like SSIS, SSRS and SSAS.
• Conversant with all phase of Software Development Life Cycle SDLC involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services, and MS SQL Server Analysis Services.
• Expert in creating all the different stages of the Data Warehousing packages includes extracting, migrating, loading data.
• Hands on experience in Logical and Physical Database design development, Normalization and Data modeling using Erwin data model.
• Proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Expertise in Data Extraction, Transforming and Loading ETL using SQL Server Integration Services SSIS , Data Transform Services DTS , Bulk Insert and BCP.
• Expert in Developing SSIS Packages to Extract, Transform and Load ETL data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
• Proficient in Creating, Configuring and Fine-tuning MS SQL Server Integration Services SSIS .
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Highly experienced in writing Parametrized Queries for generating Tabular reports, Formatting report layout, Sub-reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2005.
• Expert in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Hands on experience in writing MDX queries to work with cube data.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Conversant in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Efficient in up gradation and migration from MS SQL Server 2000 to MS SQL Server 2008/2005.
• Confident in work independently and proactively. Strong leadership, communication, problem-solving and multitasking abilities. Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

Technical Skills:

MS SQL Server 2012/2008 R2/2008/2005/2000/7.0, Analysis Services SSAS , MS SQL Server Integration Service SSIS , MS SQL Reporting Services SSRS , Microsoft Access 2007/2003/8.0, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, MS SQL Server Index Tuning Wizard, Erwin Data Modeler 4.2/4.1/4.0, VB6, Microsoft Products MS Word, MS Excel, VSS, MS Access, MS Powerpoint, T-SQL, PL-SQL, HTML, XML, Crystal Reports 8.5, MS Visio 2003, Windows 2003/2000 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Professional Experience:

Confidential

MS SQL SERVER SSIS/SSRS DEVELOPER

RESPONSIBILITIES:

• Defined and Designed data based on business requirement and provided documentation.
• Created SSIS package to load data from XML Files, Ftp server and SQL Server to SQL Server 2012 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Modified the existing SSIS packages, Script Component Task to meet the changes specified by the users and adding column to the newly design table and to the existing table.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs. Job overlap alert.
• Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to Automatic added Derived column, Parameter and Configuration value to the package.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parameterized reports using SSRS 2012.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters. Created various database objects like stored procedures, functions, tables, views, and triggers.
• Configured the report viewing security for various users at various levels using Report Manager
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds SSIS packages.
• Designed and implemented Stored Procedures and Triggers DDL DML for automating tasks.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schema using Dimensional Modeling principles in SSAS.

Tools Technologies:

MS SQL Server 2012, SQL BI Suite SSMS, SSIS, SSRS , XML, MS Excel, MS Access 2007 Windows Server 2008, SQL Profiler, Data Analyzer, Erwin r 7.3, Net 4.0/4.5, TFS 2010.

CONFIDENTIAL

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Designed data architecture, data model and Mapping Process to load data based on business requirement and provided documentation.
• Implemented Table, Views, Function, Stored Procedures and Triggers for load data and validation purpose.
• Worked with Agile Methodology tracking the product backlog and resolved the defects/Solution assigned in daily scrum.
• Created SSIS package to load data from XML Files, Excel, CSV file, Ftp server and SQL Server to SQL Server 2008 by using Derived Columns, Condition Split, Data Conversion, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Script Component Task.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Transaction and Data Ware House.
• Converted DTS Package to SSIS package for synchronizes existing process DTS migrations .
• Used Team Foundation Server to retain Project code during deployment process.
• Part of Code review during Production deployment and QA deployment.
• Designed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Designed Console application to generate Single .CSV and text file from Different relational Database table using SSIS and C .
• Created Process for Error Details in Application system, Control-M Job, SQL agent Job to easily identify Issue for Support and Solution.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and parametrized reports using SSRS 2008.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.

Tools Technologies:

MS SQL Server 2008, SSIS Package, SQL BI Suite SSMS,SSIS, SSRS,SSAS , XML, MS Excel, MS Access 2007 Windows Server 2008, SQL Profiler, SQL Profiler, Erwin r 7.3,.Net 4.0/4.5,TFS 2010.

CONFIDENTIAL

MS SQL Server/SSIS/SSAS Developer

Responsibilities:

• Developed various T-SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Wrote complex Stored Procedure, Queries, Triggers, User-defined functions as per the business requirements.
• Optimized existing stored procedures and various T-SQL queries.
• Wrote Dynamic Store Procedure to move data from Staging to Application.
• Wrote User Defined Function to calculate Single Target Ratio, Product Element ratio and Element Product ratio.
• Improved Performance by creating Clustered and Non clustered Indexes and by Optimizing the T-SQL statements using SQL profiler.
• Added more audits and alerts in SSIS Packages in case of package failure.
• Created package to transfer data between OLTP and OLAP database using container, task and transformation to load underlying data in to the tables from Text files.
• Managed index, statistics and optimize queries by using execution plan for tuning the database.
• Developed packages to handle data cleansing and scrubbing using Derived Column, Conditional Split, Script task etc to clean data.
• Developed Master Child package using variables and Execute package task in SSIS.
• Used Aggregate, Conditional Split, Union All, Lookup, Derived Column, Data Conversion, Multicasting and Merge Join Data Flow transformations in SSIS
• Created SSIS package using for each loop, sequence container to load multiple files from same source folder on different FTP location and to perform group task
• Configured SSIS packages with XML file using package configuration to deploy the packages on different environment.
• Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling in the packages.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Scheduled jobs to call the packages and Stored Procedures as per business requirement
• Deployed, tested and scheduled SSIS packages using SQL Agent.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deployed and scheduled Reports using SSRS to generate all reports including current status.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Tools Technologies:

Microsoft SQL Server 2008, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Query Analyzer, Business Intelligence Development Studio BIDS , Erwin 7.1, Windows 2003 servers, XP Professional, Microsoft SharePoint, Microsoft Visio Professional 2008, Optimal Trace, Crystal Reports, ETL Tool.

CONFIDENTIAL

MS SQL Server Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Defined Technical Design Specifications, ETL work-flows and Source to Target Mapping STTM spreadsheets for each Vendor system interfacing with the High Point system.
• Designed, developed and deployed complex SSIS packages based on STTM conversion rules for the transformation of Pre-staging data from AS400 systems to subsequent target layers in SQL Server 2008R2.
• Optimized queries and tuned performance using SQL Server tools including SQL Profiler, SQL Performance Monitor and Execution Plan.
• Generated SQL Server Database objects including Tables, Views and Indexes.
• Created and modified stored procedures, triggers and queries for automating various interface tasks using T-SQL.
• Designed, deployed, and maintained of various SSRS Reports in SQL Server 2008R2.
• Wrote Parametrized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008R2.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.
• Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schema using Dimensional Modeling principles in SSAS.

Tools Technologies:

Microsoft SQL Server 2008R2, SSIS 2008R2, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Query Analyzer, Business Intelligence Development Studio BIDS .

CONFIDENTIAL

MS SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• Conducted detailed analysis of each Legacy source system interface with Data warehouse DW including all existing Mainframe Files and Data elements to be converted from Source system to Target Pre-staging.
• Worked with Project Manager and Business Analyst to understand business requirement and also involved in planning, defining and designing data based on business requirements.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Designed and developed SSIS ETL packages for loading data from OLTP system, DSR Staging Database to DW.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions etc using T-SQL to provide structure to store data and to maintain database efficiently.
• Developed Package Configuration by using SQL Server type for making Package dynamic.
• Modified the Existing SSIS Packages and added more audits and alerts in case of package failure.
• Created Views to reduce complexity of end user.
• Involved in performance monitoring and tuning of TSQL queries using SQL Profiler and database engine tuning advisor.
• Created Index to optimize performance of TSQL queries.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS.
• Created parametrized, Drill down and Drill through reports in MS SQL environment using SSRS.
• Generated SSRS Report through SSIS Package using script component as per business requirement.
• Involved in scheduling job using SQL Server Agent for SSIS Packages and Store Procedure as per requirement.
• Successfully tested all task in staging and stored all versions of data using team foundation server TFS .
• Created documents for all Store Procedure, SSIS Package and SSRS Reports that I developed.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schema using Dimensional Modeling principles in SSAS.

Tools Technologies:

Microsoft SQL Server 2005, SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS , SQL Server Analysis Services SSAS , Query Analyzer, Business Intelligence Development Studio BIDS , Erwin 7.1,Windows 2000/2003 servers, XP Professional, Microsoft Share-point, Microsoft Visio Professional 2005, Optimal Trace, Crystal Reports, ETL Tool.

CONFIDENTIAL

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Interacted with users and analysts and gathered and documented the technical and metadata.
• Designed Database, Tables and Views structure for the new data mart.
• Worked with T-SQL to create Tables, Function and Stored Procedures, sub query, correlated sub query, complex Stored Procedures and ad-hoc TSQL statement.
• Performed Unit Testing and SQL Performance Tuning.
• Generated Reports and Charts using Crystal Reports.
• Migrated data from Heterogeneous data Sources Excel, Flat file, and CSV file to centralized SQL Server databases using SQL Server Integration Services SSIS to overcome transformation constraints.
• Created package to transfer data between OLTP and OLAP database using Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc to load underlying data in to the tables from Text files, Excel file and CSV file.
• Created Views and Synonym to reduce complexity of end user Responsibility for gathering/refining requirements from the customer for developing reports.
• Developed Query for generating drill down reports in SSRS 2005

Tools Technologies:

SQL Server 2005 Enterprise Edition, Access 2003, T-SQL, MS-Excel, Query Analyzer, Crystal Reports.