Senior Software Engineer Resume
0/5 (Submit Your Rating)
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.