SUMMARY

• Microsoft Certified Professional with over 11+ years of proven experience in the Information Technology industry in areas such as software analysis, design, and development using Microsoft Business Intelligence Suite.
• Expert in Physical database design techniques like Normalization and De - Normalization.
• Strong hold in Database and Data warehousing concepts, Multidimensional Analysis.
• Expertise in scripting T-SQL queries, complex stored procedures, user defined functions (UDF), Database triggers using tools like SQL profiler, and database tuning Advisor (DTA).
• Proficiency in using different Transformation tools like DTS packages, BCP and Bulk Insert as well as SQL Server Integration Services (SSIS).
• Experience of using VB.Net as scripting language for SSIS Script task which were used to control the flow of SSIS package.
• Extensive experience in designing and developing rich user experience reports using Matrix, Tabular, Drill down/up, Drill through, Charts, and Sub Reports features using Business Intelligence Development Studio (BIDS) and SQL Server Data Tools.
• Knowledge in working with all Collections in reports like Fields, User, Parameters, Variables and Report Items.
• Strong expertise in Data modelling using tools such as ER-Win 9/8, MS-Visio.
• Very good knowledge and real time working experience in Logical & Physical Data modeling (Relational).
• Strong hold in Database and Data warehousing concepts.
• Experienced in creating complex SSIS packages, using various transformation package parameters and variables. Import export wizard and bulk insert.
• Expert in creating configuration files, error handling, logging, deploying, and execution of SSIS packages in various environments like development, testing and production.
• Proficient in MS SQL Server 2000/ 2005/ 2008 /2012 advanced database programming concepts such as cursors, stored procedures, functions, view, and CTE.
• Good knowledge of using various MS SQL Server tools/wizards such as SQL Profiler, Performance Monitor Index Tuning Wizard tuning MS SQL Server performance
• Experience in working with OLTP and OLAP Data models.
• Good experience in complete ETL cycle, including data analysis, database design, data mapping, and conversion and data load.
• Proven experience of functioning as an project coordinator between on-shore and off-shore Team
• Engaged in performing code review of code written by peer developers
• Experience of managing a team of Software Developers.
• Extensive experience of working on completely new projects as well as existing product enhancement and customization
• Experience of providing Production support (24 X 7) for Business Intelligence applications.
• Good knowledge of Systems Development Life Cycle (SDLC)/ Software as a Service (SaaS) delivery models.
• Experienced in interacting with business users to analyze the business process/ requirements, transforming requirements into specifications, documenting, and rolling out the deliverables.
• Good knowledge of various domains such as USA HR and Payroll, USA Benefits, Insurance, Re-Insurance and Pharmaceutical and Billing

TECHNICAL SKILLS

Languages: C, C++, Visual Basic 6.0, VB.NET, C#, JavaScript, VBScript, HTML, SQL, XML

Technologies: ASP.NET (.NET Framework 1.1/ 2.0), ASP 3.0 (Legacy ASP)

Databases: MS SQL Server 2000/ 2005/ 2008 , MS Access

BI Tools: MS SQL Server Integration Services (SSIS), BIDS, MS SQL Server Reporting Service (SSRS)

Platform: MS Windows

Version Control: TFS, VSS, SVN

PROFESSIONAL EXPERIENCE

Confidential, Basking Ridge, NJ

Senior Business Intelligence Developer

Responsibilities:

• Worked closely with Managers, Project Managers, Technical Managers and subject-matter experts to obtain requirements, objectives, and business rules for projects and translate them into functional and non-functional specifications document, for BI and applications for the various business users like Actuaries, underwriters etc.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers).
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from heterogeneous information source (DB2 files from Main Frames).
• Created complex Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified/optimized already existing stored procedures, triggers, views, indexes according to the new design requirements.
• Created complex Stored Procedures which are used to calculated & validate financial data.
• Used SQL Profiler to debug/optimize SQL queries/Stored Procedures fired using User Interface (UI).
• Implemented the slowly changing dimensions (SCD) type 1 and type 2 to maintain current information and history information in the dimension tables.
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All tasks in SSIS packages in Coding, testing, implementing SSIS packages.
• Involved in data profiling, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Designed and developed ETL solution using MS SQL Server and SQL Server Integration Services (SSIS).
• Used Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component while creating SSIS Packages.
• Designed and developed reports using SQL Server Reposting Services (SSRS)
• Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Report Models Drill Down Reports
• Took Data Base Backup from various environments and restored it on Dev/Test environment, so that latest schema and data would be available for testing.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly Load.
• Wrote batch file to use SQL BCP Utility to import data from various sources
• Created Filtered reports using report parameters and cascading parameters.
• Documented whole ETL Process using MS Visio.
• Used TFS for version control and configuration management.
• Created detailed source to destination (target) mapping documents explaining things like business rules, error handling strategy, restart/reload strategy etc.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, SQL Server Management Studio (SSMS). Visual Studio 2012, Windows Server 2012, Microsoft TFS, SharePoint, MS Office, MS Access, T-SQL and SQL Profiler.

Confidential, CT

Senior Business Intelligence Developer

Responsibilities:

• Worked closely with Managers, Project Managers, Technical Managers, subject-matter experts, and data modelers to obtain requirements, objectives, and business rules for projects.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers).
• Involved in data profiling, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Designed and developed ETL solution using MS SQL Server and SQL Server Integration Services (SSIS).
• Created detailed source to destination (target) mapping documents explaining things like business rules, error handling strategy, restart/reload strategy etc.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Extensively used SQL Profiler to debug and optimize slow SQL queries/Stored Procedures.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SQL Server Reposting Services (SSRS).
• Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports.
• Designed Complex SSIS packages to load the data from different sources like Oledb, Excel, Flat Files and DB2 etc. into various Data warehousing system.
• Interacted with offshore BI development team, for distribution of work.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily/Weekly Load.
• Scheduled the monthly/weekly/daily reports to run automatically and delivered to user’s mailbox.
• Documented whole ETL Process using MS Visio.

Environment: MS SQL Server 2008r2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, SQL Server Management Studio (SSMS). Visual Studio 2012, Windows Server 2012, Microsoft TFS, SharePoint, MS Office, MS Access, T-SQL and SQL Profiler.

Confidential, Dallas, TX

Senior Business Intelligence Developer

Responsibilities:

• As a primary member of the BI/ database team, started at onsite for requirement understanding and analysis
• Interacted with Business Analyst/client for design discussions, walkthroughs, and database status reporting
• Led the development efforts on the BI and database side
• Reverse engineered legacy SQL code and created understanding write-ups
• Involved in data profiling, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Extensively SQL Profiler to debug and optimize slow SQL queries/Stored Procedures.
• Designed the event driven parallel queue-based/ SSIS-based ETL solution for parallel loading of data extracts and creating/ maintaining the data dictionary
• Designed summary tables for optimizing reporting performance
• Designed Complex SSIS packages to load the data from different sources like Oledb, Excel, Flat Files and DB2 etc. into various Data warehousing system.
• Implemented the slowly changing dimensions (SCD) type 1 and type 2 to maintain current information and history information in the dimension tables.
• Prepared custom reports using SQL Server Reporting Services 2012
• Created graphical representation of data in reports by using graphs (such as Bar, Column, Pie) for quick data analysis and trending using SSRS.
• Designed and developed multiple drilled down and drill through reports to integrate summary and detail data alongside using SSRS Report Designer
• Formatted the reports using the Global variables and expressions.
• Created SSRS reports for GAP/ cohort analysis, and frequency reporting
• Created Filtered reports using report parameters and cascading parameters.
• Scheduled the monthly/weekly/daily reports to run automatically and delivered to user’s mailbox.
• Provided database support to application/ QA team requests that included script promotion, deployments, cleanups, master reference data maintenance, database backups, and model updates
• Conducted KT sessions, and performed database code/ SSIS package reviews
• Provided guidance to less-experienced staff members

Environment: MS SQL Server 2008r2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, SQL Server Management Studio (SSMS). Visual Studio 2012, Windows Server 2012, Microsoft TFS, SharePoint, MS Office, MS Access, T-SQL and SQL Profiler.

Confidential, Nashville, TN

Senior Business Intelligence Developer

Responsibilities:

• Actively involved as a part of BI Product Development team, particularly in design and development of staging area, global reference database, data warehouse, and data mart
• Interacted with Business Analyst/client for design discussions, walkthroughs, and database status reporting
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Created various database objects like Tables, Indexes, Views, and functions.
• Used SQL Profiler to debug Stored Procedures giving incorrect result.
• Involved in data profiling, data mapping, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SQL Server Reposting Services (SSRS).
• Participated in maintenance and L3 support for solutions deployed at client locations
• Designed and developed ETL solution followed by implementation of ETL routines using SSIS
• Involved in data profiling, identifying data quality issues, and performance tuning of the model and ETL routines
• Extensively involved in writing and performance tuning T-SQL code
• Interacted with offshore team to explain them project requirements and distribution of work.
• Responsible for code reviews
• Provided guidance to less-experienced staff members

Environment: MS SQL Server 2005/ 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Visual Studio 2010 and MS Visio.

Confidential, Nashville, TN

Senior Business Intelligence Developer

Responsibilities:

• Interacted with Business Analyst/client for design discussions and walkthroughs
• Extensively wrote SQL scripts/ stored procedures in Transact SQL Server language
• Used Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all, Script component while creating SSIS Packages.
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Extensively used SQL Profiler to debug and optimize slow SQL queries/Stored Procedures.
• Involved in data profiling, data mapping, and identifying data quality issues by performing data analysis, impact analysis, and data model enhancements
• Created Complex reports like Parameterized reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports using SQL Server Reposting Services (SSRS).

Environment: MS SQL Server 2005/ 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Crystal Reports 11.5, MS Visual Studio 2010 and MS Visio.

Confidential, Nashville, TN

Senior Business Intelligence Developer

Responsibilities:

• Interacted directly with client to understand the project requirements
• Involved in data profiling, data mapping, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Extensively involved in writing SQL scripts/ stored procedures in Transact SQL Server language
• Used SQL Profiler to debug and optimize slow SQL queries/Stored Procedures.
• Documented code and data structure
• Created complex Reports like Parameterized reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports using SQL Server Reposting Services (SSRS).
• Designed large number of reports using single value parameters, multi value parameters and Cascading Parameters using SSRS.

Environment: MS SQL Server 2005/ 2008, MS SQL Server Reporting Services (SSRS), MS Visual Studio 2010 and MS Visio.

Confidential, Nashville, TN

Senior Business Intelligence Developer

Responsibilities:

• Interacted directly with client to understand the project requirements
• Engaged in OLAP data model development, coding, optimizing, and unit testing SQL objects (procedures/ functions/ triggers)
• Involved in data profiling, data mapping, identifying data quality issues by doing data analysis, impact analysis, and data model enhancements
• Explained the gathered requirements to Junior Developer of team.
• Wrote scripts and Stored Procedures in Transact SQL Server (T-SQL) language
• Used SQL Profiler to debug Stored Procedures giving incorrect result.
• Designed and developed ETL solution using Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all, Script component of SQL Server Integration Services (SSIS).
• Created complex Reports like Parameterized reports, Sub Reports, Linked Reports, Charts, Drill through, and Drill down Reports using SQL Server Reposting Services (SSRS).
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters using SSRS.
• Performed code review and optimization of code written by junior team member
• Documented code and data structure

Environment: MS SQL Server 2005/ 2008, MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS Visual Studio 2008 and MS Visio.