SUMMARY

• Senior Database analyst with 7.6 years of experience in design & development of Data warehousing solutions using Teradata.
• Involved in design, development, modify, integrate, test and implementation of end to end Data warehouse systems using ETL solutions, Teradata Tools & utilities, Mainframes, UNIX.
• Experience in interpreting functional requirements, data models and developing database structures to design, develop, implement and troubleshooting programming changes and modifications.
• Worked on Data warehousing environments having huge data loads built on normalized and dimensional modelling techniques.
• Key player in highly skilled project team involving redesigning, rewriting Confidential ’s end to end distribution business with exceptional planning and execution skills.
• Worked on time sensitive projects and influenced key design decisions in both Waterfall and Agile (scrum) methodologies.
• Strong analytical ability skills and quick adoptability.
• Ability to make decisions and provide solutions to the problems and user queries.
• Worked closely with business users in adhoc environment.
• Ability to lead, co - ordinate or supervise other colleagues in a team.
• Good understanding of Hadoop concepts.
• Ensure Quality deliverables while leading and driving complex projects to successful completion within the timelines.

TECHNICAL SKILLS

Tools: & Utilities: Teradata SQL Assistant, BTEQ, MLOAD, FLOAD, FEXP, Mainframes, HP Quality Centre

Database: Teradata, Oracle

Languages: SQL, JCL

Operating Systems: Windows, UNIX

Version Control: ENDEVOR (IBM Mainframes)

PROFESSIONAL EXPERIENCE

Confidential

Senior Software Engineer

Responsibilities:

• Solely responsible for the end to end solution developer for the project.
• Analyze system requirements and gather all business information for the same.
• Responsible for designing the applications related to Distribution and Transport systems across Confidential and align with the existing data model.
• Worked on multiple applications from multiple source systems.
• Designed and developed the end to end solution for the business requirements.
• Extensively used BTEQ scripts to handle the errors and to load the target tables as well as intermediate work tables.
• Loaded the data from multiple source systems into the Teradata objects using the load utilities.
• Worked closely with the End users to provide the data as expected and resolve the issues.
• Worked on multiple adhoc requests from different business users.
• Tuned long running and bad performance queries to make the job run in time successfully.
• Proactively identified and ensure business users informed about the risks & issues involved in the data.
• Analyze and recommend improvements in the processes.
• Provided technical support in database implementation and deployment.
• The project is to identify the Key Performance Indicators (KPIs) and report them to buyers for their analysis.
• Involved in building specific subject areas like sales, margin, budget, cost Etc.
• Designed and developed time dimensional tables.
• Extensively used BTEQ scripts to handle the errors and to load the target tables as well as intermediate work tables.
• Responsible for data Quality & Integrity checks.
• Responsible for mainframe and Teradata set up and lookup table and source feeds are available for development.
• Responsible for whole project life cycle including gathering business requirements and service handover.
• The process includes receiving the data from a third party server through integration and populate the table.
• Responsible for CA7 Scheduling and ENDEVOR version controlling.
• Responsible for data reconciliation checks at the end of each data load.
• Generated an automated E-mail to enable to users about the data load on a daily basis.

Confidential

Software Engineer

Responsibilities:

• Involved in preparing build environment and databases setup required for development environment.
• Responsible for complete code build by applying the business & technical rules.
• Using BTEQ, MLOAD, FEXP scripts to handle the errors, load intermediate work tables as well as to create reports in the specified format.
• Responsible for offshore build delivery and timelines.
• Performed data reconciliation checks across the various source and target tables.
• Worked on Impact Analysis and Implementation Plan.
• Involved in creating a separate data mart for all in scope customers of Barclays Bank at legal entity level.
• Using the Teradata utilities built the code mainframes environment.
• Responsible for providing support during SIT, UAT, OAT, LIVE IMPLEMENTATION and closing defects if any.
• Provided a one month warranty support and handed over the project to the support team.
• Understand and analyze the requirements and the functionalities involved in the project.
• Migrated the code from Mainframe environment into UNIX environment without impacting the business functionality specific to multiple countries.
• Coded all members required for project development i.e. BTEQ, MLOAD AND FLOAD Import scripts as per Barclays Standards.
• Execution of the scripts and preparation of Unit Test Report.
• Performed Reconciliation check between source and target.
• Data separation part in the project.
• Analysis of the specifications provided by the clients.
• Collected Database details, Data separation rules (Business & Technical), Table level details, data separation criteria from the Subject Matter Expert (SME) discussions.
• Preparing deliverables related to data separation.
• Documented high level design and low level design documents.
• Applied data separation criteria in the development environment and getting only the necessary data.
• Preparation of Unit Test Plan and Unit Test Cases.
• Execution of the scripts and preparation of Unit Test Report.
• Validated the test cases using HP Quality Center.