Onshore Business Analyst Resume

TECHNICAL SKILLS:

Database and programming language: SQL, PL, UNIX Shell scripting

ETL Tool: Informatica Powercenter v10.1.1

Teradata (SQL and BTEQ), Microsoft SQL Server, Oracle:

Other Tools: WLM scheduler, Control M Scheduler Python Programming Language

Big Data: Hive, Impala SQL, Spark using Python. Informatica Big Data Management (BDM), Informatica Data Quality (IDQ), Business Objects 4

PROFESSIONAL EXPERIENCE:

Onshore Business Analyst

Confidential

Responsibilities:

Requirement gathering based on the HL7 FHIR standards from various operational Source systems, involving members, providers, vendors data related to clinical observations and reports.
Evaluating differences between multiple source systems and identifying missing business elements in the existing data warehouse.
Creating the gap analysis and source to target mapping documents for updating existing logical data model, which could support the HL7 FHIR resource/profile requirements and standards.
Supporting product owners writing the business stories as part of the Agile project life cycle.
Writing business test cases and performing UAT on behalf of business to make sure data integrity and performance.

Onshore Business Analyst

Confidential

Responsibilities:

As Business Analyst, is currently involved in the following activities.
Requirement gathering based on various operational Source systems, involving Customer, products and reference data.
Evaluating differences between multiple source systems and come up with a logical data model for analytics purpose, which could support all existing consumers use cases, and meet industry standard data model.
Writing business user stories for the agile deployment.

Onshore Team Lead and Developer

Confidential

Responsibilities:

Maintaining and monitoring the existing batch ETL process, to make sure data is integrated, latest, consistent & available for analytical purpose.
Deployed Automation processes, to reduce manual efforts related to production batch process monitoring and validation.
Worked closely with business team, to help them with data enquiries, validation process, and with proposed enhancements to help with reporting needs.
Worked on production issue analysis and providing solution to meet data refresh timelines.
Worked on identifying gaps, analyze and solution identification through enhancement process.
Worked on Bug fixes on existing code, such as ETL logic issues, Error handling issues etc.
Proper documentation at each phase of project release cycle, during analysis, development, testing, and ongoing support.
Transitioning knowledge internally and across other cross functional teams as and when required.

ETL Development with Informatica

Confidential

Responsibilities:

DATA Requirements analysis based on BRD & FSD. Preparing Detail Technical Specification Document(TSD).
Designing table structures for new implementation. Cisco has certain standards and DATA flows from Relational Oracle source Database to Teradata DB. Oracle to Flat file and further in Teradata we had certain layers like Staging, EL(External Lookup), Work, 3NF, SV and BV(Business View) which were accessed by BO Universe for reporting.
Created new mappings & workflows to load data into the tables in the ETL flow which acted as source for the front - end Business Objects report.
Enhanced existing mappings to include additional attribute data and to enhance Business Object Reports.
Worked in BO4 BI Launchpad to test New/Existing BO reports with respect to DATA and performance.
Worked in $Universe, a scheduling tool hosted on Unix server which includes creation of new uprocs& tasks for running those workflows as per their scheduled timings and in order of dependencies in production. This tool can schedule not only informatica ETL code but DB packages or Shell scripts.
Worked on Kintana, a deployment tool to deploy uprocs, tasks, new PL/SQL packages, DB links, Tables, Informatica New/Modified XMLS into stage and prod.