SUMMARY

• Over 9 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) developer and various segments of Software Development Life Cycle (SDLC), using MS SQL Server 2008/2008R 2/2012/2014/2016 DTS/SQL Server Integration (SSIS), Reporting (SSRS), QlikView, QlikSense, Microsoft PowerBI, Micro Strategy, Tableau & Analysis Services (SSAS) .
• Extensive SQL Development experience in Healthcare and Manufacturing Industries with a strong understanding of data & analytics.
• Proficiency in EPIC Clarity database models and Caboodle Data Warehouse.
• Proficiency in Data Warehouse design and Architecture, ETL Implementation on Health care organization and Manufacturing Industries.
• Solid experience in Database Modeling, Data Mapping, Transformations, Data Exports & Imports, Performance Tuning, Tuning & Optimization.
• An accomplished SQL, BI developer with demonstrated success in designing and implementing database solutions that improve business functionality.
• Possess diversified technical background with Microsoft SQL, SSRS, Netezza, Oracle PL/SQL, MS SQL scripting.
• Proven ability to implement technologies that decrease costs, increase performance and positively affect the bottom line.
• Experience in Requirements Gathering, Business Analysis, Business Process Redesign and Mapping, Testing & User training, Documentation of activities, processes, test scripts and results and Client Interaction.
• Strong work experience in MSSQL 2005/2008R 2/2012/2014/2016 , MS - SSIS, SSRS, SSAS, Stored Procedures, Functions, Constraints, Triggers, Views, Linked Servers, Export/Import Utilities.
• Extensive experience in using UNIX Shell Scripting, IBM Infosphere DataStage 7.5/8.1/9.1/11.5 , IBM Quality Stage Tools for Data Warehouse ETL, DB2 Mainframe/Non-Mainframe, Salesforce Database, MS SQL Server 2005/2008/2008 R2/2014/2016, Crystal Reporting, Big Data Hadoop, Hive, Sqoop, MS Access.
• Adept at all stages of project lifecycle, from business requirements and technical definitions to development, testing, user acceptance testing (UAT), production support, and completion.
• Experience in designing, development and implementing Extraction, Transformation, and Loading (ETL) techniques on multiple database platforms.
• Experience in Data Warehousing, Data Migration, Data Quality, and Data Cleansing.
• Strong work experience in Data Mart life cycle development, perform tune ETL procedure to load data from different sources into data marts and data warehouse.
• Good verbal and excellent written communication skills, supportable to relay technical information to non-technical staff and fellow developers.
• Involved in Production support, excellent problem solving and abstract thinking skills with proven ability to identify a problem, analyze possible solutions and determine the best course of action to meet stated objectives.
• Ability to learn at a rapid pace, work under strict deadlines, good at problem solving, excellent decision making skills, well organized, self-motivated, adaptable, responsible hardworking independent and team player with ability to manage multiple tasks efficiently.
• Expert Experience in Normalization and De-normalization .
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Skilled in Business Intelligence tools like Microsoft Visual Studio 2005/2010/2012/2015 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Experience in creating SSIS packages to automate the Import and Export of data to and from SQL Server using SSIS tools like Import and Export Wizard, Package Installation and BIDS .
• Expertise in building and migration of various DTS packages .
• Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reports using SQL Server Reporting Services.
• Excellent in rendering reports, managing subscriptions , creating reports with report builder, report snapshot and report cache.
• Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger .
• Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.
• Experience in SSIS Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Self-motivated and able to work independently as well as in a group environment with an active team player attitude
• Excellent technical and communication skills, interpersonal and analytical skills.
• Extremely motivated, able to work smoothly even under pressure, meet deadlines in advance, ready to accept new challenges and adapt quickly to new technologies.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft SQL Server 2005/2008R2/2014/2016, DB2

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business Intelligence Development Studio 2015

Reporting Tools: SQL Server Reporting Services, MS Excel, Power Pivot, Slicer Dicer, OLAP Cubes, Crystal Reporting and SAP Business Objects 4.0, Universe, WEBI Reporting (IDEA), Microsoft PowerBI, Qlikview, QlikSense, Tableau, Micro Strategy

Languages: SQL, Oracle PL/SQL, C/C++, C#

Databases: MS SQL Server 2005/2008R2/2014/2016, MS ACCESS 2003/2010, MySQL, Oracle 11gR2/12c, DB2, Netezza

Operating Systems: Windows XP, Windows 7, Windows 10, UNIX

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS) 2013 &2015, IBM info sphere Data Stage and Quality Stage and Administration client 7.5, 8.1, 9.1 and 11.5 versions

Hadoop Big Data Ecosystems: Hadoop, Hive, HDFS, Sqoop

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. Programmer Analyst ETL Developer

Responsibilities:

