Sheela Hegade

Mobile: +1-203-***-****

Email: adch6r@r.postjobfree.com

Career Summary:

8+ years of experience on various phases of software development including System Design, Analysis, coding, Integration Testing, Implementation, User Training and Documentation.

Experience in Hospitality and Finance domain.

Great exposure on ETL jobs on Informatica Power center and Oracle PLSQL.

Develop the ETL jobs in SAP BODS and/or Informatica using the mapping documents

Good experience in Data Quality, Data Governance and Master Data Management using SAP & Informatica tools.

Worked as Solution Architect on Data Warehousing and Product based projects using Informatica and Oracle (SQL & PL/SQL) across various stages of SDLC.

Excellent understanding of Data Warehouse Architectural principles and having experience in analysis, design and development of Data Warehousing applications.

Strong skills in Informatica Administration and involved in Informatica upgradation.

Fair experience on Informatica IDQ, DVO and Informatica Cloud

Well familiar in UNIX environment like shell scripting, job scheduling and monitoring.

Sound knowledge on all database objects (Stored procedures, Functions, Triggers, Normal Views, Materialized views, Tables, SQL Loader, Packages, Collections, Indexes, Analytical functions with all oracle advanced features).

Experience in performance tuning techniques for database objects related to Oracle (Using Rewriting query, Trace files, Dbms_Profiler package, Explain plan, Indexes, Oracle Hints, Table partition etc).

Strong experience in Data Modeling for OLTP and OLAP databases

Developed Batch Jobs using UNIX Shell scripts to automate the process of loading, pushing and pulling data from different servers. Experience in using XML as Source and Targets

Excellent problem solving, interpersonal and communication skills with experience working in fast paced, challenging and dynamic environment. Highly motivated with passion for learning.

Worked in projects with Agile methodology, Waterfall

Experience working in onsite-offshore model environment and in coordinating cross-functional teams and work within a team or as an individual. Also mentored newly hired ETL developers.

Enterprise Data Management Analyst experience including object oriented analysis, data modeling, data profiling, partnering with the user community to identify their business requirements, analyze business processes, analyze source data, produce functional specifications and assisting with the implementation of those specifications, writing Use Cases and producing Use Case Models, data flows and business rules, develop Test Cases, coordinating User Acceptance Testing(UAT) and conducting GAP analysis.

Technical Skills:

Development Tools : Informatica Power Center 10.x/9.x/8.x, Oracle Golden gate, Business Objects Data Stage, StoneBranch Scheduler

Database : Oracle (10g/11g/12c), Teradata, Microsoft SQL Server

Languages : SQL, PL/SQL and UNIX Shell Scripting

Domain Exposure : Hospitality, Finance

Special Tools : PL/SQL Developer, Toad, SQL Developer, Teradata Sql assistant, Microsoft SQL Studio

Utilities : SQL Loader

Operating Systems : Window XP, Windows 7/10, UNIX (Sun Solaris, HP-UX, IBM-AIX)

Certifications & Awards:

- Introduction to SQL-OCA (IZ0-007)

- Cleared ASDA tier 1 programming exam (Accenture Internal)

- Received Several Accenture Awards and Client Appreciations.

Education:

Completed Bachelor of Engineering in Computer Sc. And Technology in 2011 from SDM College of Engineering and Technology, Dharwad, Karnataka India.

Professional Experience:

Role: ETL Developer/ Administrator /ETL Tech Lead/Golden gate Administrator

October 2011 - 2018

Client: Starwood Hotels & Resorts, Stamford, Connecticut, USA

Team Size: 16

Lead the Data warehouse team in the Biggest Data Migration effort in history of Hotel industry as part of Marriott Acquisition of Starwood Hotels Migrating 210 Million reservations.

Batch and Real Time Integration using tools such as Informatica Cloud Services and Golden Gate Replication tool.

Experience in developing complex ETL jobs within a data warehousing environment.

Expertise in designing and developing Informatica mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.

