PRIYANKA KAMBOJ
8587 Red Oak Ct., Apt H
Indianapolis, IN – 46227
[Send email to request phone number] 03-3254
[Send email using form at bottom]
A Systems Analyst with over Six years of IT experience, with the abilities to be
a self-starter and comfortable in high intensity and challenging work
environments, I believe that I possess excellent analytical and technical
aptitude to solve complex technical problems, an aspect that has led to my being
thrust with additional responsibilities during times of crisis. Over the years, I
have repeatedly demonstrated the ability to both lead a team comprising of team
members from diverse backgrounds and skill sets, as also as a team member. I have
excellent written and oral communication skills and have adequate experience
interacting with associates at various levels, right from team members new to the
organization to senior managers.
Professional Summary
· More than 6 years of experience in IT industry.
· 6 years of rigorous Software Engineering, SDLC methodology, Application
development and maintenance expertise. Thorough understanding of Software
Development Life Cycle (SDLC), requirements gathering, system designing,
application development, enhancement, deployment, maintenance and support.
· Skilled in creation of ORACLE database schemas, Objects (Tables, Indexes,
Views, Sequences, Synonyms)
· Skilled in Informatica Power Center 7.1.3 (Repository Manager, Workflow
Manager, Workflow Monitor, and Designer)
· Experience in developing Informatica mappings, mapplets, sessions, workflows
and repository creation and maintenance.
· Experience in developing Unix Scripts.
· Worked on DDL, DML, DCL, Oracle, PL/SQL programming and Oracle
procedures/functions/packages/triggers/tunings.
· Worked on tuning of Informatica mappings/sessions.
· Experience in entire Software Development Life Cycle involving Analysis,
Design, and Development using JAVA 2.0, JSP and Servlets.
· Functional and technical exposure.
· Good communication and interpersonal skills.
·
Technical Skills
Language: C, C++, Java, PL/SQL VB, HTML, DHTML, JSP, Servlets and Oracle Forms
Database: MS-Access, FoxPro, and Oracle 8.0, Oracle 9i
Tools: MS-Office 2000, MS-Project 2002, MS-FrontPage, Adobe Photoshop,
Macromedia Flash, Dream weaver, Developer 2000, Informatica and TOAD
Low-level Programming: Assembly Language for 8085 and 8086
Operating Systems: Windows 3.1x, 95, NT, XP, UNIX, Linux
Academic Profile
· Bachelor of Technology in Computer Engineering, KU, India
· Diploma in Web designing and development from CMC.
Professional Experience
Global LIMS (Laboratory Information Management System)
Eli Lilly and Company – Indianapolis, IN
Aug 2006 – Jun 2007
Data Migration Specialist/Interface Developer
Eli Lilly and Company is leading; innovation-driven corporation committed to
developing a growing portfolio of best-in-class pharmaceutical products that help
people live longer, healthier and more active lives. Lilly products treat
depression, schizophrenia, attention-deficit hyperactivity disorder, diabetes,
osteoporosis and many other conditions. The main goal of this project is to
migrate data from the Legacy System, ADMIN LIMS and EURO LIMS into one company
wide implementation of LIMS (Laboratory Information Management System) to be
referred as GLOBAL LIMS. The data is extracted from different systems like Oracle
databases and flat files. The data is extracted from these systems into a LIMS
data mart using Informatica Power Center 7.1.3 tools.
Responsibilities:
· Writing the Oracle database triggers for Data validations.
· Building the Informatica mappings using Lookup, aggregator, update strategy,
filter, normalizer, sorter, and router transformations.
· Building the new Informatica mappings and mapplets to extract data from end
user excel files into the Global LIMS system.
· Extraction of pipe delimited flat files into Global LIMS system using
Informatica mappings and Unix Scripts.
· Preparation of ER diagrams and high-level design moving into productions.
· Scheduling the Informatica session to automate the loading process.
· Optimizing the Informatica sessions, SQL queries TOAD tools.
· Running the SQL scripts from TOAD and creating Oracle Objects like tables,
views, Indexes, sequences, synonyms and other Oracle Objects.
· Authored the Informatica coding standard document.
· Authored the Unit testing and Code Review standard documents.
· Preparing power point presentation, workflows and building the requirement
documents.
· Extensive use of UNIX Scripts to build Interfaces between various Data
Warehouse systems across the company.
Environment:
Oracle 10g, TOAD, Informatica Power Center 7.1.3, PL/SQL, UNIX (HP UNIX) and
Windows NT.
Maintenance of Customer Data Warehouse
Convergys – Cincinnati, OH
Nov 2005 – Jul 2006
Data Warehouse Developer
The Convergys Services provides outstanding Call Center services to their
customers in US. The main goal of the project is to develop and maintain data
mart for Customer information system. The data is extracted from different
systems like Oracle database and Flat files. The data is extracted from these
systems into CIS Data mart using Informatica Power Center 5.1
and 6.2 tools. 24-hour maintenance and support for CIS data mart. The reports
were built using Business Objects.
Responsibilities:
· Running the SQL scripts from TOAD and creating Oracle Objects like tables,
views, Indexes, sequences, synonyms and other Oracle Objects.
· Building the Informatica coding standard document.
· Writing the Oracle database triggers for Data validations.
· Building the new Informatica mappings and mapplets to extract data from end
user excel files into data mart.
· Building the Informatica mappings using Lookup, aggregator, update strategy,
filter, normalizer, sorter, and router transformations.
· Extraction of pipe delimited flat files into customer data mart using
Informatica mappings.
· Building standard Informatica mapplets and workflows for CIS (Customer
information system) module.
· Creating users, folders and granting the access using Informatica Repository
Manager.
· Comparisons of Informatica mappings using Informatica 6.2 and study their
differences before System study and understanding the business requirements for
Customer information system.
· Preparing power point presentation, workflows and building the requirement
documents.
· Preparation of ER diagrams and high-level design moving into productions.
· Scheduling the Informatica session/workflows to automate the loading process.
· Optimizing the Informatica sessions, SQL queries using TOAD tools.
Environment:
Oracle 8i, Erwin designer, Quest soft, TOAD, VSS, Informatica Power Center
5.1/6.2, PL/SQL, Unix (HP UNIX) and Windows NT.
Support DW Team
Dannon Company Inc, OH
May 2005 - Oct 2005
ETL Consultant
Involved with other DW team members to design and develop the new Data
Warehouse. Meanwhile Support the current system. Provide support to the DW
team. Help in moving the current DW to the new Environment.
Responsibilities:
· Involved in business analysis and technical design sessions with business and
technical staff to develop requirements document, and ETL specifications.
· Designed and developed the ETL Mappings for the source systems data
extractions, data transformations, data staging, movement and aggregation.
· Worked on Informatica Power Center 5.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.
· Developed standard and re-usable mappings and mapplets using various
transformations like expression, aggregator, joiner, source qualifier, router,
lookup, and filter.
· Scheduled and ran Extraction and Load processes.
· Involved in writing project documentation.
Environment:
Windows NT, Oracle8i, PL/SQL, TOAD, Informatica Power Center 5.1.
Trade Role
Dannon Company Inc, OH
Oct 2004 – Apr 2005
Oracle Developer & Database Designer
Responsibilities:
· Gathered the requirement from the client and translated the business details
into Technical design.
· Created and managed Database.
· Used the technical document to design the database tables.
· Created database triggers for data security.
· Created Stored Procedures and Functions to be called by Java Demons.
· Optimize SQL queries for better performance.
· Used the functional document to design application logical and the physical
design using PL/SQL and Oracle Developer 6i.
· Key mapping utility of Forms on Unix environment
· Prepared Test Plans for various modules.
· Prepared user manual and technical support manual.
· Implementation support.
Environment:
Oracle 8i, Oracle Developer 6i, Forms 6i, Reports 6i, Toad 7.0, Java
Inventory Management
JMIT, Radaur, India
Apr 2003 – Oct 2004
Oracle Developer
The application included Real time inventory information on movement and
valuation, Accurate inventory quantity information on location, Managing product
characteristic and specification information, Display inventory data the way you
want it, Suggest products reorder to simplify your purchasing tasks, Lot number
and serial number tracking on all transactions
Responsibilities:
· Requirement study and analysis for the modules.
· Proto types and ER- diagrams for the modules, Sales and Order Module.
· Running the Table SQL scripts from TOAD and creating Oracle Objects like
tables, views, Indexes, sequences and users.
· Writing the commonly used store procedures, functions and packages.
· Optimizing the SQL query using SQL utilities.
· Acceptance testing of all the.
· Building Adhoc reports.
Environment:
UNIX (Server), Oracle 8i, Visual Basic, PL/SQL
Library Automation
JMIT, Radaur, India
Apr 2002 – Mar 2003
Oracle Developer
The application besides the simple Library management had small features
throughout the system that can make the lives of library staff that bit easier –
shortcut keys, configurable
defaults, customizable menus and forms – as well as facilities such as the Event
Scheduler that are designed to minimize the time spent on routine administration.
Responsibilities:
· Understanding and Preparation of requirement for the application
· Proto types and ER- diagrams.
· Running the SQL scripts from TOAD and creating Oracle Objects like tables,
views, Indexes, sequences and users.
· Writing the commonly used Oracle stores procedures and functions.
· Preparing the test cases and performing the unit testing.
· Implementation of database and codes.
· Daily and weekly database backups.
· Database monitoring, table space extension, user locks checking on daily
basis.
· Creation of users, database schemas, tables, indexes, views and sequences.
· Preparation of requirement and design documents.
Environment:
Visual Basic, PL/SQL, Oracle, TOAD, VISIO
Customer Information Management (CIM) for Usha Informatics
Vishaka Infotech, India
July 2001 – March 2002
Data Warehouse Developer
Requirement study, develop processes to extract, transform and load data into
Siebel interface tables from the internal and external sources. Create test plans
to perform unit testing and system testing. Design and implement the data load
mappings using Informatica PowerCenter 5.1.
Responsibilities:
· Understanding and Preparation of requirement for CIM application.
· Running the SQL scripts from TOAD and creating Oracle Objects like tables,
views, Indexes, sequences and users.
· Writing the commonly used Oracle stores procedures and functions.
· Building the Informatica mappings using Lookup, aggregator, update strategy,
filter, normalizer, sorter, and router transformations.
· Preparing the test cases and performing the unit testing CIM application.
· Implementation database and codes at the client location
· Daily and weekly database backups.
· Database monitoring, table space extension, user locks checking on daily
basis.
· Creation of users, database schemas, tables, indexes, views and sequences.
· Preparation of requirement and design documents.
Environment:
Oracle 8, TOAD, Informatics PowerCenter 5.1, Linux, PL / SQL
Training and Other Courses
Institute: CMC
Course Name: Diploma in Web Designing and Development.
Tools Learnt: HTML, XHTML, JSP, and Servlets
Miscellaneous
Reference: Available upon request.
|
