We provide IT Staff Augmentation Services!

Business & Technical Analyst Resume

SUMMARY

  • Seasoned, solution - oriented and highly accomplished Data warehousing Professional with 11+ Years of solid experience in Application development with expertise in the areas of Data warehousing tools as such Datastage, informatica.
  • Strong Experience in designing, development, testing and maintenance of ETL based applications in Life sciences and banking domain using Datastage, Informatica, Teradata, Oracle, SQL, Unix.
  • Experience in Data Stewardship, Data Governance and Data Quality.
  • Experience in Datastage(8.1,8.5,9.1,11.3,11.5) and Informatica(9.6), Teradata, Oracle(11g, 12c) and Unix.
  • Experienced in Migration/Upgrade of ETL applications from 7.x, 8.x and 9.x to 11.x.
  • Extensive Experience in handling Massive Banking Data through Extraction, Standardization, Transformation, loading and performance tuning.
  • Experience various phases of Clinical Trials like phase I-IV and related topics such as Study Protocols, Review of Analysis plans, Submission of Clinical Study results to FDA\EMA, Specifications, Clinical Study Reports.
  • Extensively used Oracle database through-out several projects.
  • Experience in Scheduling Datastage ETL loads using Datastage Director, Cron tab scheduler and Autosys,Control-M.
  • Experience in all phases of Software Development Life Cycle (SDLC).
  • Experience in Automation tools like UiPath(RPA) and Tactix(AI).
  • Ability to work effectively while working as a team member as well as individually.
  • Excellent communication and Inter-personal Skills, well organized, goal oriented.

TECHNICAL SKILLS

ETL Tools: IBM Infosphere Information Server Datastage (8.x,9.x,11.x), Informatica(9.6)

Reporting Tools: Qlik View,Tableau

Database: Oracle| Teradata|SQL Server 2000 | SQL| MS Access|Composite

Operating Systems: Unix, Linux, Windows

Scheduling Tools: Autosys, Control - M

Tools: Microsoft Office, Incident, Problem and Change Management tools (Remedy), HP Quality Center, Toad, PL/SQL developer, SQL * Plus, WinSCP, Putty

Automation Tools: UiPath,TACTIX

Version Control Tools: SVN,STAR Team AND TFS

PROFESSIONAL EXPERIENCE

Confidential

Business & Technical Analyst

Responsibilities:

  • Lead a team of 10 members.
  • Involved in Design Discussions with Business Analysts of various midstream process to understand the requirements and prepared detailed Design Documents with impact analysis.
  • Interact with business users and global advisors to understand their needs on a daily basis.
  • Working as a Business and Technical Analyst to Maintain systems integration while handing ongoing changes and Datastage upgrade as well as Automation initiatives.
  • Handling the Data Quality of Blending data.
  • Interact with Test lead to define the test scope and approve the test plan based on the change scope identified for a month.
  • Working on a POC to automate the Jobs Monitoring and notifying the respective teams in case of failures using UiPath.
  • Working on a POC to deploy a SME by integrating with RPA which can provide predictive analysis based on the historical data.

Tools: and Technologies: IBM Infosphere Information Server Datastage 11.5, Teradata, Oracle 12c,Unix, TFS, UiPath, TACTIX.

Confidential

Project Lead, Sr. ETL Developer

Responsibilities:

  • Lead a team of 4 Developers and 5 Testers.
  • Involved in Design Discussions with Business Analysts to understand the requirements and prepared Design Documents.
  • Involved extensively in preparation and authoring of system requirements, Design documents, Unit Specifications, Design Review Repot, Source code Review report, Technical Installation Plan and Technical Installation Record and worked with QRC team to sign off the same.
  • Interact with business users to understand their needs on a daily basis.
  • Used Agile Software Development as the development methodology.
  • Sign off on Test cases prepared by Testing Team to make sure that they are in line with System requirements.
  • Worked as a Project Lead to support projects and co-ordinate with in the project to make sure all the deadlines are met with respect to development and Testing.
  • Involved in development of ETL to extract the Clinical Study data from Composite Database and prepare Clinical Study XMLs and securely transfer to Business team for verification using Datastage 11.5.
  • Involved in development of ETL to extract the Clinical Study Results XML from Business team and securely transfer US clinical Study results to FDA and EU results to EMA via third party using Datastage 11.5.
  • Involved in Implementation Activities of Datastage and Unix components.

