ETL Analyst and Developer Resume Florida - Hire IT People

SUMMARY

Total 11 years of experience which includes data warehousing - development of ETL process using Data Stage (8 Years), Sybase & Unix (3 Years).
This also includes 1.3 Years at On-Shore (Florida)
Certified Info Sphere DataStage developer with excellent experience in designing Datastage jobs, troubleshooting and fixing defects.
Good knowledge of Databases like Oracle, Confidential, Sql Server.
Good Understanding of Software Development Life Cycle and sound understanding of Agil development model
Knowledge of Quality process and commonly used quality documents

TECHNICAL SKILLS

ETL Tools: DataStage 8 *(PX), DataStage 7.5.2(Server)

Database: Oracle 9i, Confidential 6, Confidential 12.0, SQL Server 2000.

DB Query Language: SQL, PL/SQL, TSQL

Scripting: UNIX Shell scripting, DS Routines.

Scheduling Tool: Autosys

Configuration Tool: VSS, Harvest

Operating System: MS Windows, Unix (AIX, HP-UX)

PROFESSIONAL EXPERIENCE

Confidential

ETL Analyst and Developer

Responsibilities:

The Confidential is one of the largest mutual life-insurance companies in the Confidential, and one of the largest life insurers in the world.
The project is mostly maintaining the existing jobs for a better performance and if needed create new jobs as per the business requirement.

Environment: Data Stage 8.5 (PX), Oracle

Confidential

Lead & ETL Developer

Responsibilities:

Confidential is an oldest mobile telecommunications company.
It claims to have the widest and most extensive coverage nationwide, compared to others.
The dataware house is collection from multiple sources few are database and rest are file based source through Landing or Staging area.
Data get loaded to landing area in case of Database based jobs and ETL process pulls the data and loads into EDW area.
File based jobs loads the data directly to the EDW area.
Decision support layer get its data from EDW area on aggregated basis.

Environment: Data Stage 8.5 (PX), Confidential

Confidential

ETL Developer

Responsibilities:

The Confidential Business Intelligence solution delivers a data warehouse, a number of data marts and reporting capability, with all-new infrastructure for loading data from operational source systems.
The Business Intelligence solution is expected to provide business-critical information and decision support systems for a wide and diverse range of users in the organization.
This is to enable the business users to know their subscribers behavior and proactively support their subscribers’ needs and derive actionable insights.

Environment: Data Stage 8.1 (PX), Oracle 10g, IBM CDC 6.3

Confidential, Florida

ETL lead and onsite coordinator

Responsibilities:

Confidential is a part of serves in all parts of Florida Stat and many others.
It provides a wide verity of Heath Insurance Policy to companies, farms and individuals.
It has number of association with Hospital and Pharmaceuticals to serve their members.
Amisys is a legacy claim processing system which stores and provide information like member, providers, policy and claims etc.
Apart from Amisys there are other vendors who sends their data in form of feed files.

Environment: Data Stage 7.5 (Server Edition), Sql Server 2000

Confidential, Massachusetts

ETL Developer and Support

Responsibilities:

Confidential is a full-service health benefits company serving members throughout Massachusetts, New Confidential, Maine and beyond.
An independent, not-for-profit organization, Confidential offers a wide variety of health insurance options for companies, families and individuals.
Through an alliance with Confidential also offer a very successful program for multi-site, multi-state employers.
In addition, Confidential Pilgrim offers the personalized service and technology that makes plans easier to use they work closely with providers to improve the health of their members, both through prevention and by helping people manage chronic conditions or other serious medical problems.
This Project deals with all kind of Claims, Members, Pharmacy Claims and Provider Data.

Environment: Confidential V2R12, HP-UX, Data Stage 7.5 (Server edition), AutosysOracle 9i

Confidential

Support

Responsibilities:

Maintenance and problem resolution of real time and non-real time Investment Management applications of a Production, UAT and SIT systems.
The project involves continuous maintenance activities of the middleware banking applications and also technical middleware problem resolution for the users and the developers of the system.
Data services are Data Management for asset services supports some of these critical systems cater to the functionality like maintenance of tradable Assets and Instruments, Maintenance of the Customer Portfolio and their Positions, Accounting, market and indicative Data from interfacing Systems and Global User Access

Environment: UNIX, SYBASE, IBM Mq series

We provide IT Staff Augmentation Services!

Etl Analyst And Developer Resume

FloridA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship