ETL and Business Intelligence Devloper Resume

SUMMARY

Confidential has around 15+ years of experience in IT industry of which includes rich 10+ years of ETL and Business Intelligence, Data warehousing, data modeling mainly in SAS & Teradata for various clients and has also around 5 years of onsite experience.
He has good domain expertise in Finance, Telecom, Health Care & Pharma. He is very strong in tools and technology like SAS, COBOL, Teradata, UNIX ERWIN, ERSTUDIO and Crystal Reports.
He was worked extensively on SAS, Teradata and Data modeling. He is conversant with ETL Design, Data model design, Mapping design and universe design.
Executed projects in SAS, SAS Admin, Project Lead and project leader capacities.
Hands on experience in Dimensional Data Modeling, Star Schema and Snow - Flake schema design.
Have designed Enterprise Data warehouse projects having Master data Management implementations and multi-source integration capability.
Good experience on complete project life cycle right from System Study, Requirement Analysis, KPI documentation, Bus matrix design and review to Design, development, coding, QA and implementation of Enterprise Data warehouse.
Designed data warehouse solutions using different Architecture, design and modeling techniques such as 3 layer architectures with acquisition, integration and distribution layer so that the DWH becomes more methodical and integrated.
Defined the data profiling including data cleansing and standardization have an enterprise view of all data and better data governance in design proposal.
Has knowledge in data modeling and reverse engineering tools like ERstudio & ERWIN.
Extensively worked on gathering requirements from users and hands on experience in documentation and designing with Visio.
Proficiency in data warehousing techniques for data cleaning, Slowly Changing Dimension phenomenon, surrogate key assignment
Familiarity in in corporation of various data sources like Oracle, Teradata and Flat Files into DWH staging environment.
Strong working experience on Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
Extensively worked on Data Warehousing Full Life Cycle Projects for Manufacturing and Sourcing Verticals.
Proficiency in end-to-end DWH project planning and implementation from scope management, to activity sequencing, effort & cost estimation to quality management.

TECHNICAL SKILLS

Business Intelligence: SAS, Crystal Reports

DBMS: Teradata, Oracle

Front End/GUI: SAS-AF

Internet Technology: JAVA - SWING, APPLETTES, HTML

Language: COBOL, SAS

OS/Environment: MS-DOS, Windows NT, 2000 professional, Solaris & Unix

Tools: Erwin, ERSTUDIO

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship