We provide IT Staff Augmentation Services!

Etl Onsite Lead/business Analyst Resume

Mclean Va San Diego, CA

PROFESSIONAL SUMMARY:

  • 7 years of experience as an ETL Developer/Onsite Lead, ETL Tester, Associate Business analyst and Data Analyst.
  • Very strong professional background in Data warehouse development.
  • IT experience in the software engineering, processes and methodologies of SDLC and STLC.
  • Strong knowledge and experience in Insurance, Banking domains.
  • Experienced in client interaction to capture and document business rules, business and system requirements. Also, understanding client issues and translating into functional /technical requirements.
  • Skilled in project planning, estimations, analysis, designing, developing, testing and deploying ETL/Data warehousing projects.
  • Highly experienced in manual testing, System testing and UAT testing.
  • Experience in creating the requirement traceability matrix and performing the corresponding testing.
  • Skilled in developing Test strategy, test plans, test scenarios, test cases using standard template of MS Excel and in Quality Center (defect tracking system).
  • Involved in ETL Migration strategy, Data Lineage and defining the data granularity.
  • Good hands - on experience in creating Use cases, UI specs, Process flow, Change request, traceability matrix, technical design document, ETL Process design, ETL logic conversion, Deployment, Production Data volume estimation.
  • Experience in UNIX Shell scripting to provide effective solutions, creating Parameter files, Process Log files, Automated Archival of log files, Scheduling ETL jobs
  • Performed Advanced level Data warehouse testing, which verifies and validates the ETL Mappings, table loads.
  • Experienced in conducting requirement analysis meeting with stakeholders and creating business requirement document, scheduling meetings with development/test team for requirement walk through.
  • Trained on Agile best practices and Version One tool.
  • Experience working on Agile projects.
  • Experience working on different databases like Oracle, Teradata, Netezza and DB2.
  • Good Team player possessing good inter-personal, strong analytical and problem solving skills, communication skills, presentation skills, proven leadership qualities, mentored a team of developers with industry best practices.

TECHNICAL SKILLS:

ETL: Abinitio ETL Tool (Co>operating System: 3.0.4.3, GDE version: 3.1.3)

Data base: DB2, Netezza, Oracle SQL Developer, Teradata

Operating Systems: Windows, UNIX

Programming Languages: C/C++, UNIX shell scripting, SQL, JAVA (Basic)

Applications: MS Office Suite (Word, Visio, Excel, PowerPoint)

Other tools: Tivoli scheduler, QRM /TDM, Abinitio Meta data hub, Version One, Quality Center, ALM, Confidential

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA/San Diego, CA

ETL Onsite Lead/Business analyst

Responsibilities:

  • Working as Business system analyst to analyze and gather all existing source system information to develop data warehouse for LCR calculation and to improve data quality and consistency.
  • Planning user stories/tasks in Version one.
  • Worked on requirement document and data analysis.
  • As ETL lead/developer working with business to understand the requirement, creating mapping design to map all source to target details, creating technical design document as per requirements, developing ETL process based on requirement. Guiding other application developers to optimize code/process improvements.
  • Perform peer review and code optimize sessions within team.
  • Scheduling/Migrating projects to QA and PROD environments.
  • Supporting Production runs.

Environment: Abinitio (Co>operating System: 3.0.4.3, GDE version: 3.0.2)

Oracle SQL Developer

Confidential Bank

Responsibilities:

  • As data analyst- Data profiling, data analysis of all line of business source to check existing data related to LCR and map to target systems.
  • Writing queries for data analysis, data volume, data quality checks for existing data for LCR reporting
  • Worked with the stakeholders to gather business requirements for designing purpose.
  • Creating Source to Target mapping tracker. Creating Analysis reports.
  • As ETL lead- Gathering requirement for ETL development scope in the calculating LCR.
  • Active participation in Design, Analysis and project planning meeting to finalize design, implementation approach.
  • Creating technical design documents.
  • Developing Abinitio code based on requirement, guiding offshore team for code optimization.
  • Created test cases, entered in ALM to perform tests, logged defects. Helping testing team for system testing
  • Code review, Unit Testing, Design review, QA/ Production Implementation of code, Scheduling.

Onsite ETL Lead/Coordinator and developer

Confidential, Omaha, NE

Responsibilities:

  • Requirement gathering for Design.
  • Preparing high level design and project estimations.
  • Technical discussions with Client for design approach.
  • Helping offshore team members for designing and developing ETL processes based on the design.
  • End to end unit and integration testing.
  • Production rollout and Worked on Post implementation issues.

Confidential, Omaha, NE

Onsite ETL Lead and developer

Responsibilities:

  • Requirement gathering for Design and audit exception process.
  • Design the data vault design as per data model.
  • Develop the abinitio graphs based on the design in the form of Hub, link and satellite.
  • Design and develop Audit and exception process based on the model.
  • End to end unit and integration testing.
  • Production rollout and Worked on Post implementation issues.
  • Production support.
  • Production server migration activities.

Confidential, Chicago, IL

Onsite ETL Lead and developer

Responsibilities:

  • Working on various requirements gathering from End user for any new development or enhancement.
  • Clarify client issues and concerns regarding Application.
  • Understanding the business process and impact for the new requirements with System Analyst of the project.
  • Impact Analysis, design and developed the Abinitio graphs based on the requirement.
  • Unit and system testing of code.
  • Writing wrappers scripts in UNIX to run the Jobs.
  • Tivoli scheduler to schedule jobs.
  • End to end production migration of code from Development environment to production environment.
  • Worked on Post implementation issues.

Confidential

Offshore developer and coordinator

Responsibilities:

  • Interacting and coordinating with clients which accessed UNIX server locations.
  • Created common transmission id and password with restricted permissions and ACL’s.
  • Coordinate with all upstream and downstream to update the password changes.

Confidential

Offshore developer and coordinator

Responsibilities:

  • Understand and coordinate with Business analyst for requirements gathering.
  • Develop the Abinitio code based on design documents.
  • Daily status reporting with client on call.
  • Unit and system testing.
  • Production migration and implementation
  • Handled Post production implementation issues.

Confidential

Offshore developer and coordinator

Responsibilities:

  • Analyzed around 400 interfaces to identified Agent number field in the interfaces.
  • Run the Abinitio interfaces with new alphanumeric agent number.
  • Test the transformation function results to convert the string to Hex data type.
  • Validate the interface output file before and after change.
  • Coordinate with QC team for the QA testing.
  • Daily status reporting with the updates to client.
  • Writing wrappers scripts in UNIX to run the Jobs.
  • Use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.
  • Migrate the updated interfaces to production.
  • Handled Post production implementation issues.

Confidential

Offshore developer and coordinator

Responsibilities:

  • Identified all the landing zone, pre-run locations, interfaces, scripts and Abinitio related objects path to convert the old server location to new server location for the execution.
  • All database changes for the new server.
  • Project level parameters changes for new servers.
  • Coordinate with upstream team to update the changes with landing zone and pre-run locations.
  • Coordinate with UNIX admin to form the MFS and folders on the new UNIX servers.
  • All interfaces migrated from old server to new server.
  • Test the interface running successfully on new server.

Confidential

Offshore developer

Responsibilities:

  • Analyze all Abinito interfaces to filter out the agents apart from Confidential agents.
  • Run the interface with filter condition and test the interface output after changes.
  • Unit and system testing and creation of test results.
  • Writing wrappers scripts in UNIX to run the Jobs.
  • We use Tivoli scheduler to schedule jobs by raising the appropriate job scheduling requests.
  • Production migration of the impacted interfaces.
  • Post production implementation issues.

Hire Now