Technology Analyst Resume

SUMMARY:

5.7+ years of experience in Data warehousing, Data Integration, ETL and BI.
2+ years of experience in Data Quality and Data Profiling using Informatica Power Center.
Extensively worked on Design & Development of ETL processes involving Data Quality and testing.
Extensively worked on Informatica 8.6 and 9.1 with industry standards.
Proficient in coding UNIX shell scripts for Informatica scheduling and file handling.
Extensive experience with Data Extraction, Transformation, and Loading (ETL) from disparate data sources like ORACLE, Teradata, DB2, Flat files, CSV files and Delimited files into a common reporting and analytical Data Model.
Working as an Onsite Lead and coordinating the tasks between onsite and offshore teams on a daily basis.
Experience in functional domains such as Insurance and Healthcare.
Experience in the full life - cycle of software development including requirements gathering, prototyping, proof of concept, design, documentation, implementation and testing.
Polished leadership skills. Led teams of 4 - 10 members.
Excellent online, oral and interpersonal communication skills.

TECHNICAL SKILLS:

ETL Tool: Informatica 8.6 and 9.1

Configuration Tools: VSS

Database: Oracle

Languages: SQL, PL/SQL

Scheduling Tools: Autosys, WLM

Script: UNIX Shell script

PROFESSIONAL EXPERIENCE:

Confidential

Responsibilities:

Played the role of Asset anchor and took complete care of system allocation and maintenance of 150 resource details across the whole Confidential Account.
Took overall responsibly of smooth installation of technology i.e. Informatica Power Center client, Teradata client & UNIX client along with the configuration of domains whenever required for approximately 150 resources.
Prepared Induction kit to conduct the programs for newly joined members on the account level

Technology Analyst

Confidential

Responsibilities:

Worked with the business users as well as technical teams in analyzing and understanding the existing structure of the framework and Data model.
Led the design team in coming up with data provisioning framework.
Worked alongside technology/application leads in segregating applications based upon their roles as source and consumers.
Led the design, creation and implementation of integration framework using Informatica Power Center and ORACLE.
Defined the collection strategy and integration of data from multiple enterprise business solution sources.
Managed design review and approval of solution designs, technical specifications, and ETL processing designs.
Ensured that all application code adheres to industry/company best practice design principles.

Senior Systems Engineer

Confidential

Responsibilities:

Generation of high level business reports and involved in the analysis.
Responsible for requirement gathering.
Design and development of strategy for the extraction and cleansing of data.
Analyzing the various impacts on other projects.
Development of BTEQ scripts and UNIX Scripts across the whole project.
Ensuring any technical environmental issues at offshore are closed without any impact on the project plan.

Systems Engineer/ Coordinator

Confidential

Responsibilities:

Coordinating a production support team from Infosys offshore with Cognizant offshore and cognizant onshore production team.
Responsible for monitoring ticket queues and resolving technical operation issues.
Responsible for participating in out-of-hours support duties.
Performed production implementations and solved production issues by working with development teams.
Ensuring any technical environmental issues at offshore are closed without any impact on the project plan.
Monitoring the databases used for the development of other projects running under same account.

Systems Engineer /Module Lead

Confidential

Responsibilities:

Lead for CR module.
In-depth analysis of the bteqs (existing in production)
Design of State response voids handling and re submission of void claims along with the replacements.
Development of the workflows & bteqs for re submission of void claims and their respective replacements.
Responsible for Code-Review and to ensure all the expected coding standards are adhered to.
Organizing/Conducting sessions for Newcomers to familiarize them with the project needs on daily basis.

Systems Engineer

Confidential

Responsibilities:

Design of State response handling and re submissions of claims.
Development of the workflows & mappings to handle complex Claims data.
Day to day work allocation and ensuring completion of the same within stipulated time.
Organizing/Conducting sessions for Newcomers to familiarize them with the various concepts in Teradata and Informatica.
Preparation of unit test plan, integration test plans and user test plans

Systems Engineer

Confidential

Responsibilities: