SUMMARY

• A result driven MS SQL Server Developer with 7+ Years of strong demonstrated IT experience in Education, Insurance, Banking and Finance, and Healthcare with expertise in MS SQL Server 2012/2008R2/2008/2005 and BI suite such as SSIS, SSRS as well as 4+ Years of Data base Administration and Oracle PL/SQL development experience and strong knowledge in using tools such as Guide Wire, Erwin, and TFS.
• Extensive experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using MSSQL
• Experience with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Strong Knowledge in Data Extraction, Transforming and Loading (ETL) using SQL SSIS, Data Transform Services (DTS), Bulk Insert and BCP.
• Experience in SQL Server DTS and SSIS (Integration Services) package design, development, and deployment using SQL server advanced features in Control flow, data flow, Error Handling and event handling.
• Strong experience in designing and developing enterprise reports(SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources. Normalizing databases for OLTP environments and de-normalizing tables for use in OLAP environments.
• Good knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Extensive experience in writing Parameterized 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.
• Proficient in using tools like MS SQL Profiler, Index Tuning Wizard, Windows performance for monitoring and tuning SQL Server performance.
• Highly experienced in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and Data Integrity, and SQL joins.
• Expertise in Data modeling tool Erwin, Backup and restore tool such as Red Gate and Idera, and insurance tool Guide Wire (for claim and billing purpose).
• Involved in Migration of data from other database to SQL Server using SSMA.
• Strong leadership, communication, problem-solving and multi-tasking abilities, demonstrated experience seamlessly learning new technologies in a short span of time, and working well under pressure.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R2/2008/2005 T-SQL
• MS SQL Server Integration Service (SSIS)
• MS SQL Reporting Services (SSRS)
• Microsoft Access
• Microsoft Excel
• Outlook
• MS SQL Profiler
• SQL Query Analyzer
• MS SQL Server Index Tuning Wizard
• Erwin
• Microsoft Office Products like Word
• Excel
• Power Point
• PL/SQL
• T-SQL
• VSS(Visual Source Safe)
• MS Visio
• HTML
• XML
• C++
• Cognos
• Windows server 2008/2003/2000.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Developer

Responsibilities:

• Gathered user requirements to develop the business logic and analyzed and designed database solutions.
• Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
• Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
• Scheduled and monitored all maintenance activities of SQL Server 2008 including database consistency checks and index defragmentation.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Created Parameterized, matrix and drill down reports using SSRS 2012/2008.
• Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2012/2008.
• Formatted reports for various Output formats as requested by the management using SSRS.
• Actively supported business users for changes in reports as and when required using SSRS.
• Analyzed reports and fixed bugs in stored procedures using SSRS.
• Used complex expressions to group data, filter and parameterize reports.
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Designed and optimized indexes, views, stored procedures and functions using T-SQL
• Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Deployed the generated reports created using SSRS 2008 on to the server.

Environment: MS SQL Server 2012/2008, SSIS 2012/2008, SSRS 2012, T- SQL, Windows XP, MS Excel, Query analyzer, SQL Profile.

Confidential, Bronx, NY

MS SQL Server Developer/ SSIS Developer/SSRS Developer

Responsibilities:

• Defined and designed the data sourcing and data flows, data quality analysis
• Identified the data source and defined them to build the data source views.
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Review developer SQL code to ensure adherence to client standards and general best coding practices.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Used SQL Server Agent to automate the SSIS 2012/2008r2 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2012/2008r2 and then created reports using this data using SSRS.
• Tested and managed the SSIS 2012 packages and was responsible for its security.
• Configured and maintained Report Manager and Report Server for SSRS.
• Identified and added the report parameters and created the reports based on the requirements using SSRS 2012/2008r2.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Designed stylish Report Layouts and Deployed the Reports using SSRS 2012/2008r2.
• Wrote Complex Stored Procedures, Triggers, Views and Queries.
• Created indexes, Constraints and rules on database objects.

Environment: MS SQL Server 2012/2008r2, MS SQL Server Reporting Services, MS SQL Integration services, T- SQL, Erwin 8.0, MS Excel, MS word, Visual Studio 2008.

Confidential, Dorchester, MA

MS SQL/ SSIS Developer

Responsibilities:

• Wrote from simple to complex T-SQL queries in SQL Server Management Studio, for extraction of data from staging environment based on the requirement and pushed the required data to UAT environment.
• Responsible to create various Tables, Views and Functions based on the requirement specified by EDW team and wrote complex Join statements for combining data from various Databases and tables in different relational model database server such as Oracle and DB2.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Fine tuned SQL queries for maximum efficiency and performance using MS SQL Profiler, Database Engine Tuning Advisor, Execution Plan and Index Tuning wizard.
• Helped in Rebuilding the Indexes at regular intervals for better performance.
• Worked with a Cognos team and helped to create complex by weekly, quarterly and annual report by writing code based on the requirement.
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Produced operational reports in SSRS 2008r2 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Converted manual reports pasted together into parameter driven stored procedures to be used with Microsoft Reporting Services 2008r2.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Used Crystal Report to graphically design data connections and report layout.
• Created and used previously created custom formulas for Crystal Report to load fields from MS SQL Server databases and Oracle tables to create reports based on the requirement.
• Produced and modified Crystal Report from previously created Sub-reports.
• Helped in planning out the coding and offered different solutions in initial planning of the project.

Environment: MS SQL Server 2008r2, SSIS, T-SQL, Cognos, Windows 2008 Server, Microsoft Visual Studio 2010/2008, and Erwin 8.0.

Confidential, Edison, NJ

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Used Guide Wire to replace legacy systems developed internally by insurance carriers.
• Mentored Guidewire clients successfully on how to use the testing tools with Guidewire products.
• Used Guide Wire claim center user interface on daily basis
• Wrote complex dynamic SQL queries for changing column and table names using SQL variables.
• Created Complex Stored Procedures, Triggers, Function, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Involved in improving database performance using SQL Profiler, Trace Flags, Execution plan and Index Tuning Wizards.
• Designed databases from scratch using conceptual, logical and physical modeling using Erwin.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Created SSIS packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports usingSQL ServerReporting Services 2012 and Created ad-hoc reports Using Report Builder.
• Created SSRS reports from Different Databases like Oracle andSQL Server.Configured and deployed SSRS reports.

Environment: MS SQL Server 2008r2, Oracle, SSIS, SSRS, T-SQL, PL/SQL, Guidewire, Dynamic SQL, MSCRM, Erwin, MS Office.

Confidential, New York, NY

Jr. MS SQL/SSIS/SSRS Developer

Responsibilities:

• Involved in using Guide Wire suite and Gosu.
• Loaded data from staging table to operational tables and finally, to the Guide Wire policy center.
• Wrote complex T-SQL queries, store procedure and created database objects such as tables, and views.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SSRS.
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Created SSIS packages for transaction reconciliation, which is being used by the accounting department as a daily basis from SAP.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on daily basis using SQL Server Agent.
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SAP, SQL Server and Flat File sources and load into various Business Entities.
• Created various database objects such as Stored Procedures, Functions, Tables, and Views and wrote T-SQL queries to retrieve data from various tables.
• Configured the report viewing security for various users at various levels using Report Manager.
• Wrote queries used in Guide Wire tool based on Insurance and Assurance requirements.
• Worked on Guide Wire tool for property and causality claims.
• Work on Performance Tuning of complex queries using SQL Profiler, Index Tuning Wizard and Execution Plan.

Environment: MS SQL Server 2008/2005, SSIS, SSRS, T-SQL, MSCRM, Guide wire Gosu, Windows 2008 Server, DTS, and Erwin, Guide Wire, Idera

Confidential, Cleveland, OH

Jr. MS SQL Server/BI Developer

Responsibilities:

• Performed System Study and Requirements Analysis, prepared Data Flow Diagrams, Entity Relationship Diagrams, Data Diagrams, Table Structures.
• Enhanced the old logical and physical database design to fit new business requirement, and implemented new design into SQL Server 2005.
• Upgraded to SQL Server 2005 and Management tools using SQL Server Setup Program.
• Wrote T-SQL queries, Store Procedures and used them to build packages.
• Involved designing and developing packages for a Data Warehousing and Data Migrations projects using SSIS on different Data Sources.
• Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target DW using SSIS and BCP
• Designed SSIS Packages to transfer data from various sources like XML Files, SQL Server, Excel, and Access to SQL Server.
• Handled slowly changing dimensions to maintain the history of the data.
• Identified Key Performance Indicators (KPI) and Metrics for Business needs.
• Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
• Designed, reviewed and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
• Created trace in SQL Profiler and used Data base engine tuning advisor for Performance tuning on stored procedures and Scripts.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future reference.

Environment: MS SQL Server 2005, SQL Server Integration Services, MS Visual Studio, Windows Server 2003, MS Excel, MS Access, SQL Server Profiler, Erwin, T-SQL