SUMMARY

• 14+ years of rich experience in the system development/ support life cycle of a project. ETL Developer specialized in working wif relational and Non - relational Database platforms, creating robust and reusable ETL frameworks for Data Warehouse.
• Excellent ability to successfully implement end-to-end ETL architecture and design for Datawarehouse and Business Intelligence.
• A quick learner who can absorb new ideas. Is focused on Automation of the process.

TECHNICAL SKILLS

ETL & Modeling Tools: IBM Infosphere DataStage 8.5/9.1/11.5/11.7 , Informatica

VisioUS Health Care: HMO, Utilization Management (Anthem, BCBS Michigan)

Databases: IBM DB2, Teradata, Oracle 8i/9i/10g/11g, SQL Server 2008/2012, and AS400

Programming Languages: PL-SQL, UNIX Shell Scripting, Python, Command Files, PostgreSQL, ASP, Java, C#, PHP, JAVASCRIPT, COBOL

Testing Strategies: Automation and Manual Testing

Project Management Tools: Clear Quest, JIRA Project Tracking, TFS, Github, SharePoint

Software development methodologies: Agile / Scrum / Waterfall Methodology

Scheduling Tools: Autosys, Tivoli, Control-M

File Transfer & Tools: FTP, SFTP, WinSCP, Putty, PgAdmin, Toad, Razor SQL, SQL Assistant, SQL Developer, SQL Navigator, SQLPlus, Remedy, HP-ALM, Winmerge

BI Reporting Tools: Tableau

PROFESSIONAL EXPERIENCE

Confidential

System Analyst

Responsibilities:

• Development, Quality Assurance, Reviewing, Deployment, Support
• Development in DataStage Jobs. (Transformations, JOIN, Lookup, Filters, Datasets, DB2 Connectors)
• Done Basic transformations in Informatica like Filter, Router, Lookup, Expr.
• Done Bteq, FLoad, MLoad in Teradata.
• Unix Scripting - Shell scripts.ython Scripting.
• Worked in DevOpsWorked in TDM
• Actively involved in Bug fixing and performance tuning the SQL
• Training for new members
• Root Cause analysis of SAP interface issues wif our system and done permanent fixes for those.
• Product Analysis Document
• Estimation and preparation of High-Level document
• Cognizant Technology Solutions, Kochi
• Coding (involves Creating Configuration files for Informatica Fast Clone data loads, Creating Green plum functions, Creating UNIX Shell Scripts for invoking the Fast Clone applications and Green plum scripts).
• Unit TestingWorked as on Onsite Coordinator for the project
• Worked as Database developer for the project.
• Maintaining Informatica Fast Clone scripts which handles data loads
• Greenplum Developer for a BI Report
• Product Analysis Document
• Estimation and preparation of High-Level document
• Involved in Knowledge Transition for all the Interfaces between Oracle and Greenplum
• Root Cause analysis of issues wif earlier releases.
• Attended PHP training for the project.

Confidential

DataStage Developer/QA Analyst

Responsibilities:

• Analyze business and IT requirements and contribute to systems & application architecture and design
• Perform hands-on application integration data engineering tasks that involve complex, large-scale, data footprints leveraging Business Intelligence (BI) & ETL technologies
• Performing enhancement and production defect which involves DW ETL tool as well UNIX.
• DataStage Developer for enhancement and production defect fix
• Automation of deployments in different environments.
• Working on the QA testing in QA tools. (HP-ALM), Code Repository - Github maintainance.
• Performing requirement gathering and analysis, estimation, preparing schedules, design and development, testing and deployment of application enhancements.
• Apply technical noledge using Teradata Tools (SQL Assistant) and using Teradata Utilities
• Develop and support Extraction, Transformation and Load process (ETL) using Informatica Power Center to populate Teradata tables and flat files.
• Performance Metrics or the feedback. The metrics values act as inputs for insightful calculations to be represented in dashboards that indicate the overall health of the project.

Confidential

DB Developer

Responsibilities:

• It is the world's largest, multi-carrier network for the ocean shipping industry. The services allow shippers to efficiently plan, book, manage, and analyze ocean freight shipments wif 40 leading carriers. Over 525,000 container orders are initiated on their platform each week, representing more than 18 percent of global ocean container trade. Their e-commerce platform offers a comprehensive range of e-commerce tools including: ocean schedules, booking, shipping instructions, bill of lading, tracking and tracing, electronic invoicing, and reports.
• The Track and Trace application provides an update to the client’s customers regarding the container’s current location, status etc. The Reporting Data Mart currently resides in the Oracle is planned to migrate to the fast and efficient Green Plum Data Warehousing appliance. The project involves the migration of tables from Oracle to Green Plum, their daily and adhoc data loads, report generation etc.
• Coding (involves Creating Configuration files for Informatica Fast Clone data loads, Creating Green plum functions, Creating UNIX Shell Scripts for invoking the Fast Clone applications and Green plum scripts).
• Unit Testing
• Worked as Database developer for the project.
• Maintaining Informatica Fast Clone scripts which handles data loads
• Greenplum Developer for a BI Report
• Product Analysis Document
• Estimation and preparation of High-Level document
• Involved in Knowledge Transition for all the Interfaces between Oracle and Greenplum
• Root Cause analysis of issues wif earlier releases.
• Attended PHP training for the project.

Confidential

Team Leader

Responsibilities:

• Project involves supporting a web-based retail application. It includes 3 tier models. It is basically a web application between business users and the suppliers of the Retail Client. The Oracle database is the back end and issues involving the database are dealt mainly. It is the main application as the contract between the business and supplier is developed here and have so many outbound applications related to it. It also has around 90 batch jobs that are run daily, weekly and monthly. It includes mainly analyzing of the Oracle database packages and the stored procedures and also Visual Basic codes that are used to have the access layer to the front-end application. The application makes use mainly Oracle 9i database objects.
• Worked as on Onsite Coordinator for the project.
• Actively involved in Bug fixing and performance tuning the SQL.
• Preparation of DOU document for the project.
• Involved in Knowledge Transition for all the Interfaces between SAP and our application
• Root Cause analysis of SAP interface issues wif our system and done permanent fixes for those.
• Identified the Service Improvement areas and worked on several Batch jobs.
• Training for new members.
• Doing Morning Checks, Daily and Weekly Status Report