SUMMARY

• Over 8+ years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.
• Familiarity in Huge Data Migrations, using SSIS, Bulk Copy Program (BCP) and Bulk Insert (BI).
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Extensively worked on Control Flow Tasks such as Foreach Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, Send Mail Task.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, ADO NET Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, and ADO NET Destination, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Hands-on and star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
• Strong skills in writing MDX queries to access cubes data in SSAS, and creating feeds from OLTP systems.
• Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
• Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc).
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensively worked on data cleaning, and setting up the right filters for defects such as Carriage Return (CR), Line Feed (LF), Line break, Tab, and extra spaces in the string using Script Component in SSS and as well as wrote Trigger to fix these kind of defect entering through UI.
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Hands-on worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
• Experienced with front-end development using ASP.NET, C# with Visual Studio, version control using Visual Source Safe (VSS).
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.

TECHNICAL SKILLS

Databases: Microsoft SQL Server 2012/2008 R2/2008/2005, MySQL, PL/SQL, MS Access.

Tools: /Utilities: Query Analyzer, SSIS, SSRS, SSAS, MS Visio, Ervin, Business Intelligent studio (BIDS), SQL Server Management studio, Microsoft Visual Studio, Power Shell, Enterprise Manager, Profiler, ETL, Spotlight, Congo’s, and Tableau, Biz Talk, Todd, Oracle SQL Developer, WS-FTP, WS-sFTP.

Web Technologies: Microsoft .NET, ASP.NET, MVC4, ADO.NET, C#, PHP, HTML/XHTML, HTML5, XML, CSS, JavaScript, VISUAL STUDIO 2008, 2010, 2012, 2013, SHARE POINT 2010, QNXT OS.

Languages & Tools: Visual Basic, C, C++, C#, MS SQL.

Application Packages: Well versed with 2008/2007/Vista/XP Windows operating systems, MAC, Microsoft Office 2013 (Word, Excel, Power point) MS Access, MS Visio kaleidagraph, Adobe Dreamweaver, Adobe PageMaker, Corel Draw, and Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Phoenix AZ

SQL/MSBI Developer (Lead)

Responsibilities:

• Gathering requirements and analysis of the requirements related to the project and responsible for writing design documents and Business Approach Documents (B.A.D) for new projects.
• Actively involved in agile methodology and worked on development and production support that includes Deployment of SSIS Packages into Development, Testing and Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Extensively worked on Medicare Part D enrollment, eligibility reporting processes
• Writing SQL scripts for insert, update, merge and research for Services Tickets requested by business users in immediate attention.
• Created SQL Scripts for NPAlerts to populate the alerts in NP Tablets for eligible members.
• Extensively worked on data cleaning, and setting up the right filters for such as Carriage Return (CR), Line Feed (LF), Line break, Tab, and extra spaces in the string using Script Component in SSS and as well as wrote Trigger to fix these kind of defect entering through UI.
• Created separate logics for members, eligibility and provider and mapped as per their requirement in SSIS
• Development and enhances of SSIS Packages creating new logics, custom logic, custom mapping for new clients and as well as existing clients.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Closely worked part of DBA teams in the maintaining the databases and trouble shoots experiencing from the users
• Trouble Shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs
• Working with Managers, Project Directors to plan and execute the project provisions and efforts estimations.
• Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
• Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
• Extensively worked Design and develop SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Setting up the Server Connections, File paths, Parameters mapping, Expressions mapping in SSIS.
• Created and mapped the Various Results Sets and Variables wherever they needed SSIS.
• Extensively worked on The packages created included a variety of transformations, for exampleSlowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables withhigh level SSIS packageexecution.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Worked on development and implementation of SSAS cubes dimensions and their deployment and production support.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Wrote code in C# ASP.NET and to create desired Models/Views/Controllers Developed new Front-End Screens using ASP.Net VB.NET, WCF web forms.
• Responsible for the issues raised from the production and debugging and deploying the updates.
• Worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.
• Fine-tuned queries to make the reports run faster, worked on query run time analytics.
• Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Queries, Calculated Columns as per the requirement.
• Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.
• Created complex stored procedures and created many cascaded parameters in the reports using MDX and SQL queries.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Extensively worked on Design, development and enhancement of Tableau Reports and SSRS Report for day to day process.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.
• Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008 R2, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, SVN, Microsoft TFS, BIDS, Visual Studio.

Confidential, Phoenix AZ

SQL/MSBI Developer (Sr.)

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Testing and Production Servers, Creating, Scheduling and Managing the SQL Jobs by agile methodology.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Worked on Medicare Part D enrollment, eligibility reporting processes
• Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users
• Trouble Shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs
• Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
• Interacting with Managers, Project Directors to plan and execute the project provisions and efforts estimations.
• Worked on Data migration project by validating three source data row by row and field by filed
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
• Worked on development of SSIS package to generate excel reports individual and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
• Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
• Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
• Created logic in SSIS Package to make available members Current Medforce Activity/Statuses time to time.
• Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Extensively worked Design and develop SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results Sets and Variables wherever they needed SSIS.
• Extensively worked on The packages created included a variety of transformations, for exampleSlowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables withhigh level SSIS packageexecution.
• Worked on Execution of the paths depending on the success, failure or Completion of other tasks with precedence constraints and expressions to determine the workflow.
• Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in SSIS
• Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Worked on development and implementation of SSAS cubes dimensions and their deployment and production support.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Wrote backend code in ASP.NET and C# to create desired Models/Views/Controllers Developed new Front-End Screens using ASP.Net.
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
• Fine-tuned queries to make the reports run faster, worked on query run time analytics.
• Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.
• Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.
• Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.
• Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.
• Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Confidential, Chicago, IL

