SUMMARY

• Over 8 years of IT experience as MS SQL Server Developer 2012/2008 R2/2008/2005/2000 in various Industry verticals like Insurance, Finance and Banking.
• 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.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin data model.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Define Functions, Relational Database Models and Data Integrity, SQL joins and Query Writing.
• Proficient 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.
• Extensive experience working with SSIS packages, creating jobs and linked servers for MS SQL Server/Oracle/ Sybase databases.
• Expert in Creating, Configuring and Fine-tuning MS SQL Server Integration Services (SSIS).
• Skilled 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.
• Experience in Design and optimization of OLTP, OLAP tools, creating SSAS based OLAP Cubes.
• Strong experience in Database Installation, Capacity Planning, Implementing Backup and Recovery Strategy for application and database.
• Proficient in using tools like MS SQL Profiler, Database Engine Tuning Advisor, Windows performance for monitoring and tuning SQL Server performance.
• Maintained positive communications and working relationships at all business levels.

TECHNICAL SKILLS

Skill set: MS SQL Server 2012/2008 R2/2008/2005/2000, MS SQL Server 2008/2005 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Microsoft Access 2000, Microsoft Excel, Outlook, MS SQL Profiler, SQL Query Analyzer, Database engine tuning advisor, Erwin Data Modeler 7.2/4.2/4.1,Crystal Reports 8.5, T-SQL, MS Visio 2005, Windows 2003/2000 Advanced Server/Professional.

PROFESSIONAL EXPERIENCE:

Confidential, DE

SQL developer/BI Developer

Responsibilities:

• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008.
• Created SQL Server Drill down, Drill through, Adhoc, Cross tab report using SSRS to fit business requirements.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.
• Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.
• Designed and delivered dynamic reporting solutions using MS SQL Server Reporting Services.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.

Tools & Technologies: MS SQL Server 2012/2008 R2, T-SQL, SSIS, SSRS, SSAS, Microsoft Access, Oracle 10g

Confidential, Jersey city, NJ

MS SQL Server/SSIS/SSRS Developer/ Data Modeler

Responsibilities:

• CreatedSSISpackages to clean and load data to data warehouse.
• Key tasks include design of tables, stored procedures, conversion of stored procedures into ETL code, database schema and ERD logical model change management, develop, test and implement complex SQL statements, stored procedures, triggers, and functions in SQL Server 2008 R2
• Created drill down, drill through, sub and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Generated multi parameterized reports in MS SSRS 2008 allowing users the ability to make selections before executing reports; thus making them user friendly
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created SSIS packages to transfer data between Staging database and Igloo
• Worked with the ETL architect and lead to ensure ETL developers have the required data schema and metadata information and participate in knowledge transfer with the goal to remove any knowledge gaps that might exist.
• Assist with source data analysis and profiling and in the development of the source to target mapping documents.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived
• Columns, Conditional Split; Term extraction, Aggregate, Execute SQL Task, Data Flow Task
• CreatedSSISpackages to import data from MS Access, Excel to SQL 2008 R2
• Generated parameterized reports, sub reports, tabular reports using SSRS 2008R2.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS 2008R2
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008R2.
• Created reports which retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically using SSRS Subscription
• Performed Monitoring and Tuning Report performance.
• Configured the report viewing security for various users at various levels using Report Manager.

Tools & Technologies: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Confidential, Bloomington, IL

MS SQL Server Developer/ETL Developer

Responsibilities:

• Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front-end application.
• Designed and modeled Microsoft SQL Server 2008 data warehouse and data marts, including the modification of existing Microsoft SQL Server 2005 data warehouse and data marts.
• Used SSIS packages to roll our data to Live Tables and to Processing Database.
• Developed database objects such as SSIS Packages, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager
• Configure the SSIS Package for run time Parameters and Configure file
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Integrate the SSIS package, converting all existing DTS packages of MS SQL 2005 to 2008 by adding extra SSIS task.
• Schedule Package using SQL Server Job for weekly/monthly basis.
• Used Checkpoint for avoiding re-executes Package from the first task.
• Develop the Slowly Changing Transformation to maintain the Historical Data.
• Handling the errors during data moving and Sequencing the task as per requirements.
• Developed packages using fuzzy task for data cleansing.
• Handling the orphan rows in Dimension and Fact tables.
• Participated actively in analysis and discovery phases of data warehouse implementation.
• Perform T-SQL tuning and optimizing queries for Reports, which take longer, time in execution SQL Server 2008.
• Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
• Migrated some Crystal reports to SSRS reports manually
• XML resultset from Stored Procedures to create custom XML file for third party data export.
• Extensive work on SSIS creating all the interfaces between front end application and SQL Server 2008 database, then from legacy database to SQL Server Database and vice versa.

Tools & Technologies: MS SQL Server 2008, SSRS, T-SQL, SSIS, Win 2003 Advanced Server, Erwin v7.2

Confidential, Iowa

SQL Developer/BI Developer/Data Analyst

Responsibilities:

• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Developed various T-SQL stored procedures, functions and packages.
• Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, and Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS.
• Working knowledge in Data modeling, creating star and snowflake schemas in SSAS.
• Developed complex calculated members, Named Sets using MDX expressions for specific OLAP reporting requirements.
• Created KPI Objects in line with Requirement Docs in SSAS.
• Analyzed existing logicaldatamodel (LDM) and made appropriate changes to make it compatible with business requirements.
• Worked on identifying facts, dimensions and various other concepts of dimensionalmodeling, which are used for datawarehousing projects.
• Optimized cubes for better query performance.
• Aggregated cube with 30% performance for better performance.
• Processed cube to perform incremental updates.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Generated reports using SQL Server Reporting Services 2008 from OLTP and OLAP data sources.
• Designed and deployed report with Drill Down, Drill Through, Drop down menu option, Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
• Used Database engine tuning advisor, SQL Profiler for Performance Tuning.

Tools & Technologies: MS SQL Server 2008, SQL Server Reporting Services 2008, SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Windows 2003/2000 and T-SQL.

Confidential, Charlotte, NC

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect
• Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
• Designed and implemented complex SSIS package to migrate data from multiple data sources (Teradata) for data analyzing, deploying and dynamic configuring of SSIS packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to CDW with the help of SSIS.
• Developed and maintained a combined data store for reporting purposes.
• Generated reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services 2012.
• Identified the database tables for defining the queries and defined datasets for report generation.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2012.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Tested the reports and fixed bugs in the stored procedures.
• Responsible for the Performance tuning of the SQL Commands and the troubleshooting of the technical problems in MS SQL Server 2012 with the use of the Query Analyzer and Database Engine Tuning Wizard.

Tools & Technologies: MS SQL Server 2008, SSIS 2008, SSRS 2008, SSAS 2008, T-SQL, SSMS

Confidential

Jr Data Analyst/SSRS Developer

Responsibilities:

• Upgraded MS SQL Server 2000 databases to 2005 using detach/attach, backup and recovery and by replication.
• Incorporated the DTS packages into SSIS 2005 by using package migration wizard and executed DTS 2000 Package task.
• Involved in SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and Stored Procedures.
• Performed transformations using various SSIS tasks such as conditional split, derived column, that performed data scrubbing, including data validation checks during staging, before loading the data into the data warehouse.
• Used ETL to implement the slowly changing transformation to maintain historical data in data warehouse.
• Created Views to reduce database complexities for the end users.
• Designed and implemented stored procedures and triggers for automating tasks.
• Created Sub-reports, Drill-down reports, Summary reports, and Parameterized reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, index tuning wizard and SQL Query Analyzer in MS SQL Server 2008.
• Created alerts for successful or unsuccessful completion of scheduled jobs.

Tools & Technologies: MS SQL Server 2005, T-SQL, SSIS 2005, SSRS 2005, MS SQL Profiler, SQL Query Analyzer, Index Tuning Wizard, MS Access, Crystal Reports 10/9, Visual Studio 2005.