Project Data
Resume:
Kshitija Shinde
Email: *******@*****.***
Ph: 408-***-****
summary of experience
. 10 Years of experience in Information Technology at various phases in
Techno-Functional roles.
. Strong Data Warehousing experience using Informatica
7.4/8.1/8.6/9.1/9.5, Teradata, Oracle 9i/10g/11g, PL/SQL, ASP, UNIX
Shell Scripting, Dollar Universe ($U). Oracle OCA certified
professional.
. Good knowledge of Logical/Physical Data Modelling, Star Schema and
Snow Flake Schema.
. Experience in performance tuning with Informatica as well as ORACLE
PL/SQL.
. Designed and developed both simple and complex mappings from varied
transformation logic like Unconnected and Connected lookups, Router,
Filter, Expression, Aggregator, Joiner, Update Strategy and more.
. Competent in Database development using SQL, PL/SQL, Stored
Procedures, Stored Functions, Packages, and Triggers.
. Experience in data analysis and reporting tool Siebel Analytics and
OBIEE used for financial/business decisions.
. Effective communicator with strong team-building, management skills
and ability to coordinate cross-functional teams to accomplish
objectives and meet critical deadlines in a fast paced, high-growth
and diverse environment.
. Core competency in software development life cycle which includes
Analysis, Design, Development, Testing, Debugging and Implementation
to production support.
. Has high degree of conceptualization and creative approach to problem
solving.
. Project risk management.
. Possess strong Analytical, Leadership skills and an influential team
player.
. With strong Analytical, Leadership skills have received multiple
commendations from CISCO and TCS clients
TECHNICAL SUMMARY
Operating Systems Unix(AIX), Sun Solaris, Windows 2000/NT/XP,
LINUX, DOS
ETL Tools Informatica 9.5/9.1/8.6/8.1/7.4, Informatica
Power Exchange
Languages PL/SQL, SQL, C, C++, ASP, Unix shell scripting,
XML
Databases Oracle 11g/10g/9i, Teradata, SQL Server 2005, My
SQL.
Software Tools, Toad, SQL *Plus, SQL Loader, Visual Studio 2005.
Web Servers and
source management.
EDUCATIONAL QUALIFICATIONS
Bachelor of Engineering in Electronics, Mumbai University, India.
Professional Experience
CISCO SYSTEMS Inc Nov'13
- Till End
(ETL/Team Lead)
Title: CPCT Reporting
Client Name: Cisco Systems, Inc. San Jose, USA
Responsibilities:
. Translated business processes into mappings for building Data
Ware house by using Informatica 9.5
. Worked extensively on Data modelling design.
. Interacted with clients for requirement gathering, design walk-
through and successful implementation of code. Extensively used
most of the transformations like FILTER, Router, Joiner, Lookup
(Connected & Un-Connected), Aggregator, Expression, Normalizer
and Update Strategy.
. Designed workflows with Flat file extracts from Teradata to
Oracle load (Fast exports and relational connections).
. Trained and mentored medium size team for deliverables.
. Extensively used performance tuning techniques for daily SLA
target.
. Developed packages and stored procedures using PL/SQL. Worked
with analysts and data source systems experts to map requirements
to ETL code.
. Optimized SQL statements and PL/SQL blocks by analysing the
execution plan.
Project:
CPCT Reporting is Cisco's foundational program reporting application
dealing with Technology Market program. This application deals with Cisco's
CTMP quote offered to partners for return gears. It extensively reports
bookings and RMA for CTMP quote partners.
Environment: Informatica 9.5, PL/SQL, Teradata, Shell Scripting, Oracle
10g/11g,OBIEE 10G Windows 2000/XP -Intel Pentium, UNIX, $U Universe,
Kintana, PVCS.
CISCO SYSTEMS Inc
JUN'13 - OCT'13
(Technical Lead)
Title: Mediation/Baby Bear Migration
Client Name: Webex Cisco Systems, Inc. Santa Clara, USA
Responsibilities:
. Worked extensively on Data modelling/functional design with
Architectures/cross-functional team.
. Developed, maintained, troubleshoot, enhanced and documented
project components.
. Extensively implemented Advanced PL/SQL logic for Mediation
track.
. Designed Baby Bear IT-ENG migration based on SOA orchestration,
R12 and ORACLE BRM technology.
. Conducted peer-reviews and lead reviews and provided appropriate
feedback.
. Planned delivery with good size team members.
Project:
Mediation project dealt with Cisco's WebEx Telephony, Meeting and User
usage record. It collected all subscriber's usage data, transformed it in
the subscription reports product rules.
Baby Bear Migration project was migration of low usage Train telephony
customers to Webex11 Product. The project dealt with transformation of
Train customer's plan to new Webex11 plan. It included mapping of old plan
to new plan, calculate appropriate deals based on subscription plan, create
deals based on Webex Host usage and renew expired plan
Environment: PL/SQL, Shell Scripting, Oracle 10g/11g, SOA orchestration,
Oracle BRM, R12
CISCO SYSTEMS Inc
May'09 - JUN'13
(ETL/Team Lead)
Title: Partner Program Platform
Client Name: Cisco Systems, Inc. San Jose, USA
Responsibilities:
. Involved in design and development of Business Requirements in liaison
to business users and Technical teams by gathering requirement
specification documents and identifying data sources and targets.
. Participated actively in user meetings and collected requirements from
users.
. Used Informatica Power Centre 8.6/9.1/9.5 for extraction,
transformation and loading (ETL) of data in the Data Warehouse and
used velocity methodology.
. Performed ETL into ORACLE Data Warehouse using Informatica Mappings
including transformations Aggregator, Joiner, Lookup (Connected & Un-
connected), Filter, Update Strategy, Stored Procedure, Router,
Expression, SQL and Sorter
. Involved in design and development of ad-hoc data load or business
critical code enhancement
. Created workflows and tested mappings in development, test and
production environment.
. Developed re-usable transformations, mappings and mapplets confirming
to the business rules. Used Debugger to test the mappings and fix the
bugs.
. Actively involved in Performance improvements of Mapping and Sessions
and fine-tuned all transformations
.
Project:
Partner Program Platform is the next generation rebate calculator to be
utilized for Channels rebate programs (internal use only). The new rebate
engine, designed for performance and higher throughput, is a service
oriented, business rules driven rebate engine platform integrated into the
rest of the Channels processes and reporting tools. It is also a generic
scalable engine which is configurable to process rebates for multiple
programs (products and services) with minimal changes and testing required.
The minimal IT efforts to enable new Partner rebate programs and new
business models reduce time to market.
Environment: Informatica 8.6/9.1/9.5, PL/SQL, Teradata, Shell Scripting,
Oracle 10g/11g,OBIEE 10G, Windows 2000/XP -Intel Pentium, UNIX, $U
Universe, Kintana, PVCS.
CISCO SYSTEMS Inc Feb 2008 to May 2009
(Sr. ETL Developer)
Title: Rebate Engine
Client Name: Cisco Systems, Inc. San Jose, USA
Responsibilities:
. Designed and developed the ETL Mappings for data extractions,
data transformations, data staging and aggregation for sales.
. Worked on Informatica Power Centre 8.6/8.1 - Used Source Analyzer
and Warehouse designer to import the source and target database
schemas and the Mapping Designer to map the sources to the
target, Mapplets and Transformation Developer.
. Translating the data through Informatica into an XML by following
the mapping documents
. Developed standard and re-usable mappings and mapplets using
various transformations.
. Scheduled Extraction and Load processes.
. Extracted fact tables for the timely basis sales, sub averages,
totals etc.
. Involved in performance tuning of the Informatica mapping using
various components like Parameter files, Variables and Dynamic
Cache.
. Developed system test cases to check for the consistency of the
data.
. Written Unix Shell scripts to validate the metrics and verify the
records.
. Responsible for creating the test bed systems and loading the
entire production database dump into the test bed.
Project:
Rebate Engine is a corporate sponsored initiative to provide a systemic and
scalable solution for processing the back-end rebates to Cisco's partners.
It systematically posts revenue accruals on a daily basis to the General
Ledger. It also calculates VIP rebate accruals at SKU level based on
allocated model.
Reporting ETL is report generation of a Rebate Engine application. The
process helps in reducing the downtime and refresh time of Business Object
and Siebel Reporting.
Environment: Informatica 8.6/8.1, PL/SQL, Shell Scripting, Oracle 10g/9i,
Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.
CISCO SYSTEMS Inc Oct 2007
to Feb 2008
(ETL Developer)
Title: SCRM-BCP
Client Name: Cisco Systems Inc., San Jose, USA
Responsibilities
. Gathering business requirements of application from client.
. Documenting and analyzing the business rules to eliminate
redundant and inefficient processes. Data modelling as per the
client requirement.
. Developed Mappings using different transformations like Source
Qualifier, App Multi-Group Source Qualifier, Application Source
qualifier, Expression, Lookup, Router, Update Strategy, Union,
Stored procedure (unconnected), Aggregator, Joiner, Sequence
Generator .
. Created re-usable objects (mapplets & Sequence Generator).
. Worked on mapping parameters for incremental loading.
. Worked on Advance Oracle PL/SQL functionality.
. Development and maintenance of application modules. Ensuring good
performance of logic built. Interaction with clients for
clarification or recommending solution to issues incurred.
. Preparing Unit Test Plans and Integration Test Plans. Sharing the
case plans with Testing team and client to ensure proper
designing of application.
. Performed regression and functional testing to ensure proper
implementation of the Change Requests and Enhancements.
. Internal Quality Checks and External Quality checks were done for
all the deliverables before delivery to the client.
. Supported Testing, UAT and BAT cycle of application
. Leading the development and deployment activity. Handling the
Knowledge transition plan to support team. Engagement in
production support activities.
Project:
SCRM-BCP tool is the application created using Siebel analytics to display
Cisco supply chain site level information. This supply chain site level
information is a combination of data from revenue and product structure.
Data is collected on Cisco's behalf by external partner, BCMx, related to
supplier factory locations, manufacturing activities, and disaster recovery
times.
Environment: Informatica 8.1, PL/SQL Shell Scripting, Oracle 10g/9i,
Windows 2000/XP -Intel Pentium, UNIX, $U Universe, Kintana, PVCS.
3i-Infotech Ltd. July 2006 to
Sep 2007
(Informatica/ETL Developer)
Title: PFORM (Performance Review System)
Client Name: ICICI Bank Pvt Ltd, India
Responsibilities:
. Creation of complex Informatica mappings (Using Transformations
like Lookup, Router, Union, transformation, etc).
. Supervision on the testing of ETL code to give the quality work
to clients.
. Preparation of test plan and test case for Informatica mappings.
. Preparation of high level documents for the mappings like ETL
Document, Data Dictionaries
. Responsible for all deliverables, reviews and functional
understanding.
. Did automations of manual source file conversions through
Informatica and manual excel macros which saved a lot of time for
the project.
. Knowledge of various quality practices with in the Project viz.
Technical Documentations, Unit Test Documentation and Code Review
tools and database comparator tools for testing
. Created and modified existing Excel Reports as per the Business
requirement.
. Created and modified SAS plots for reporting purpose
. Involved in daily reconciliation of data between source system
and Data Warehouse
Project :
PFORM is intranet based system. It is used for Capturing Monthly Financial
Performance of all branches of ICICI Bank (750 branches). Performance
Report is required to be prepared by all the branches as on the last day of
the month (NOT as on last working day of the month). This application uses
critical server side file uploads. Performance Review System is developed
with a view to automate the process of preparing/generating performance
review report. These Reports are directly submitted to RBI.
Environment: Informatica Power Centre 8.1/7.1.4, PL/SQL Shell Scripting,
Oracle 9i, TOAD, Windows 2000/XP -Intel Pentium, UNIX, $U Universe,
Kintana, PVCS.
3i-Infotech Ltd
Sep 2006 to Dec 2006
(Developer)
Title: New GL
Client Name: ICICI Bank Pvt Ltd India.
Responsibilities:
. Responsible for design, implementation and maintenance of
different modules in the system.
. Involvement in reframe of database architecture. Rebuilding the
data modelling design.
. Handling the critical server side uploads. Server files need to
be uploaded in the system with SQL Loader tool. Tallying data and
upload at run time. Analysis of issue and debugging the root
cause for unsuccessful uploads.
. Consulting with clients, recommending and developing modules
based on clients' needs. Ensuring the feasibility of enhancement
with existing functionality.
. On time resolution of bugs encountered while testing. Preparing
Unit Test plans and sharing the same with testing team and
clients for suggestion to ensure proper development of logic
built.
. Documentation of Low level design. Maintenance of high level
changes of application.
. Support during UAT and BAT cycle.
Project:
This Application is intranet based system .GL system provides daily-
consolidated general ledger preparation of corporate offices of ICICI Bank.
Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, TOAD, Windows
2000/XP -Intel Pentium.
IRIS INDIA Pvt ltd
March 2005 to June 2006
(Developer)
Title: Revamping of Fitch Rating's website
Client Name: Fitch international, UK.
Responsibilities:
. Requirement gathering and understanding the business knowledge.
Responsible for architectural database design and building of
schema objects.
. Preparing ERD diagrams and demonstration for clients to dig into
functionality for mapping the requirements. Suggestions and
recommendations provided to client for developing the application
more end-user friendly.
. Responsible for developing the application modules as per the
business and design requirement. Maintain the development coding
standards. Tackling technology development with functionality
requirement. Worked on Advance PL/SQL, Stored Procedures, Functions
and Packages
. Interaction with client on application related issues and modifying
the application development as per suggestions.
. Documenting and analyzing the business rules to eliminate redundant
and inefficient processes and practices.
. Debugging and creating test case plans for application. Performing
Unit testing of application and through checking of functionality
satisfaction.
Supporting the testing team during the Testing cycle period of
application.
. Documenting the low level design of application. Selective
retesting of new enhancements to ensure existing functionality is
not hampered with new enhancement.
. Preparing weekly status report for client update.
Project:
The application is used to provide ratings India's credit market. It is
developed on the basis of its leading international site. It provides the
annual reports, Industrial profile, and Quarterly performance of BSE's
listed company. Register user can gather the company's portfolio and latest
market updates directly fetched from BLOOMBERG.
RSS structured maintained in the application provides fresh knowledge of
India's finance and economic status.
Users thus can have all required Indian financial market knowledge
consolidated at single place
Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, Windows
2000/XP -Intel Pentium.
IRIS INDIA Pvt ltd September 2004
to March 2005
(Developer)
Title: Reed Technology Products
Client Name: REED International (U.S).
Responsibilities:
. Understanding the functionality of application and designing
respective modules as per the requirement. Developing the
application as per client's requirement.
. Designing application as per the client specific coding
standard. Analysing the impact of newly developed modules with
existing functionality. Debugging the developed modules.
. Performing Unit testing and integration of new developed system
with existing application. Extensively worked on Stored
Procedures, Functions and Packages.
. Documentation of High Level Design.
. Consulting with project leads and developing solutions as per
project requirement.
. Performing Code Reviews with Tech lead
Project:
Reed Technology Products is used to gather technical information on various
serving industrial products. Information of technical products is used to
build up the client website. User can enter these product specifications
through this application. The application contains different modules for
different roles of users. Once the data entry is complete an XML file is
generated and files are FTP on client's server. This information
transferred is stored at client's website and registered Partners gather
specifications of required products, which enhance their knowledge for
products.
Environment: ASP, Oracle PL/SQL, Shell Scripting, Oracle 9i, Windows
2000/XP -Intel Pentium.
REFERENCES FURNISHED UPON REQUEST
Contact this candidate