Implemented performance tuning practices viz. partitioning and parallelism to improve the execution time of the mappings.

Implemented Performance tuning activities by analyzing existing SQL /PLSQL procedures / Unix Scripts and implement required changes for code to perform well.

Perform Data Modeling and Data Analysis for new and ongoing projects.

Responsible for multimillion-dollar project Solution design for integration and migration modules using Informatica power center, Oracle Database.

Responsible for the complete technical delivery of integration and migration interfaces and making sure post data migration historic Starwood Data is populated into existing Cognos reports used by various business users and Marriott leadership.

Well versed in dimension modeling, Tuning Oracle queries using partitioned columns in Table and indexes.

Worked on Informatica admin activities like user management and integration service restart and backup.

Involved in Informatica upgradation to 9.6

Was part of Exadata refresh.

Develop ETL to load data for Micro strategy, Cognos Reports and Analytics Platforms.

Develop automated migration process for deployment of ETL code from lower environment to Production environment.

Experience in Agile development methodology.

Work with business Analysts to understand and assist on business problems and provide solutions.

Collaborate with team in India to achieve business delivery.

Oracle Apex web applications development with forms and reports.

Designed Golden gate mappings.

Developed Pro-active monitoring scripts at UNIX server level to alert on extract/replicate failure.

Performed root cause analysis for the critical production support issues and document the solutions in the knowledge repository.

Role: ETL Developer/QA Analyst/Informatica Administrator

January 2019 - Present

Client: PSCU, St Petersburg, Florida, USA

Team Size: 30

Work directly with the client to understand business requirements to align technology with business strategy and goals. Liaison with onshore and offshore teams to convey the requirements, clarify the designs and verify the deliverables.

Design and build complex ETL workflows to meet business requirements

Perform data profiling and data analysis to identify patterns and trends, and provides new insights to the business.

Design of Integration solution for Enterprise Data warehouse and Operational Data Store to resolve the Business Challenges and providing Industry Leading Best Practices.

Developing and maintaining a detailed project plan for Business Data Integration Projects and manage project deliverables in line with the project plan.

Working closely with users to ensure the project meets business needs.

Work on IDQ data quality tools using IDQ transformations (Parser, Standardizer, Match, Labeler and Address Validator), debugging using PC logs, data masking and Push Down Optimizations (PDO) a plus, Informatica/IDQ specific complex transformation experience a plus

Primarily responsible for ETL Development and Data quality analysis work, help in defining the technical, performance and support requirements of a system. Acts as a liaison between the business and IT team. Participates in system requirements definition, design, testing, training and implementation support.

Work with business analysts and BI Data Architect DA to understand the requirements and work on high level and low-level design of ETL interfaces

Utilize ETL tools Informatica proficiency v 9.6, 10X for development based on business model design and source data.

Data quality analysis using a high-end tool viz informatica DVO etc.

Responsible for informatica Admin activities:

-Installation and configuration of Informatica Power Center and other related products.

-Build Informatica Data Exchange/Data Transformation (DX/DT) and Data Quality environments for various POCs or setting up the environments if required

-Managing the DEV/QA/UAT/PROD environments with High Availability and GRID setup

-Liaise with Systems Administrators, UNIX, Network and DBAs, scheduling and implementing software patches and upgrades

-Experience with setting up access roles and privileges, code page setups, appropriate ETL migration activities and scheduling jobs using Control-M or AutoSys

-Handle day to day Informatica components migration task

-Scheduling and Monitoring Informatica repository backups

-Creating new repositories from scratch, backup and restore

-Root Cause analysis for ETL job failures/Data issues raised by business

-Mentored and monitored offshore and onsite development teams with regular calls on the commonly raised issues and propose permanent fixes

Personal Details:

Visa Type: H1B

H1B Validity Date: 04/18/2021

DOB: 08/18/1989

Marital Status: Single

Contact Number: +1-203-***-****

Contact Mail id: adch6r@r.postjobfree.com

Contact this candidate