• Developed DataStage jobs to load from different source systems (Oracle, SQL Server, Netezza) to the respective Dimensions and Fact tables with required business transformations.
• Developed DataStage jobs to do ETL transformations with the requirement provided and load respective Dimensions and Fact tables.
• Used Netezza connector in DataStage ETL job for to read data from Netezza source table(s) and loaded data into Oracle destination tables.
• Involved in all phases of SDLC, created detailed Analysis-Design documents with source to target mappings.
• Worked within IT team to follow the full lifecycle development process working with development and technical operations
• Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions
• Work with other team members in establishing and sharing design and development techniques of the ETL process
• Solid knowledge of the UNIX/Linux environment
• Demonstrated ability to translate functional/high level design in detailed technical design
• Strong technical aptitude and ability to logically analyze and creatively solve complex issues independently
• Strong interpersonal skills and ability to work effectively with all levels throughout the enterprise
• Basic knowledge of Business Objects reporting tools like Micro Strategy, Tableau, etc.
• Extensive experience in data analysis and/or reporting along with strong knowledge of database and related technologies (SQL, OLAP, etc.)
• Connected to Hadoop hive for to query tables and pulled data from hive database into SQL Server using ODBC connector.
• Imported data from Oracle to HDFS, using Sqoop to load data.
• Worked closely with the Business Users to gather requirements.
• Responsible for converting functional requirement in to technical document.
• Experience in analyzing the multiple source systems and based on the business requirements build the transformation rules to extract, transform & load the data in the target systems.
• Using DataStage tool analyzed the source data to Extract & Transform from various source systems (Oracle, Netezza, SQL server and flat files)
• Experienced DataStage to extract the data from the Mainframe Source system to the Staging database.
• Developed and used the SQL Queries to validate the data in both source and target databases.
• Provided technical support to both business team and user departments for all projects.
• Consistently met deadlines and requirements for all production work orders.
• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Designed IBM Data Stage Tool and Quality Stage tool for Custom Data warehouse ETL Load with using lot of IBM transformations.
• Wrote SQL queries views, stored procedures, functions, triggers, sub-queries, CTE queries for financial data warehouse ETL Loading for facts and dimension tables.
• Developed SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005, and SQL 2016).
• Created Configurations to make package portable and created event handlers for handling package error.
• Inside SSIS dtsx packages used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed more complicated dynamic SSIS Packages using for each loop container and Sequence Container Parent and child SSIS Packages using Variables and C# script component task scripting, used other SSIS transformations for ETL Load for different data sources with flat files, excel files to move data from ORACLE into SQL Server Data warehouse for fact and dimensional tables in clinical data warehouse and financial data warehouse.
• Tuned SQL queries for better performance using SQL Profiler.
• Actively supported business users for change requests.
• Documented all work, so user can easily understand the flow of process.
• IBM DataStage Designer used to create the table definitions for the csv and flat files, import the table definitions into the repository, import and export the projects, release and package the jobs.
• Designed and developed jobs using IBM DataStage Designer as per the mapping specifications using appropriate stages.
• Developed Unix script to copy files from development server to production servers for testing Data stage jobs.
• Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions.
• Wrote UNIX shell scripts to read parameters from files for invoking DataStage jobs.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Used IBM DataStage designer and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an adhoc or scheduled basis).
• Worked on troubleshooting, performance tuning, performance monitoring and enhancement of DataStage jobs.
• Wrote several complex SQL queries on both MS SQL Server and in Oracle to extensively test the ETL process.
• Provided production support and performed enhancement on existing multiple projects.
• Worked on auto email alert with Unix scripting for setting up production job cycles for daily, weekly monthly loads with proper dependencies.
• Developed batch shell Unix scripts to copy the flat files, excel files to secure SFTP/FTP Servers using IBM Data Stage tool on sequence jobs.

Environment: Microsoft SSMS, SSIS, SSRS, Microsoft Visual Studio BIDS 2005 to 2015, IBM Data Stage, Netezza, Hadoop, Hive, Sqoop, IBM Quality Stage 7.5/8.1/9.1/11.5 , Oracle PL/SQL 11gR2/12c, DB2, Unix shell scripting, Micro Strategy, Tableau.

Confidential, Cincinnati, OH

Sr. Programmer Analyst ETL Developer/DW Architecture

Responsibilities:

• Experience with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.
• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Worked on EPIC Caboodle Data Warehouse on loading third party claim files from different payers into Caboodle Dimensional and Fact tables.
• Developed EPIC report writing for Resolute Hospital billing, EPIC Inpatient, Willow, Ambulatory, Professional Billing for Information Systems Group.
• Designed IBM Data Stage Tool and Quality Stage tool for Custom Data warehouse ETL Load with using lot of IBM transformations.
• Built patient matching rule sets on legacy third-party Insurance membership data using IBM Quality stage tool and created patient matching rulesets algorithm on pattern name matching and street addresses to load Insurance membership data into EPIC registries using EPIC Datalink load process into Chronicles.
• Developed complex ETL Stored Procedures on loading EPIC Clarity data into clinical data warehouse and financial data warehouse facts and dimensional tables.
• Involved in designing new facts and dimensional model with star schema and snow flake schema for Type-1 and Type-2 Dimensional for clinical data warehouse, financial data warehouse and EPIC caboodle Dimensional model.
• Handled huge amount of volumes of data of tables with EPIC Clarity on majority of modules with Resolute Hospital billing, Ambulatory, Willow, Inpatient and Professional Billing.
• Wrote SQL queries views, stored procedures, functions, triggers, sub-queries, CTE queries for financial data warehouse ETL Loading for facts and dimension tables.
• Created Analytical reporting using SSAS Cubes, Multi-dimensional cubes, Power pivot reporting, Excel pivot tables for financial analytic for cost and budget data.
• Worked on Third-party claims aggregation dealing with all Payers claims data files from Humana, Anthem, Aetna, Buckeye, United, EHP on membership, Pharmacy, revenue, claim header and detail files ETL loading into Caboodle Data warehouse facts and Dimension tables.
• Created staging tables and fact, dimensional tables in Clinical Data warehouse and Implemented ETL process using SSIS/IBM Data Stage tools as well SQL stored procedures to load fully history and incremental records into clinical data warehouse and financial data warehouse on fact and dimensional tables from different sources of data using EPIC Clarity and all third party legacy data into data warehouse.
• Developed SQL Server Integration Services (SSIS) to integrate and analyze data from multiple homogeneous and heterogeneous information sources (CSV, Excel, DB2, SQL 2005, and SQL 2016).
• Created Configurations to make package portable and created event handlers for handling package error.
• Inside SSIS dtsx packages used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.
• Developed more complicated dynamic SSIS Packages using for each loop container and Sequence Container Parent and child SSIS Packages using Variables and C# script component task scripting, used other SSIS transformations for ETL Load for different data sources with flat files, excel files to move data from ORACLE into SQL Server Data warehouse for fact and dimensional tables in clinical data warehouse and financial data warehouse.
• Designed cubes with star schema in SSAS and executing analysis services processing task in SSIS for processing cubes inside packages.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Developed complex stored procedures to generate various Drill-through reports, parameterized reports, tabular reports, matrix reports and linked reports using SSRS.
• Created project expense statements in all DataMart’s and other financial reports using SSRS developed yearly and quarterly company expense reports.
• Responsible for deployment of the SSRS report and used report subscription (Data Driven and Email) to publish reports.
• Tuned SQL queries for better performance using SQL Profiler.
• Actively supported business users for change requests.
• Documented all work, so user can easily understand the flow of process.
• IBM DataStage Designer used to create the table definitions for the csv and flat files, import the table definitions into the repository, import and export the projects, release and package the jobs.
• Developed ETL processes to extract the source data and load it into the enterprise data warehouse after cleansing, transforming and integrating.
• Imported metadata from repository, created new job categories, routines and data elements.
• Designed and developed jobs using IBM DataStage Designer as per the mapping specifications using appropriate stages.
• Developed Unix script to copy files from development server to production servers for testing Data stage jobs.
• Worked with Unix admin to resolved data stage bug related error.
• Developed job sequences to execute a set of jobs with restart ability, check points and implemented proper failure actions.
• Wrote UNIX shell scripts to read parameters from files for invoking DataStage jobs.
• Created source to target mapping and job design documents from staging area to Data Warehouse.
• Used IBM DataStage designer and its run-time engine to schedule running the solution, testing and debugging its components, and monitoring the resulting executable versions (on an adhoc or scheduled basis).
• Worked on troubleshooting, performance tuning, performance monitoring and enhancement of DataStage jobs.
• Wrote several complex SQL queries on both MS SQL Server and in Oracle to extensively test the ETL process.
• Provided production support and performed enhancement on existing multiple projects.
• Worked on auto email alert with Unix scripting for setting up production job cycles for daily, weekly monthly loads with proper dependencies.
• Developed batch shell Unix scripts to copy the flat files, excel files to secure SFTP/FTP Servers using IBM Data Stage tool on sequence jobs.
• Developed batch scripts to do PGP encryption on Linux servers to copy encrypted files to secure SFTP/FTP servers.
• Developed complex IBM Data Stage parallel and sequence jobs ETL process to load data into clinical data warehouse and financial data warehouse using different connectors like ODBC source to move the data from different sources into clinical data warehouse.
• Developed IBM Data Stage parallel and sequence jobs to export flat files, excel files from SQL server stored procedures, views and used Unix batch scripting to automate files into secure SFTP/FTP servers.

