SUMMARY:

• 12+ years of experience in the IT/software field as a software developer and systems analyst and ETL architect.
• Eight years of experience in Data Warehousing/ETL programming.
• Worked in Agile and Full Life Cycle Implementations.

TECHNICAL SKILLS:

Big Data Platforms: Hortonworks Hadoop, Cloudera Hadopp, Hive Query Language

Reporting tools: Tableau

ETL Tools: Informatica 9.5, Informatica 9.1, IBM Ascential DataStage 7.5.1

Siebel Enterprise: Integration Manager (EIM), Siebel IFB scripts (EIM Process)

Programming Languages: PL/SQL, Unix Shell scripting, Autosys scripts, Microfocus Cobol

Database applications: Teradata, Oracle, DB2, SQL Server, Sybase, Informix, MS Access

Operating Systems: Windows XP, Windows Server 2003, Sun Solaris, HP Unix, IBM AIX

Other Technologies: Adobe Report Suite, Aster, Siebel Tools, Siebel Call Center, SQL Advantage, SQL Navigator, Toad, Oracle Developer, SQL Client, Tidal, Control - M, Reflection for Unix, Telnet, PuTTY, Harvest, IBM Clearcase, Remedy, Visual Source Safe, XPlanner, Bugzilla, Sharepoint and Mercury Quality Center, Various office applications including but not limited to Word, Excel, Powerpoint, Visio, and Outlook, Working knowledge with Siebel datamodel, Facets datamodel

PROFESSIONAL EXPERIENCE:

Data Analyst/ Data Scientist /BI Senior Systems Analyst

Confidential

• Participate in requirement discussions and transformed requirements into design documents
• Drive the collection of new data and the refinement of existing data sources.
• Collaborate with data infrastructure engineers on data selection, pre-processing and formatting for analysis
• Use programming languages, like SQL and Hive QL to interpret big data and search for different patterns in order to discover new insights.
• Write technical specification for developers
• Summarize written findings, publicize results
• Support management and business with insightful and clear analyses using the techniques; data mining; as well as explaining, creating, and testing data in order to provide a concise and clear report
• Presented business team the funnel visualization on Tableau for web tracking, presented capabilities by integrated various data sources like which channels drives visitors to tmo website and which keywords were most successful.
• Data governance and monitoring data quality.

Lead ETL Consultant

Confidential

• I was involved in the entire life cycle of the project.
• Participated in requirement meetings.
• Transformed requirements into design documents for Data Migration jobs to migrate data from various legacy systems.
• Developed Informatica mappings, reusable sessions, workflows and Siebel EIM Process.
• Parameterized the Informatica workflows to be environment independent.
• Developed Oracle Stored Procedure.
• Created Unix shell scripts to perform elementary file processing.
• Worked together with the offshore team and answered requirement and technical questions.
• Reviewed offshore code deliverables.
• Performed data cleanup and participated in performance tuning
• Supported UAT Users by quickly fixing bugs
• Performed PL\SQL performance tuning by checking the explain plan of the query and optimizing the query for best results.
• Worked with the Informatica deployment team to deploy the Informatica code on production.
• Developed the Autosys job script to load daily data from SAP into Siebel
• Provided post production tier-1 support.
• Performed data analysis to investigate any data issues reported by business users.
• Worked extensively with debugging and tuning of ETL mappings to improve the overall performance.
• Performed stale data cleanup and participated in performance tuning.
• Generated adhoc reports for business users for data analysis.
• Worked extensively on Siebel data audit.
• Helped identify problem data and provided solution to fix such data.

Senior ETL Consultant

Confidential

• Designed and implemented Informatica mapping and workflows, Oracle Functions and Packages.
• Performed data cleansing, data profiling and data transformation.
• Created Unix shell scripts to perform file processing and execution of Informatica workflow
• Prepared Unit Test Cases and documented test results.
• Documented Release information and versioned the database objects, ETL components in Harvest
• Provided Production release support
• Worked with client to troubleshoot data issues that arise.
• Enrollments were not completing due to a deadlock issue on the database. Proposed an index being added on a foreign key column which resolved the deadlock issue.
• Help SCM to create baseline versions in Harvest when version control tool was being moved from VSS to Harvest for change management system.

ETL Consultant

Confidential

• Involved in Requirement Gathering, Design, Code, testing and user support
• Designed and developed Datastage jobs to load Benefit Description System SQL Server tables from Facets 4.31
• Developed SQL Server and Sybase stored procedures.
• Versioned the database objects, ETL components in Harvest
• Implemented alerts to Plan Admin for missing benefit information and group information.
• Involved in support for Integrated and User Acceptance test.

System Analyst

Confidential

• Developed Informatica workflows for extracting data from mainframe legacy source system into to finance Datamart data mart.
• Troubleshooting, bug fixes and modification of existing functionality.
• Provided on call production support.

Developer

Confidential

• Development, Maintenance and enhancement for stored procedures in Billing and Invoice application.
• Responsible for analysis of the system and gather intricate details to assist in defining the PowerInvoice system.
• Played a major role in quality assurance activities.
• Prepared reports for the defects that occurred during the various phases of project life cycle