We provide IT Staff Augmentation Services!

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.

We'd love your feedback!