SUMMARY:

• 6 years of experience in SQL Server, ETL / SSIS and Reporting / SSRS Development.
• MICROSOFT SQL CERTIFIED PROFESSIONAL and expertise in SQL and analysis of Online transactional Processing(OLTP), data warehouse (OLAP) and business Intelligence (BI) applications.
• Development and Implementation of CDC (Change Data Capture) for ETL (SSIS) needs.
• Working with team of developers to design, develop and implement a BI solution.
• Worked to understand the business requirements and developed ETL Packages.
• Experience in developing data integration and data migration projects using SSIS.
• Experience in creating Store procedures, Functions, CTE’s, Cursors and Views using SQL Server DB.
• Experience in extracting data from heterogeneous data sources like Excel, SQL, CSV’s and Oracle and loading in SQL server using SSIS.
• Experience in SQL Query Optimization / Performance tuning according to the Needs.
• Experience in SSIS package development, configuration and deployment.
• Experience in scheduling ETL Jobs using SQL Server Job agent.
• Experience in SSIS/ SSRS Packages Unit Testing and Smoke testing in Production.
• Experience in developing Charts, Drilldown, parameterized, Matrix and ad - hoc reports using SSRS.
• Experience in creating error handling framework according to the SSIS packages Worked with GCS to Help Understand the Business in Various Domains.
• Experience in migrating packages from Development / test to Stage and Stage to Production.
• Creating/Debugging and maintenance of SQL/ T- SQL, Stored Procedure/Jobs.
• Proficient in all phases of the Software Development Lifecycle (SDLC).
• Expertise in maintainingdata quality, data organization, metadata and data profiling.
• Experience in User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Extensive experience with development, testing, debugging, implementation, documentation and production support.
• Generated DDL Scripts from Physical Data Model by using Forward Engineering technique
• Experience in Customer Interaction, Collecting and Handling Customer Requirements.
• In a data warehouse environment, designed the staging area based on OLTP concepts, cleansed and profiled before loading into data marts.
• Coherent with Normalization/Demoralizations techniques in relational/dimensional environments and have performed normalizations up to 3NF (Third Normal Form).
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS)

TECHNICAL SKILLS:

ETL Tools: SSIS

Reporting Tools: SSRS

Languages: SQL, SAS CLINICAL, SAS BI,VISUAL ANALYTICS,OLAP CUBE, HTML

Databases: MS SQL Server2005/2008,2014, MS Access, Teradata, DB2, PL/SQL

Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Dayton, Ohio

SQL Developer/Data Analyst

Responsibilities:

• Created and maintained SSIS ETL packages to extract data from different systems, and load variety of large volume data into data warehouse from different sources like flat file, Excel file.
• Extracted data from internal data warehouse system to SSRS
• Tracked trouble ticket request for request made by end users
• Development and Implementation of CDC (Change Data Capture) for ETL (SSIS) needs.
• Created ad-hoc reports
• Modified SP's and formulated basic coding and scripting to be utilized for reports within the organization
• Analyzed data models, data relationships, and dependencies for greatest optimization
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Performed functional and performance QA testing
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard, Developed different type of reports including: Investor Report, Customer Report, Accounting Statement Report, Delinquent Reports, by using SSRS and SQL Server 2008/2013.
• Scheduled and managed daily/weekly/monthly sales and operational reports based on the business requirements.
• Involved in gathering Report Development Specifications (RDS) and SOWs for creating reports.
• Developed parameterized reports which were used for making current and future business decisions.
• Developed Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports and Matrix reports using SSRS.
• Created reports that projected business goals for future.
• Used table variables and Common Table Expressions (CTEs).
• Worked closely with the offshore team in finding solutions to arising problems.
• Identify the associated Store Procedures and parameters used for the reports
• Involved in job scheduling and alerts.

Environment: Win7, SSIS, MS SQL Server 2014, Access, OBIEE.

Confidential, Mason, Ohio

Data Modeler/ Analyst

Responsibilities:

