S

Shikha Aggarwal

Project Manager

Delhi, India18 yrs 1 mo experience
Highly Stable

Key Highlights

  • Over 11 years of IT project management experience.
  • Expertise in ETL and Data Warehousing solutions.
  • Proven track record of managing large teams and projects.
Stackforce AI infers this person is a Data Analytics professional with extensive experience in ETL and Data Warehousing.

Contact

Skills

Core Skills

EtlData Warehousing

Other Skills

Informatica Power CenterOracle SQLPL/SQLTeradataUNIX Shell ScriptingBusiness Objects XIInformaticaOracleOracle PL/SQL DevelopmentSoftware DevelopmentRequirements AnalysisUnix Shell Scripting

About

Proactive, Autonomous, Results-oriented IT professional with more than 11 years of rich experience and currently associated with Cognizant Technology Solutions, Gurgaon as a Project Manager with expertise in ETL and Data Warehousing.  7 years of extensive experience in designing and developing Business Intelligence solutions in staging, populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using ETL tool Informatica Power Center and Oracle SQL, PL/SQL, Stored Procedures, Functions, cursors etc.  Have worked with business stakeholders in defining the scope of large programs, process flows, interface specifications and data model design. Even worked closely with team in analysis, designing complex programs, development, testing and implementation with timely delivery against aggressive deadlines.  Adept at managing projects with teams of 20 members, managing multiple projects, ensuring delivery across geographical locations and managing projects from inception to closure.  Excellent interpersonal and communication skills, technically competent and result-oriented with problem solving skills and ability to work independently and use sound judgment.  Have performed onshore and offshore coordinator role for both technical and management areas. Have performed Project Initiation and Project Planning, Managed project budgets, schedule, dependencies and risks. Have managed stakeholders' meetings and status reports.  Have tuned the existing programs to optimize performance thereby business critical production cycles complete within SLA. Produced and baseline documents production support handbook. Developed new systems. Have very good experience in project lifecycle management. Expertise: Oracle PL/SQL, Informatica Power Center and UNIX shell scripting.

Experience

18 yrs 1 mo
Total Experience
4 yrs 7 mos
Average Tenure
4 yrs 2 mos
Current Experience

Ibm

Project Manager

Mar 2022Present · 4 yrs 2 mos · Gurugram, Haryana, India

Cognizant technology solutions

Project Manager

Jul 2012Feb 2022 · 9 yrs 7 mos · Gurgaon, India

  • Understanding requirement, setting and managing expectation, clear and regular on time communication.
  • Establishing schedule for delivery, client communication & expectation setting, making sure team alignment etc
ETLData WarehousingInformatica Power CenterOracle SQLPL/SQL

Capgemini consulting | it consultant

Capgemini Consulting

Nov 2010Jun 2012 · 1 yr 7 mos · Bangalore

Ncr corporation | software engineer

NCR Corporation

Jan 2008Oct 2010 · 2 yrs 9 mos · Gurgaon, India

  • From January, 2008 – Oct 2010, I have been working with EDW Team. In team, I was responsible for Developing/maintaining/supporting the application _ Teradara, Business objects XI, Subscribers (message queue), user admin and subversion(SCM) tool.
  • I was Responsible for -:
  • 1. Developing Teradata Mload, BTEQ & UNIX Shell scripts for various EDW projects.
  • 2. Responsible for server administration, like Business objects XI, Subscribers (message queue), user admin and subversion(SCM) tool etc
  • 3. Provided a professional, prompt and high level of technical support to all issues/tasks assigned.
  • 4. Performed Regression Testing at Dayton, Ohio – USA on B1 Visa
  • 5. Implemented Subversion for our EDW Application. Developed various shell scripts like to run audit report which helped us in finding out-of sync scripts, shell script to make out difference on the elements.
TeradataUNIX Shell ScriptingBusiness Objects XIData Warehousing

Education

Amity University

Master of Computer Applications (MCA) — Computer Engineering

Jan 2005Jan 2008

Delhi University

Maths Honors — Mathematics and Computer Science

Jan 2002Jan 2005

Stackforce found 100+ more professionals with Etl & Data Warehousing

Explore similar profiles based on matching skills and experience