SUMMARY

• Over 7+ years of IT experience as a MS SQL Server 2012/2008R 2/2008/2005/2000 Developer in various industries like Finance, Insurance, and Health Care
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Requirement Gathering and Analysis, High Level Design, Detailed Design, Development and Implementation Support.
• Excellent experience to deliver comprehensive Business Intelligence through integration of BI suite of products (SSIS, SSAS, SSRS) including MS solutions like Microsoft Excel.
• Strong knowledge of Data Warehousing methodologies and concepts, including Star Schemas, Snowflake Schema, SSIS processes, Dimensional Modeling and Reporting tools.
• Highly proficient in using T - SQL for developing complex Stored Procedures, Effective Triggers, Tables, Views, User defined Functions, Relational Database Models and Data Integrity, SQL Joins, Indexing and Query Writing.
• Strong ability in Data warehousing tools, Data Mapping, Unit Testing, Migration, Conversions, and Process Documentation
• Well versed in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS including tools like BCP utility, DTS and SSIS Packageswith proper control flow and data flow elements by using MS SQL Server 2012/2008-R 2/2008/2005.
• 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.
• Strong working experience in implementing Key Performance Indicator (KPI) Objects and create calculate member in MOLAP cube using MDX in SSAS 2012/2008-R 2/2008/2005.
• Proficient in dimensional data modeling and Cube development (SSAS), partition, aggregation and optimization using SSAS 2012/2008-R 2/2008/2005.
• Expertise in Creating, Managing and Deploying SSRS Reports on the portal for user accessibility.
• Good experience in generating Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012/2008-R 2/2008/2005.
• Implemented SSRS server level and item level security, subscription, performance tuning and access various reports in multi-user environment.
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

• MS SQL Server 2012/2008R 2/2008/2005/2000
• MS SQL Server 2008/2005 Analysis Services (SSAS)
• MS SQL Server Integration Service (SSIS)
• MS SQL Server Reporting Services (SSRS)
• Microsoft Access 2000
• ERWIN 9/8/7.2
• Microsoft Visio 2010/2007
• T-SQL
• C#
• VB.Net
• HTML
• XML
• XSL
• Oracle 11g/10g
• JAVA
• Crystal Reports 8.5/9/10/11
• TFS
• Visual source safe 2005
• MS office 2010/2007/2003
• Windows 2008/2003/2000 Advanced Server/Professional
• Windows NT 4.0 Server/Workstation
• VBScript
• SharePoint 2007
• Team Foundation Server (TFS) 2012
• Object Oriented Analysis and Design (OOAD)
• SDLC Methodologies namely Agile and Scrum

PROFESSIONAL EXPERIENCE

Confidential, Manhattan, NY

MS SQL/SSIS/SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, productionteams and across functional units to identify business needs and discuss solution options.
• Developed logical and physical data models, design data access strategies and wrote SQL code to access and manipulate data stored in relational databases.
• Designed and developed physical and logical Data Models using Erwin and also responsible for Forward Engineering in Data Modeling.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Created and updated stored procedures and functions to meet the requirements and changes specified by the users.
• Pushed all the created store procedures and functions to the development, training and production servers.
• Created trace in SQL Profiler and used Database Engine Tuning Advisor (DTA) for Performance tuning on stored procedures and Scripts.
• Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
• Formulated and documented the physical ETL (SSIS) process design based on business requirements and system specifications with strong ETL (SSIS) design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
• Agile methodology was used throughout the project, Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
• Created packages in SSIS 2012 (.dtsx files) with error handling as well as created complex SSIS packages using various Data Transformations like Conditional Splitting, Fuzzy Look Up, For Each Loop, Multi Cast, Column Conversion, Fuzzy Grouping, Script Components.
• Responsible for implementation of Data Viewers, SSIS Logging, Error Configurations for error handling the packages.
• Extracted data using SSIS 2012 from Oracle and Flat Files. Based on required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Deployed and configured various SSIS packages.
• Worked with Tabular reports, Matrix reports, Gauges & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as Interactive reports according to business requirements in time restricted environment using SQL server reporting services(SSRS) 2012.
• Designed and developed report with running value, interactive sorting as well as conditional formatting.
• Involved in scheduling, creating snapshot and subscription for the reports.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.

Tools: & Technologies: MS SQL server 2012, MS Server Integration services, SSIS, DTS, SSRS, Profiler and Windows Server 2008.

Confidential, Philadelphia, PA

MS SQL Server/SSIS/SSRS/ BI Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by 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 and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• 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.
• 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 Parameterized reports using SSRS 2008.
• Created SSRS reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard(SSRS)
• Responsible for Monitoring and Tuning SSRS Report performance.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using SSRS Report Manager.

Tools: & Technologies: MS SQL Server 2008R2, T-SQL, SSIS 2008, SSRS 2008, TFS 2010, Advanced Server, SSMS, Erwin v7.2, ASP.Net, C#.

MS SQL/SSIS/SSRS/SSAS Developer

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 for mortgage loan products.
• Designed and developedSSIS Packagesto import and export data fromMS Excel, SQL Server 2005 and Flat files.
• 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 such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Fuzzy Lookup, Fuzzy Grouping in SSIS Dataflow.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Designed and created Report templates, bar graphs and pie charts based on the financial data regarding competitive rates and financial market.
• Developed various types of complex reports like Drill Down, Drill through, linked reports, cascading parameter reports for business loan, first time buyer or refinancing home mortgage.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
• Involved in designingParameterized Reportsand Matrix Reports for generatingAd-Hocreports as per the client requirements.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, 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.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.

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

Confidential, Richmond, VA

MS SQL Server Dev/ETL/Data Analyst

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option, Sub reports, Tabular reports, Parameterized and Linked reports according their range of insurance products.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Designed and developed various types of reports using SSRS and rendered them in front end applications like Excel
• Created report models and deployed on report server.
• Created standard report Subscriptions and Data Driven report Subscriptions as per lead specification and used report manager for securities.
• Created snapshot reports and cache for better performance.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages as well as window messengers.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Designed and created distributed reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SQL Server 2005 Reporting Services (SSRS) and Crystal reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.

Tools: & Technologies: MS SQL Server 2005 Enterprise Edition, MS Access 2003, Erwin v4.0, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler.

Confidential, King of Prussia, PA

SQL/SSIS/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.

Confidential

MS SQL/SSRS Developer

Responsibilities:

• Designed data models using Erwin v4.0. Developed physical data models and created DDL scripts to create database schema and database objects.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
• Created and managed scheme objects such as tables, views, clusters and Indexes, created complex store procedure using input and output parameter.
• Wrote queries using inner join, outer join, and self joins, merge join. And also implemented functionality for removing duplicate records like using CTE, using ranking function.
• Successfully transferred old data from various sources like flat files, MS Access 2003, and Excel into MS SQL Server 2005 using DTS Packages and created complex Stored Procedures and Functions for integrity checks of transferred data.
• Improved Performance of the database by creating Stored Procedures, Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Developed reports using efficient data retrieval techniques and tested the reports.
• Created Sub-reports, Parameterized, Drill-through, Drill-down reports, Matrix reports and Summary reports in SSRS 2005

Tools: & Technologies: MS SQL Server 2005 Enterprise Edition, SSRS 2005, MS Access 2003, Erwin v4.0, T-SQL, MS-Excel, MS-Access, SQL Query Analyzer, MS SQL Profiler.