Systems Engineer Resume

SUMMARY

Around 4 years of experience in implementing data warehousing solutions in teh BFSI domain using Business Objects Data Services, OBIEE 10.1.3.x, Informatica 9.x, Xcelsius 2008, Informatica BDE, SSIR / SSRS.
Strong background in Data Warehousing Concepts.
Exceptional ability to learn new concepts and hard working.
Designing teh Universe using teh Business Objects tool to create different schemas.
Implementing Extraction, Transformation and loading of data from various heterogeneous sources like flat file, Database etc.
Self - motivated, team player with good interpersonal and communication skill.
Specialties: Business Objects Data Services, OBIEE 10.1.3.x, MS SSIS, Oracle 11g, Informatica 9.x, Informatica BDE
Good Knowledge in Exploratory Data Analysis, Data Mining, Text Mining and Data Visualization.
Presently working as ETL consultant.
Masters in Computer Science from University of Mumbai.
Database and schemas development experience in OBIEE 10 and 11.
Development experience of Reports, Dashboards for different subject areas like Financials, Banking, Retail etc.
Having experience of requirements gathering and dealing with teh clients.
Also have software and web development noledge using Java and .NET, HTML, CSS, Javascript, and JQuery.
Have competitive programming and SQL skills.
Worked on Oracle and MS SQL server for different clients.

TECHNICAL SKILLS

Programming / Scripting Languages: Python, C, Java, JavaScript, HTML, XML.

ETL Tools - Informatica, SAP Data services, Informatica Power Center 10.

Reporting tools - SAP Business Objects, OBIEE 10.1.3.x.

OLTP - Siebel CRM.

Analytics: Big Data, Hadoop, AWS Redshift.

PROFESSIONAL EXPERIENCE

Confidential,

Systems Engineer (ETL / Data engineer)

Hired as a consultant for providing solutions to various clients on their enterprise data warehouse.

Development of schemas and measures in repository.
Resolution of defects of teh previously built reports.
Involved in Techno-Functional development team dealing with development and support of ETL mappings, monitoring performance and OBIEE reports / dashboard related activities.
Experienced in designing, integrating and re-engineering teh enterprise data warehouse, data marts in environments like Oracle.
Good understanding of SDLC.
Involved with migration requirements related to Big Data with AWS as a cloud service provider.

Confidential

Consultant

Hired as a consultant for providing solutions to various clients on their enterprise data warehouse.

Development of schemas and measures in repository.
Resolution of defects of teh previously built reports.
Involved in Techno-Functional development team dealing with development and support of ETL mappings, monitoring performance and OBIEE reports / dashboard related activities.
Experienced in designing, integrating and re-engineering teh enterprise data warehouse, data marts in environments like Oracle.
Good understanding of SDLC.

Confidential,

Consultant

Strong Data warehousing experience specializing in RDBMS, ETL Concepts, Report development in SAP Business Objects. Knowledge of load data from different sources into data warehouse using Informatica .
Experienced in gathering reporting and analysis requirements, documenting teh report specifications, implementing teh metadata layers including Physical, Business Model and Mapping, and Presentation layer.
Experienced in performance tuning especially tuning complex queries, procedure and indexing strategies for Oracle/SQL Server.
Proficient in defining Key Performance Metrics (KPIs), facts, dimensions, hierarchies and developing Star and Snow Flake schemas.
Experienced in designing customized interactive dashboards in OBIEE using drill down, guided navigation, prompts, filters, and variables.
Extensively worked on Informatica Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Sorter and Sequence Generator.
Extensively worked with Slowly Changing Dimensions ( Type I and Type II).
Highly adept at creation, execution, testing and debugging of Informatica mappings, mapplets, sessions, tasks, work lets and workflows in Windows environments.
Efficacy in relational database systems like Oracle.
Excellent Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica.
Expertise in Data Warehousing Concepts such as Star Schema, Snow Flake Schema, Fact Table and Dimension Table
Expert in designing and developing Workflows, Sessions and other tasks using Work flow manager tools Task Developer, Workflow & Work let Designer to handle different load scenarios..
Excellent Team member with good Communication, analytical, interpersonal skills and ability to learn new concepts.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship