PROFESSIONAL SUMMARY:

• Over 5 years’ experience with Certified MS SQL Server Developer 2012/2008R2/2008, as a MS SQL Server Developer 2012/2008R2/2008 in Industries like Health Care domains. Maintained positive communications and working relationships at all business levels.
• Experience in MS SQL Server suite of products like SSRS and SSIS of MS SQL Server 2008 R2/2008.
• Experience in MS SQL Server 2012/2008R2/2008, Business Intelligence in MS SQL Server Integration Services, MS SQL Server Reporting Services.
• Created SSIS packages for ETL purposes. Implemented transformations to be used in SSIS packages.
• Strong knowledge of Data Conversion, Normalization and Data Modeling, Multi - Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool.
• Proficient in Creating, Configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL queries using tools like SQL Profiler, Performance Monitor and Database Engine Tuning advisor.
• worked on Creating and Deploying SSRS Reports on the portal for user accessibility.
• 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 2012/2008.
• Highly 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.

TECHNICAL SKILLS

• SSIS 2012/2008R2/2008
• SSRS 2012/2008
• T-SQL
• MS Visual Studio 2010/2008
• MS SQL Profiler
• SQL Query Analyzer

PROFESSIONAL EXPERIENCE

Confidential, White Plains, NY

MS SQL Server Developer/SSIS/SSRS

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Optimized Indexes, Views, Stored Procedures and Functions using T-SQL.
• Used SSIS jobs for importing data from the flat files that brings the data to the application tables.
• Wrote Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Developed and deployed data transfers packages to the appropriate destinations using SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages.
• Created SQL server configurations for SSIS packages.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Responsible for creating reports based on the requirements using SSRS 2012.
• Defined the report layout and identified Datasets for the report generation.
• Created different type of reports including Cross-tab, Conditional, Drill-down, Sub reports also parameterized reports.
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Developed, implemented and maintained various database objects such as Stored Procedures, Triggers, Functions, Indexes and Views.
• Developed and implemented procedures to ensure the quality, usability and accuracy of reports.
• Created Packages to group logically related column types and to transfer data.

Project Environment: MS SQL Server 2012, SQL server Reporting Services 2012, SQL Integration Services 2012, Microsoft Visual Studio 2010, SQL Server Management Studio 2010, MS Excel, T-SQL.

Confidential, NY

MS SQL/ETL Developer

Responsibilities:

• Wrote User defined functions, views, trigger, and indexes for various purposes based on the requirements.
• Implemented complex business logic with case expression, cast and convert, group by, top operator, while loop and common table expression using complex t-sql queries.
• Created packages using the various control flow task such as data flow task, execute SQL task, Execute package task, File System task.
• Used various data flow transformation in packages based on the business need such as Data conversion, condition split, multicast, union all merge, merge join, sort, etc.
• Extensively used variables, break point, check point, logging, package configuration and event handler in SSIS packages to meet the business needs.
• Created various staging tables for conversion purpose to cleaning the data while converting from old system to new system.
• Created configuration file for various SSIS packages to make package dynamic for deployment in various environment.
• Involved in creating jobs and alerts and scheduling it on daily, weekly and monthly bases.

Project Environment: MS SQL Server 2008R2, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence, Microsoft Visual Studio 2008, MS Excel.

Confidential, MN

SQL Programmer / SSIS ETL / Analyst / Reports

Responsibilities:

• Gathered functional requirements and Business requirements and wrote the technical specifications for building the Data model.
• Worked closely with end users in designing and creating the Data warehouse for management group using SSIS and Erwin.
• Implemented logical and physical database modeling using Erwin tool.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed and deployed  SSIS packages for ETL from OLTP and various sources  to staging and staging to Data warehouse using  Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Successfully implemented SCD transformation in SSIS and performed security.
• Created star schema for OLAP cube generation and extensively worked dimension modeling for analysis service using SSAS.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler in MS SQL Server 2005.

Project Environment: Microsoft SQL Server 2005 Enterprise Edition, Windows Server 2003, SQL Server Management Studio(SSMS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Business Intelligence Development Studio(BIDS), Oracle 10g, Microsoft Visual Studio 2005, IIS.

Confidential

MS SQL Server Developer

Responsibilities:

• Interacted with business users and analysts and gathered and documented the technical and business metadata.
• Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Designed database, tables and views structure for the new data mart.
• Successfully transferred old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2005 using SSIS Packages.
• Created complex stored procedures and functions for integrity checks of transferred data.
• Performed unit testing and SQL performance tuning.
• Helped provide end users with the ability to access and utilize the data stored in the data mart.
• Tuned SQL statements Using Indexes and stored procedures.
• Developed data access queries/programs using SQL Query to run in production on a regular basis and assists end users with development of complex Ad Hoc queries.
• Involved in implementation and maintenance of disaster recovery solutions such as replication and log shipping.
• Responsible for query optimization using MS SQL tools such as Query Analyzer, SQL Profiler, index tuning wizard.