SUMMARY

• Around 8 years of experience in Development and maintenance of database applications on SQL Server 2005/2008/2008 R2/2012 in OLTP/OLAP/BI environment.
• Extensive experience in Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS).
• Analyze and discuss the adaptations (client requirement) prepared by the functional team. Clarifications and conclusions follow.
• Work on various Business and Technical documents (Business Map, Business Change, Unit Test case, High level etc...).
• Worked Extensively on ETL process using SSIS package.
• Focused on Truncate & Load, Incremental (includes SCD) Loading by using various Packages.
• Experienced in creating simple, medium and complex packages by using normal and fast load options.
• Worked with Loop containers to continually repeat operations, Sequence container for transactional operations.
• Extensively worked on Data Flow task various sources, transformations (Derived, Lookup, Conditional Split, Sort, Merge etc...) and destinations.
• Used Execute SQL Task, Script Task and Execute Package Task when required.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.
• Implementing error handling, branching, check point operation, configurations and parameterization.
• Created simple, Medium and complex reports based on Business Report Design documents.
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Using variables, parameters and various expressions to implement business logics.
• Using various visualizations such as Table, Matrix, Chart, List, Indicator etc...
• Created Drill Down, Drill through and Parameterized reports.
• Participated in the bottlenecks elimination of various packages, reports and implemented tuning standards.
• Extensive experience in writing Transact - SQL(DDL/DML) queries.
• Experienced in writing queries by using SQL commands, keywords, functions, Sub Queries, joins and stored procedures etc.
• Reviewed & Tested packages and reports (Unit test, Report test and Reconciliation).
• Maintained versioning in Version Tools such as TFS.
• Acquired good knowledge on Data Warehousing and Data Model Fundamentals.
• Knowledge in DQS (Data Quality Services).
• Attended trainings on MSBI 2014 version.

TECHNICAL SKILLS

Languages: C, T-SQL, C#.Net.

RDBMS: Microsoft SQL Server 2012/2008 R2/2008/2005

ETL Tools: SSIS 2012, SISS 2008, SISS 2005

Reporting Tools: SSRS 2012,SSRS 2008R2,SSRS 2008,SSRS 2005

Web Technologies: HTML, XML.

SQL Server Tools: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SSIS, SSAS, SSRS.

Operating System: Windows 2000, Windows Server 2003, Windows NT, Windows XP/7/8.

Applications: MS Office, MS Outlook.

Version Tool: TFS (Team Foundation Server)

PROFESSIONAL EXPERIENCE

Confidential, Parsippany, NJ

SQL Server Developer/MSBI Developer

Responsibilities:

• I involved in gathering documents like High Level and Low Level documents, understanding, analyzing documents, creating packages and queries according to those.
• Successfully designed SSIS packages to extractdata from various sources flat file, XML file, Excel file,SQLserver, Oracle,Accessand loaded them intoOLAPandOLTPsystems by performing different kind of transformationsusingBusiness Intelligence Development Studio/SQL Server Data Tools.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such asFor Each Loop,For Loopto loop over a directory to load inbound files coming daily.
• Worked as adeveloperin creating Stored Procedures, SSIS packages, triggers, tables and views and otherSQLjoins and statements for applications.
• In case of changes we follow CR (Change Request) document procedure of the client.
• Different types of Data Loading (Direct, Incremental, SCD Type2 etc...) implemented using packages and used configuration files.
• Used lookup, derived, sort, merge, OLEDB command, etc... Transformations, various containers and tasks at control flow level.
• Written SQL queries and delivered results as per the client requirement.
• Writing various queries (duplications, tops, aggregate operations etc...) as part of reconciliation and business logics Validation.
• Used SQL commands and queries to monitor, reconciliation and manage packages.
• Performance tuning of packages when necessary.
• Ad hoc and Unit testing for packages.
• DevelopedPowerviewreports using Tabular Models inSQLServer Data Tools.
• Based on Business Report Design document, createdSQLserverReports using SSRS 2008.
• Created Tabular, Drill-down, Drill-Through and Sub-Report and linked reports usingSQLSERVERReporting Services.
• Created a drill down multi parameterized report using SSRS, created shared dataset and data source.
• Creating Stored Procedures for reports generation.

