OBJECTIVE

• To obtain a challenging position utilizing my Eight plus years of strong IT experience in a well - established or dynamic growth-oriented software development organization.

SUMMARY

• Having around 8 plus years of experience in the field of Data Warehouse Architecture and Business Intelligence Developer/ETL Developer on Microsoft Technologies and IBM technologies including Intranet based applications.
• Over 8 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI)developer and various segments ofSoftware Development Life Cycle (SDLC), usingMS SQL Server 2008/2008R 2/2012/2014/2016 DTS/SQL Server Integration (SSIS), Reporting (SSRS) & Analysis Services (SSAS).
• Extensive SQL Development experience inHealthcareand 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 dat improve business functionality.
• Possess diversified technical background with Microsoft SQL, SSRS, SQL scripting.
• Proven ability to implement technologies dat decrease costs, increase performance and positively effect 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, IBM Quality Stage Tools for Data Warehouse ETL, MS SQL Server 2005/2008/2008 R2/2014/2016, Crystal Reporting, 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 inNormalization and De-normalization.
• Broad experience inQuery Optimizationandperformance tuning of stored procedures, functionsetc.
• 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 theImport and Export of datato and from SQL Server using SSIS tools likeImport and Export Wizard, Package Installation and BIDS.
• Expertise in building and migration of variousDTS packages.
• Extensive experience in creating several reports such asdrill down reports, parameterized reports, linked reports, sub reports, Matrix Reports and Chart reportsusingSQL Server Reporting Services.
• Excellent inrendering 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

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)

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

Databases: MS SQL Server 2005/2008R2/2014/2016, MS ACCESS 2003/2010, MySQL

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 and 8.1

PROFESSIONAL EXPERIENCE

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 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, Crystal Reporting, Unix shell scripting, Power pivot, SAP WEBI, Universe.

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.
• CreatedSSISPackages 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 inSSRSusing 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.
• CreatedSSISPackages 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 i 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.
• CreatedSSISpackages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases
• CreatedSSISPackages 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’s from XML to SQL Server.
• CreatedSSISpackages 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 usingSSRSto 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 2010SQL Server 2008, C#, ADO.NET, WCF, CSS, JavaScript, Microsoft Business Intelligence Development Studio 2008, JavaScript.

Confidential

.NET Developer

Responsibilities:

• Wrote Unit Test cases for few modules.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Wrote Stored Procedures and triggers to capture inserted, deleted and updated data from OLTP systems.
• Generated complex stored procedures and functions for better performance and flexibility.
• Created indexes for the quick retrieval of the data from the database.
• Defined constraints, rules, indexes and views based on business requirements.
• Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Developed the packages with monitoring features and logging so dat audit information of the packages and their execution results are loaded in to the audit table.
• Generated parameterized/Drilldown reports using SSRS and Crystal Reports.
• Used dynamic parameters in SSRS to enable/disable the parameters based on user selection.
• Scheduled Daily and weekly Jobs and Alerting using SQL Server Agent.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Built effective queries for high-performance reporting and rendered them to HTML, XML, PDF and Excel formats using Reporting Services (SSRS).
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
• Created queries for generating drill down reports in SSRS 2008.
• Formatted the reports using the Global variables, expressions and Functions.
• Used ADO.NET for database connectivity.
• Contributed in Manual Testing and bug fixing.
• Working with .NET server controls, web user controls and created user controls in ASP.NET.
• Involving in the development and Design of Web User Interfaces.
• Used ADO.NET in accessing and retrieving data from the SQL Server database.
• Involved in writing stored procedures, views.
• Developed the Webpages as Per the Requirement.
• Developed Web Applications using Ajax Controls Calendar Extender, File Upload, Accordion, Auto Complete Extender.
• Generated Reports Using SSRS Business Intelligence.
• Used ASP.NET controls like Grid View, Detail View, List View, and Form View.
• Implemented level of security depending upon user Requirements in webpages.
• Used web services to connect client and server application.
• Used N-tier Architecture for presentation Layer, the Business and Data Access Layer and were coded using C#.
• CreatedSSISpackages to clean and load data to data warehouse.
• Created package to transfer data between OLTP and OLAP databases
• CreatedSSISPackages 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.
• Used Notification services to generate error messages and send them to the user through e-mails, pager messages, and PDA as well as window messengers.
• Created ad-hoc reports, drill down, and drill through reports.
• Created user define functions inSSRSusing VB script.
• Reviewed and adjusted deliverables involved during SDLC involving database changes/development.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Manage Analysis management objects(AMO) using BIDS.
• Wrote distributed queries to extract data from different servers.
• Created and tuned stored procedures, triggers and tables.
• Created views by vertical partitions of tables.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.
• Successfully tested all task in staging and stored all versions of data using team foundation server(TFS).
• Designed Webpages Using CSS Stylesheets, Html, JavaScript.
• 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.
• CreatedSSISPackages using Dataflow Task of Transforming the data from OLEDB Source to .CSV file, .txt, Excel Files.

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