SUMMARY:

• 11 years of IT experience in building and supporting applications in Retail, Healthcare and Pharmacy domains.
• Architected data warehouse from requirements gathering to conceptualization and implementation
• Strong in Data warehouse concepts, Data Modelling, ETL Architecture and Tools like Informatica Powercenter 9.6, Erwin 9.1 and Control - M.
• Achieved cross-domain success in the analysis and capture of data requirements, database design and application development within Teradata ecosystem.
• Hand-on experience in Hadoop ecosystem including data ingestion, pipeline design, Hadoop file distribution system and Hive
• Started the career in Mainframe technologies. Worked in application development and support of Mainframe applications.
• Instrumental in bringing automations as well as reusable tools and frameworks in various environments and projects.
• Demonstrated the ability to quickly adapt to changing priorities, requests, and environments.
• Excellence in analytical and problem solving skills.
• Ability to manage and work with multiple teams in different time zones and simultaneously handling multiple projects.

TECHNICAL SKILLS:

Business Intelligence: Data Modeling, Database Architecture Design, Requirements Gathering &Analysis, ETL Architecture, Informatica, Teradata, Control-M, Unix

Big Data: Sqoop, Hive, Infoworks for Ingestion and Pipeline design, Mapreduce, HDFS

Mainframe Technologies: Cobol, JCL, Easytrieve, Confidential, DB2, CA-7

Other Technologies: Excel

PROFESSIONAL EXPERIENCE:

Enterprise Data warehouse Build

Confidential

Responsibilities:

• Effectively handled requirements elicitation and data profiling by interacting frequently with the business teams and source system teams.
• Worked on modelling the Retail and PBM Data warehouses for Confidential Health. Involved in normalized as well as dimensional modelling design at various stage of data transformation.
• Worked in performance tuning of database schema, migrations and slowly changing dimensional databases.
• Provide inputs on solution architecture based on evaluation/understanding of solution alternatives, frameworks and products
• As a project lead took the responsibility of tracking the project activities against baseline project plan, while keeping the stake holders up to date.
• Performed Data cleansing and Data profiling for detecting and correcting inaccurate data from different sources and to track data quality and to assess the risk involved in integrating data for new projects.
• As an onsite lead, responsible for the effective Client Communication and offshore coordination.
• Conceptualized and built a strategy for late arriving dimensions and bad data from source. This improved the overall data quality and equipped Business with more sensible data to arrive at informed decisions.
• Created a tool to generate the SCD Type2 queries, which resulted in the 40% reduction in build effort for Type2 mappings.
• Created an automated testing tool for File to Stage workflows, which resulted in zero QA defect in the Stage load and 35% reduction in build effort for Stage workflows.

Application Support and Maintenance

Confidential

Responsibilities:

• Provided Level 2 and Level 3 support of Sales Audit and Accounts Payable applications in Mainframe. Also supported the jobs in Confidential ’s Enterprise Data warehouse.
• Handled the high severity calls and updated the Incident management team on the root cause and resolution.
• Responsible for tracking of recurring incidents and putting in place a permanent fix for these incidents.
• Created Weekly Status Reports for the applications supported and presented to the client.
• Worked on the high level design and build of Minor Enhancements in the supported applications.
• Reduced the incident ticket count by 28% within one year of taking over the application, by means of addressing most recurring incidents. Took the lead in doing the root cause analysis and putting in permanent fix for some of the issues which was persistent from the inception of these applications.
• Automated the Suspended Transaction Reprocessing in the Sales audit application, which along with other automation and tools reduced the Level 2 support effort by 25% by the end of 2nd year of application support.
• Came up with Peak readiness guidelines and checklist, which geared the team to sail smooth thru the peak season.

Mainframe Application Development

Confidential

Responsibilities:

• Worked on the creation of Finance Controlled Test Environment ( Confidential ) for Confidential Corporate Finance applications.
• Involved in the development of new applications within the Corporate Finance pyramid of Confidential .
• Created the High Level Design, Low Level Design, Coding and Unit testing of mainframe programs.
• Supported the System testing, Integration testing and User Acceptance testing in the pre-production environment.
• Created various Confidential tools to simplify the recurring and time consuming activities within the Application development. This helped improve the productivity of entire application development team of around 50 members.
• Achieved around 55% reduction in CPU time, taking up the performance tuning of top 10 long running jobs.