SQL BI Analyst Developer (Lead)

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project.
• Extensively worked on production support, that includes Creating, Scheduling and Managing the SQL Jobs.
• Trouble Shooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs
• Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
• Interacting with Managers, Project Directors to plan and execute the project provisions and work estimations
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources (DB2, Access, Excel) to centralized SQL Server databases to overcome transformation constraints
• Extensively worked Design and develop SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results Sets and Variables in SSIS as needed.
• Designed and executed packages which include direction of data flow, Column Mapping, Data dictionary and Metadata Flat file source and Flat file destination, OLEDB Source and OLEDB Destination using SSIS.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Wrote backend code in ASP.NET and MVC4 to create desired Models/Views/Controllers Developed new Front-End Screens using ASP.Net, also worked on VB.NET, WCF web forms.
• Responsible for the issues raised from the production and debugging and code deploying the updates of the front end website and dash board.
• Executed Analysis Services setup, tuning, cube partitioning, and dimension design including hierarchical and slowly changing dimensions.
• Worked on user defined hierarchies in SSAS including Parent-Child Hierarchy.
• Created and Configured OLAP Cubes using SSAS, Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Created data sources, data source views, dimensions, measures, measure groups, key performance indicators (KPI), perspectives, partition aggregations. And deployment and processing SSAS objects.
• As part of Business Intelligence and Reporting team, played a key role in Development and Maintenance of SSRS Reporting Environment.
• Implemented complex Report Parameter on selection criteria that transformed and report performance for report retrieval.
• Was actively worked in all phases of development cycle of SSRS report conversion project. This conversion project was replacing the existing crystal reports and received accolades for rapid report development and deployment.
• Created MDX queries to retrieve data from the cube and also to display SSRS reports.
• Designed and developed SQL codes for Tableau Reporting.
• Environment: Microsoft SQL Server 2012/2008 R2, 2008, 2005, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Confidential, Tucson, AZ

SQL BI Developer (Sr.)

Responsibilities:

• Actively involved in the gathering and analysis of the rules and requirements of project.
• Involved in project scope, schedule planning and project impact assessments.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS.
• Performed query optimization for faster processing of queries, developed stored procedures, user defined functions, triggers, indexes and views.
• Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document.
• Extensively used SSIS variables for storing the values, which are used in various components of Data Flow Task.
• Worked on execution of the paths depending on the success or failure of other tasks with precedence constraints to determine the workflow.
• Worked for performance tuning and optimization of SQL queries and indexes, automatic restart of SSIS packages after Failover or Failure.
• Used a variety of Data Flow Transformations, like Derived Column, Copy Column, Lookup, Data Conversion, Union All, Multicast and while developing the packages.
• Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Data Flow Task, Data Conversion, Foreach Loop Container, Lookup, Aggregate, OLE DB Command.
• Designed and implemented comprehensive backup plan and disaster recovery strategies to ensure high availability of data.
• Scheduled package execution using SQL Server Management Studio to execute packages on a daily/weekly basis.
• Developed error handling routines for packages using both script tasks in the error handling tab.
• Created and configured OLAP cubes using SSAS, assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Wrote Documents test cases corresponding to business rules and other operating conditions and generated the Weekly Test reports about Test status and Defects summary.
• Created and developed customized reports to satisfy business needs using SSRS.
• Developed Reports with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.).
• Deploying reports, creating report schedules and subscriptions. Managing and securing reports.
• Performed the appropriate documentation for all the projects for future reference.
• Created and Maintained documents to capture the different changes in SSIS packages.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to the Clients.
• Environment: MS SQL Server 2008/2005, MS SQL Server Integration Services 2008, MS SQL Server Analysis Services 2008, MS SQL Server Reporting Services 2008, T-SQL, Windows 7, PowerBuilder, ASP.Net, C#, SharePoint, Dashboard.

Confidential, Baltimore, MD

SQL Server Developer/ BI Developer

Responsibilities:

• Interacted with business users for understanding and gathering business requirements and involved in project planning.
• Created SSIS packages for data integration from various data sources like Access, and SQL Server 2008 into the operational SQL Server and deployed them by using configuration tools.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, CSV, flat file, Text Format Data.
• Acknowledged the potential Issues that occur during the package execution by redirecting the rows from source components to the error output.
• Developed Stored Procedures, Triggers, Tables and Functions with SQL Server.
• Worked on maintaining the data integrity by performing validation checks.
• Maintained records in Excel Spread Sheet and exporting data into SQL Server Database using SSIS.
• Created user groups and accounts for users generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to designated Managers and Clients.

Environment: MS SQL Server 2005/2008, Server Integration Services 2005/2008, MS SQL Server Analysis Services 2008, MS SQL Server Reporting Services 2005, T-SQL, MS SQL Visual Studio 2005, Crystal reports, C#, T-SQL, MS Office and MS Access.

Confidential, Virginia Beach, VA

Sr.SQL BI Developer

Responsibilities:

• Worked Design and develop SSIS (ETL) packages to validate, extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different task and transformations.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as, Mapping, Data Flow Task, Data Conversion, Foreach Loop Container.
• Worked on Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the handlers control flow to populate the special Log tables withhigh level SSIS packageexecution.
• Worked on Execution of the paths depending on the success or failure or completion of other tasks with precedence constraints.
• Designed and executed packages which include direction of data flow, Column Mapping, and Metadata using SSIS.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Executed Analysis Services setup, tuning, cube partitioning, and dimension design including hierarchical and slowly changing dimensions.
• Created and Configured OLAP Cubes using SSAS, Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers.
• Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.

Environment: Microsoft SQL Server 2003/2005 Microsoft Excel, SSIS/SSAS/SSRS 2003/2005, Microsoft Office, Crystal Reports XI Release, Microsoft TFS, BIDS, Visual Studio.