Environment: MS SQLServer2008 R2/2012, MSSQLServer Reporting Services 2012, TFS.

Confidential, Livingston, NJ

SQL Server/SSIS/SSAS/SSRS Developer

Responsibilities:

• I involved in gathering documents, understanding, analyzing documents, creating packages and queries according to those.
• I participated in Patients, Claims and Dispute area.
• Designed and ImplementedETLprocesses based onT-SQL, stored procedures, triggers, views, tables, indexes, constraints, user-defined functions andSQLServerIntegration Services.
• Created a large numberof stored procedures and usedCommon Table Expressions (CTE) and various kinds of User Defined Functions (UDF)in the stored procedures to make the code easy to understand and reliable.
• Generated server sidePL/SQLscripts for data manipulation and validation and materialized views for remote instances.
• Used SSRS to create customized reports, on-demand reports, ad-hoc reports and was also involved in analyzingmulti-dimensionalreports
• DevelopedSQLandPL/SQLscripts to transfer tables across the schemas and databases.
• Created Table, Stored procedures and defined functions.
• Worked on Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• As per Business Report Design document, generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-down and drill-through reports using SSRS.
• Created reports using Report Builder from OLTP and OLAP data sources and deployed on report server.
• Responsible for deployment of the report using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.

Environment: MS SQL Server 2008 R2, Reporting Services (SSRS), PL/SQL, Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL, Report Builder, Window 7, visual studio 2008.

Confidential, Philadelphia, PA

MS SQL BI developer

Responsibilities:

• I involved in gathering documents (Like High Level Design, Low Level Design, etc.), understanding and analyzing documents.
• Involved in Developing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQLServer, Flat Files) and loaded the data into target data sources by performing different kinds of transformations usingSQLServerIntegration Services (SSIS).
• Responsible for SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• Worked on various tasks and transformations like ExecuteSQLTask, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
• Created stored procedures, Triggers, User-defined Functions, Views.
• Responsible to supportSQLServers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Created Packages, Jobs and Sending Alerts usingSQLMail.
• Created parameterized Reports usingSQLserver2008 R2 Reporting Services.
• Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created various SQLqueries for customer reports, executive management reports and types of report types like tables, matrix, sub reports etc.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL SERVER 2008, MS SQLServer2005, SSIS, SSRS, Microsoft Visual Studio 2008,SQLProfiler, MS Office 2003,Excel 2003, Windows NT/2003.

Confidential

SQL Server 2008-R2, SSIS, SSRS

Responsibilities:

• I involved in gathering documents, understanding, analyzing documents, creating packages and queries according to those.
• Getting data from different data sources.
• Using different transformations like excel source, data conversions, lookup, OLEDB command, derived columns, OLEDB destination, etc.
• Loading these data into data warehouse like SQL Server.
• By using these data warehouse, based on client requirement we generate the multilingual reports in SSRS.
• Performance tuning of packages.

Environment: SQL Server integration Services (SSIS), SQL Reporting Services (SSRS), SQL Server 2008-R2, Windows Server 2003.

Confidential

SQL Server Developer

Responsibilities:

• Understanding ofbusinessrequirements via interaction and throughBusiness Requirements documents.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• CreatedSQLtables with referential integrity and developed queries using SQL.
• Experience in developing SSIS Packages.
• Created the SSIS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.
• Involved in developingStore procedures,viewsand otherSQLjoinsand statements as per the requirement.
• Develop reusable reports by passing parameters based on business needs.
• CreatedDrill down report, Drill through reports, parameterized reportsetc. inSSRSto develop the solution.
• Involved in Unit Testing and User acceptance testing (UAT).

Environment: SQL Server 2005, T-SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS-Excel.