PROFESSIONAL SUMMARY:

• 8+ years of Professional experience in IT industry and wide range of progressive experience in design, analysis, development, documentation, coding and implementation including but not limited to Databases, Reporting, Data Warehouse, ETL Design and BI Applications across wide industry verticals.
• Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling them on Pentaho BI Server.
• Experience in writing shell scripting for various ETL needs.
• Experience in creating complex mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Pentaho.
• Quick understanding of Relational Source Database Systems and data models for building accurate transformation logic that can be used in Data Migration and Data Integration.
• Support software developers with database operations including the development of complex SQL, tuning of DML and the creation of stored procedures.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Converted existing SSIS Package to Pentaho Integration jobs (Pentaho transformation and jobs).
• Used the Pentaho Enterprise Repository to: Create folders, store transformations and jobs, revise, delete and restore artifacts.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLE DB providers form the existing diversified data sources.
• Reviewed and optimized SQL queries, stored procedures, views & triggers from other developers to achieve maximum efficiency and scalability.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Experience in Oracle SQL query tuning
• Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries.
• Experience in understanding Source systems using given ER Models
• Exposure to Dimensional Data Models like Star and Snowflake Schemas
• Hands - on skills in legacy data conversions to CDISC SDTM data sets, good working experience in generating CDISC ADaM data sets and TLFs to support clinical study reports, ISS or ISE.
• Good communication skills with strong ability to interact with end-users, customers, and team members.

TECHNICAL SKILLS:

Operating Systems: UNIX (MAC OS X, AIX), Windows 98/NT/2000/XP

ETL / Report Tools: Pentaho, SSIS, SSRS

Languages: SQL, SAS 9

PROFESSIONAL EXPERIENCE:

ETL Pentaho Developer

Confidential - Austin, TX

• Developed ETL workflows and mappings to extract, transform and load data into target environments using ETL tools (Pentaho Data Integration)
• Good exposure to various data load strategies using ETL tools like Pentaho Data Integration.
• Responsible for the ongoing operation of the data warehouse and analytic environments to include advanced technical issues such as ETL performance tuning
• Developed test plans and performed unit testing by saving Pentaho jobs in enterprise repository and scheduled them to run in production on a daily/ weekly basis
• Designed extensions and enhancements and ability to enhance the schema and ETL process in order to provide functionality and performance
• Managed data integrity and accuracy of the data warehouse data and analytic environments
• Developed optimized SQL to implement ETL job steps using ETL tools such as SSIS and Pentaho
• Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse
• Involved in migration of large amount of data from OLTP to OLAP by using ETL Pentaho tool
• Monitored, diagnosed and repaired all data loading and processing packages to ensure data integrity of the analysis data
• Communicated data warehouse and enhancements to the DBA from the requested analysis enhancements

ETL Developer (SSIS/Pentaho)

Confidential - Chicago

• Involved in gathering, understanding and validating the project specifications
• Experienced in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snowflake Schema for generating reports using SSRS
• Designed, Developed and Deployed custom reports in MS SQL Server environment using SQL Server Reporting Services
• Experienced in administrating the created reports and assigning permission to the valid users for executing the reports
• Designed packages in SSIS with various complex transformations such as derived column, conditional split, lookup, aggregation, execute SQL task
• Created and maintained databases, tables, stored procedures, indexes, database check constraints, and business rules using SQL
• Developed SSIS packages in support of ad hoc and ongoing processes.
• Ensured compliance with HIPAA regulations and requirements
• Developed DTS packages to copy tables, schemas and views and to extract data from Excel and Oracle using SSIS
• Comprehend existing database and processes, and provide ongoing support, maintenance, and new development
• Produced ad hoc queries and develop reports using SQL Server Reports to support business needs
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history
• Actively and consistently supported all efforts to simplify and enhance the customer experience

Data Analyst /SSIS Developer

Confidential

• Gathered and analyzed business requirements from non-technical users and translated into detailed functional requirements to identify Entities and Attributes to build Conceptual, Logical and Physical data Models
• Performed data mining, modelling and hypothesis generation in support of high-level business goals
• Evaluated the quality of new data, systems and modifications to existing data solutions
• Partnered with Enterprise data teams such as Data Governance and Enterprise Data Platform (Data Lake) and identify the best place to source the data
• Stayed relevant with emerging tools and techniques in machine learning, statisticalmodelling & analytics
• Worked as a proactive partner to our Business partners by communicating effectively, gaining a deep understanding of requirements, managing expectations, and driving efficient solutions
• Experience in importing and exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility
• Created SSIS packages to extract data from the transactional and operational databases, transforming the data according to analytical and reporting business needs, and loading the data into a Data Warehouse or Data mart.
• Designed data model analyzed data for online transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Worked with SQL Server Integration Services in extracting data from several source systems and transforming the data and loading it into ODS.
• Troubleshooting data and reporting issues and work with various support teams to implement solutions.

SAS Programmer (Remote)

Confidential

• Involved in CRF (Case Report Form) annotations as per SDTM standards Version 1.4
• Derived analysis datasets, tables, listings and graphs to support Clinical trials Data Mgmt. (CDM)
• Reviewed protocol documents and Statistical Analysis Plans (SAP) for Good Clinical Practice (GCP)
• Created ADaM datasets by using Implementation Guide and Specifications
• Produced adhoc reports, summaries and listings requested by manager
• Used standard SAS macros to comply with department standards
• Worked with complex datasets to create custom reports using Proc SQL, Proc Freq, Proc Transpose, Proc Report, and Proc Means
• Performed QC of datasets and TLG using independent programming, output and code review
• Created SAS datasets from various sources like Excel datasheets, flat files and exporting
• SAS datasets to an external file in RTF, PDF and HTML format using SAS ODS
• Applied Date Slotting, Windowing, LOCF, Imputation logic as defined in SAP
• Generated Kaplan-Meier survival plots using Proc LIFETEST and Proc GPLOT
• Extensively worked on safety tables like AE, LB, VS

Programmer Analyst

Confidential

• Created Various complex reports using Crystal Reports for ship dock inventory
• Coordinate with ship dock inventory team to analyze processes and identify areas for improvement for ship repairs services
• Collaborate with internal stakeholders to assess and implement process improvements
• Measure results and iterate as needed towards a successful outcome
• Develop custom scripts and applications based on our project priority list
• Complete ad hoc reporting as identified by management team
• Support the Quality Assurance team to test reports and documentation
• Involved in Performance tuning and Query Optimization of stored procedures

Electronic Data Processing In charge

Confidential

• Managed the inventory flow through a custom software with Oracle backend and MS Access frontend
• Responsible for managing stock inventory, coding, price tagging and final billing of retail product