Environment: Microsoft SSMS, SSIS, SSRS, SSAS, Microsoft Visual Studio BIDS 2005 to 2015, IBM Data Stage, IBM Quality Stage 7.5/8.1, Oracle PL/SQL 11gR2/12c, Crystal Reporting, Unix shell scripting, Power pivot, SAP WEBI, Universe, Microsoft PowerBI, Qlikview, Tableau.

Confidential, Cincinnati, Ohio

Application Developer

Responsibilities:

• Involved in Designing, writing business logic using C#.NET.
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• The SSIS Packages include, a Master Package which executes a number of Child Packages. The packages created include a variety of transformations like Execute SQL Task, Script Task, Execute Package Task, File Connection, Derived Column, and For Each Loop.
• Used N-tier Architecture for connecting Presentation, Business Logic And Data Access Layer.
• Involved in requirements analysis and design of the project.
• Designed webpages using HTML, CSS Style Sheets, JavaScript and GUI Controls of asp.net 3.5 framework of front end screens.
• Designed and implemented database tables, stored procedures, constraints and views using SQL Server 2005 Management Studio.
• Used ASP.NET controls like Grid View, Detail View, List View, and Form View.
• Created Customized user controls(.ascx).
• Used OLEDB Connection to connect the SQL Server the App. Config File Used Commonly for all Webpages for the Connection.
• Used Form Authentication for the Web Applications Followed Certain rules of tags in web.config File.
• Used Inline, Embedded Style Sheets and Themes to Design Master Pages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created ad-hoc reports, drill down, and drill through reports.
• Created user define functions in SSRS using VB script.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Created ad-hoc reports, drill down, and drill through reports.
• Created Parameterized, Linked, Snapshot, Cached, Adhoc, Click through, Sub reports.
• Used Grouping, Global Variables, Expressions in Reports.
• Used Table, Matrix, List, Chart, Gauge Tablix Layouts for Reports.
• Used Grouping, Drilldown, Look and feel, Charts, Drill through, Paging, Header and footer, Sub reports, Calculations, Conditional Font, Color, Images in Reports.
• Used Stored Procedures, Views, Functions, joins for Datasets.
• Created SSIS Packages using Data Flow Task of Transforming the data from OLEDB Source to .CSV file, .txt, Excel Files.

Environment: ASP.NET 3.5, SSIS, SSRS, Microsoft Visual Studio 2005, SQL Server ADO.NET, CSS, HTML, C#, Web Services, Microsoft Business Intelligence Development Studio 2005.

Confidential

.NET Developer

Responsibilities:

• Involved in Designing, writing business logic using C#.NET.
• Implemented LINQ Query of connecting to Databases.
• Using LINQ Query to filter the data using GROUPBY, ORDERBY classes.
• Wrote Unit Test cases for few modules.
• Used Inline, Embedded Style Sheets and Themes to Design Master Pages.
• Implemented Forms Based Authentication.
• Implemented validation using validation controls for client side validation.
• Created Customized user controls(.ascx)
• Used ADO.NET for database connectivity.
• Developed the Data Access Layer using Microsoft Enterprise Library to support multiple databases.
• Developed the Stored Procedures to return data in XML Format.
• Able to conduct and assist the designing and development reviews.
• Created the GUI front-end screens as per the requirements using various GUI controls.
• Used ASP.NET controls like Grid View, Detail View, List View, and Form View.
• Login Status and Custom Controls. Used APS.NET AJAX Toolkit controls like Script Manager, Update Panel and Modal Popup Extender within some web pages.
• Generated Reports Using SSRS Business Intelligence.
• Used JavaScript for Client-Side Validations.
• Used Sitemaps in Master pages to Navigate to the Patients and Doctor Details modules.
• Used Query string to transfer the selected patient from patent details to patient information page of selected patient information is displayed.
• Used Session State to keep track how many times a user visited the web application to keep track the medical bill information of a patient.
• Created SSIS packages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a table to save dirty records.
• Extracted data from XML to SQL Server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated .
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.
• Created report models and deployed on report server.
• Created standard report subscriptions and Data Driven report subscriptions.
• Created report snapshots and cache for better performance.
• Designed, Implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Data migration (import & export - BCP) from Text to SQL Server. Used scripts and variables, email notifications for ETL process using Data Integrator in SSIS.
• Created and Configured OLAP Cubes (Star Schema and Snow Flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency .

Environment:: ASP.NET 3.5, SSIS, SSRS, Microsoft Visual Studio 2010, SQL Server 2008, C#, ADO.NET, WCF, CSS, JavaScript, Microsoft Business Intelligence Development Studio 2008, JavaScript.