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 extract data from various sources flat file, XML file, Excel file, SQL server, Oracle, Access and loaded them into OLAP and OLTP systems by performing different kind of transformations using Business Intelligence Development Studio/SQL Server Data Tools.
• Created Dynamic SSIS packages using complex expressions, variables and control flow components such as For Each Loop, For Loop to loop over a directory to load inbound files coming daily.
• Worked as a developer in creating Stored Procedures, SSIS packages, triggers, tables and views and other SQL joins 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.
• Based on Business Report Design document, created SQL server Reports using SSRS 2008.
• Created Tabular, Drill-down, Drill-Through and Sub-Report and linked reports using SQL SERVER Reporting Services.
• Created a drill down multi parameterized report using SSRS, created shared dataset and data source.
• Creating Stored Procedures for reports generation.

Environment: MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services 2012, TFS.

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 Implemented ETL processes based on T-SQL, stored procedures, triggers, views, tables, indexes, constraints, user-defined functions and SQL Server Integration Services.
• Created a large number of stored procedures and used Common Table Expressions (CTE) and various kinds of User Defined Functions (UDF) in the stored procedures to make the code easy to understand and reliable.
• 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), Integration Services (SSIS), Import/Export Wizard, SQL Server Management Studio, T-SQL, Report Builder, Window 7, visual studio 2008.

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 (SQL Server, Flat Files) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration 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 Execute SQL Task, 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 support SQL Servers with ever-changing workloads, and achieving some level of predictable performance (or minimizing variance in plans and performance).
• Created Packages, Jobs and Sending Alerts using SQL Mail.
• Created parameterized Reports using SQL server 2008 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 SQL queries 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 SQL Server 2005, SSIS, SSRS, Microsoft Visual Studio 2008, SQL Profiler, MS Office 2003,Excel 2003, Windows NT/2003.

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.
• Worked with various tasks such as Control Flow (Execute SQL task, for each loop container, Data Flow task, File System task, FTP task etc.) and transformations such as Aggregate, Sort, Lookup, Fuzzy Lookup, Merge join, multicast, conditional split derived column, Export and Import columns 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.

SQL Server Developer

Responsibilities:

• Understanding of business requirements via interaction and through Business Requirements documents.
• Created new database objects like Procedures, Functions, Triggers, Indexes and Views using T-SQL in SQL Server 2005.
• Created SQL tables 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 developing Store procedures, views and other SQL joins and statements as per the requirement.
• Develop reusable reports by passing parameters based on business needs.
• Created Drill down report, Drill through reports, parameterized reports etc. in SSRS to 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.