• The project involved in migrating data from source systems and is fed into the EDW (Enterprise Data Warehouse).
• This process includes extraction of data from source systems, applying transformations and loading the data after the query tuning and performance check.
• Understanding business processes / requirements and translate them into technical requirements.
• Design Data Stage packages to get data from source and move the data to data warehouse
• Experience working on Image and Capture Project, which extracts the information / Data from client and load it in the SQL Tables.
• Used SQL in Backend to create SP which is utilized inside SSRS and SSIS.
• Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.
• This ETL process uses many different Control Flow and Data Flow Components (like: For-each Loop, Execute SQL Task, File System Task, and Data Flow Transformations (Like: Data Source, Data Cast, Derived, Conditional, Union all, Import.)
• This project used heavy Variables Logics which makes it a dynamic Project; Variables were set on Package and Data level.
• Using Stored Procedures and Functions in execute SQL Task.
• Experience in creating Store procedures, Functions, Views, CTE’s and Triggers according to the development needs.
• The process of Extraction, transformation, compare and loading of the Data from DB2 into the Data warehouse is done using the Teradata Client Utilities like Fast load and Multi load. Coding of the processes is done using Teradata SQL .
• These Processes are scheduled to run daily, weekly or monthly. Teradata SQL and Client Utilities have played a significant role in migrating the data to Data warehouse and achieving the expected gains.
• Worked on defining different patterns and trends, relationships between different data sources.
• Interacted with the business users on regular basis to consolidate and analyze the requirements.
• Identified, formulated and documented detailed business rules and use cases based on requirements analysis, Involved in multiple projects with different business units.
• Identified the Entities and relationships between the Entities to develop a logical model and later translated the model into physical model.
• Worked on creating Source to Target mapping document and transformation rules for the designed data models.
• Created Design Fact & Dimensions Tables, Conceptual, Physical and Logical Data Models using Erwin tool.
• Used Normalization methods up to 3NF and De-normalization techniques for effective performance in OLTP systems.

Environment: Erwin 9.1, Oracle 11g, SQL Server, Crystal Reports, Windows 7, MS Office, Business Object

Confidential, DURHAM, NC

Data Modeler/Data Analyst

Responsibilities:

• Involved in requirement gathering and clinical data analysis and Interacted with Business users to understand the reporting requirements, analyzing BI needs for user community.
• Involved in logical and physical designs and transforming logical models into physical implementations.
• Normalized the data up to 3rd Normal form.
• Created Entity/Relationship Diagrams, grouped and created the tables, validated the data, identified PKs for lookup tables.
• Worked on creating data models for different disease types and disorders, pertaining to Epiedemology, Endocrinology, and Nervous disorders.
• Involved in modeling (Star Schema methodologies) in building and designing the logical data model into Dimensional Models.
• Utilized Erwin’s forward/reverse engineering tools and target database schema conversion process.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Redefined attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities.
• Developed ETL routines using SSIS packages, to plan an effective package development process, and design the control flow within the packages
• Designed data flows that extract, transform, and load data by optimizing SSIS performance
• Worked with slowly changing dimensions (SCDs) in implementing custom SCD transformations.
• Involved in loading the data from Source Tables to Operational Data Source tables using Transformation and Cleansing Logic.
• Integrated data from various Data sources like MS SQL Server, DB2, Teradata using Informatica to perform Extraction, Transformation, loading (ETL processes).
• Developed mappings, sessions and batches for relational & flat file sources and targets. Loaded data into target database from sources using Workflow Manager.
• Worked on stored procedures for processing business logic in the database.
• Performance query tuning to improve the performance along with index maintenance.
• Worked on the reporting requirements for the data warehouse.
• Created support documentation and worked closely with production support and testing team.

Environment: ERWIN 8.2, Oracle 11g, Toad, Windows OS, DB2, Crystal Reports,SSRS, SSIS, Business objects, SQL Server 2008

Confidential

Data Analyst Research Data Analyst

Responsibilities:

• Extensive data analysis to find the issues and anomalies in stored sources system .
• Interacted with Physicians and Researches to understand the reporting requirements and analyzing data using BI stack.
• Designed new planning strategies to make the data available in the required format.
• Worked with Researches and business users to validate the data.
• Created detailed data specifications document which is a source for ETL team.
• Supported ETL team in understanding rules for loading data into data mart.
• Wrote SQL prototypes against new strategic sources to confirm the numbers are showing the same.
• Maintained complete metadata in the Erwin model.
• Maintaining database change logs, Sub models.
• Extensively using the Erwin design tool & Erwin model manager to create and maintain the versions of the Data Mart.
• Helped testing team to create test cases and assist in unit testing.

Environment: ERWIN 8.2, Oracle 11g, Toad, Windows OS, DB2, Crystal Reports, SSRS, Business objects, SQL Server 2008