Tools: and Technologies: IBM Infosphere Information Server Datastage 11.5,Oracle 12c,Unix, Composite (also known as Cisco Information Server (CIS)is a tool for integrating data sources in a virtualized warehouse),SVN

Confidential

Project Lead, Sr. ETL Developer

Responsibilities:

  • Lead a Team of 6 Developers.
  • With strong exposure on technical and domain knowledge handled Migration plan involving multiple vendor teams and within scheduled timelines.
  • Experienced extensively in fixing the issues raised in migrating to higher version.
  • Lead a Team of 6 Developers.
  • Experienced in compilation of Unit Test cases in order to perform Data reconciliations.
  • Involved in unit testing and documentation following GCP (Good Clinical Practices) coordinating with QRC (Quality Assurance, Risk Management and Compliance) team.

Tools: and Technologies: IBM Infosphere Information Server Datastage 11.5, Oracle 12c, Unix, SVN

Confidential

Project Lead, Sr. ETL Developer, Data modeler

Responsibilities:

  • Involved in interacting with HR team to understand the requirements.
  • Involved in understanding SAP HR Translations and developing Data model to accommodate the employee data.
  • Experienced in Data load using Informatica 9.6 into Oracle Database.
  • Coordinated with Reporting team to run through the requirements and develop reports for business users.
  • Involved in unit testing and documentation.
  • Driven the Implementation Activities of Informatica, Oracle and Unix components.
  • Worked as a Project Lead to support projects and co-ordinate with in the project to make sure all the deadlines are met with respect to development and Testing.

Tools: and Technologies: Informatica 9.6, Oracle 12c,Unix, Qlikview

Confidential

Project Lead, Sr. ETL Developer

Responsibilities:

  • Lead a team of 10 developers and 8 Testers.
  • Requirements gathering & analysis with business teams
  • Creating Technical solution design
  • Prepared high level and low level design documents for development purpose.
  • Coded SQL queries to retrieve data from the database depending on the need
  • Upgraded Datastage project from 7.5 to 11.3
  • Managed and resolved design issues during different phases of Project
  • Coordinated with multiple teams for development of respective modules
  • Created numerous complex queries involving joins and sub-queries for business requirements.
  • Extensively used Toad Oracle Developer tool.

Tools: and Technologies: IBM Infosphere Information Server Datastage 8.5, Oracle 12c, Unix, SVN

Confidential

Sr. ETL Developer, Tester, Test lead

Responsibilities:

  • Worked as Test lead and Onsite coordinator.
  • Worked as Developer and Tester in agile model in coordination with Onsite counterpart.
  • Experienced design decisions and effort estimations.
  • Took an Active Role in providing daily, weekly, monthly Status Updates (Developmental as well as QC updates for Testing Scope) as a Test lead.
  • Supported Go live Activities.
  • Worked for Enhancements.
  • Worked as an application Support Person.
  • Worked along with team for providing solutions to Business queries on time.

Tools: and Technologies: IBM Infosphere Information Server Datastage 9.1, Oracle 12c, Unix, TFS

Confidential

ETL developer

Responsibilities:

  • Involved in the design discussion to develop the mapping for all the batches of ODS.
  • Developed mappings for the various target loads in various modules like CRM, WMS, and TFIN etc...
  • Involved in developing the master sequence for 200+ batches and testing the resulting mapping
  • Involved in bug fixing during the SIT.
  • As a team member involved in delivering the code to confidential bank within all SLA's.
  • Involved in the performance tuning discussions in order to make the mappings effective.
  • Took the responsibility of developing the batches, testing, and integration and worked on the metadata for the entire module of CFS.

Tools: and Technologies: IBM Infosphere Information Server Datastage 8.5, Oracle 11g, Unix, SVN,STAR Team

Hire Now