Data Management

Priya Vaiyapuri

Email ID: *********@*****.***

PH:216-***-****

SUMMARY OF QUALIFICATIONS:

* ***** ** ** ********** in the System Analysis, Design, Development, Implementation and Testing of Database, datawarehousing using Data Extraction, Data Transformation, Data Loading and Data Analysis.

Experience in ETL & Business Intelligence using IBM Websphere DataStage8.1/8.5(DataStage Manager, DataStage Designer, DataStage Director, Parallel Extender), Ascential DataStage 7.5 creating Fact Tables, Dimension Tables using Star Schema Modeling.

Used DataStage Manager to import/export DataStage projects and jobs and to define table definition in the repository.

Extensively made use of stages like XML input/ output, CFF, Modify, CDC, Dataset, Fileset, Oracle Enterprise, Join, Sequencer, Aggregator, Merge, Sort, Filter, Transformer, Lookup, Funnel, Compress etc.,

Used DataStage Director to debug, validate, schedule, run and monitor DataStage jobs.

Excellent experience in Relational Database Management System (RDBMS), Oracle, SQL Server, Teradata, and DB2.

Played an integral part in the building of a multi-server, multi-database enterprise Data warehouse using DataStage ETL (extact, transform and load) tools and SQL Server to load legacy business data.

Integral in the design and implementation of data warehouse through DataStage ETL (extact, transform and load) configurations utilizing multiple Oracle and SQL Server databases.

Extensively used Teradata utilities like Multiload, Fast load and Fast Export.

Worked on Agile and COE projects models.

Involved in creating LLD, HLD, Functional Spec, UTC and UTR.

Experience in schedule jobs in Autosys,Control-M Scheduler.

Proficient in all stages of SDLC (Software Development Life Cycle).

Experienced in Build Creation, TAD deployments and Source Control Tool (TFS).

IBM InfoSphere DataStage v8.0 Certified Developer

Excellent analytical, communication, and facilitation skills with the ability to gain consensus across multiple teams.

TECHNICAL SKILLS:

IBM WebSphere/Ascential DataStage 8.5/8.0/7.5,Oracle, DB2 PL-SQL, Teradata, UNIX, Windows XP/2003/2007/2008, Crystal Report, Aprimo Tool, TAD, Control-M, Autosys, TFS, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Organization: Target Corporation, Minneapolis, MN Aug 2013 - till Date

Title: ETL Solution Master

Target introduced Cartwheel program to enable facebook users to save money on the things you love and share your favorite deals with friends.Users can redeeming, saving and inviting friends to join Cartwheel.

Responsibilities:

Responsible for the design and development of Datastage Parallel Jobs.

Interacted with business staff, leads and all levels of management.

Followed COE model for SDLC.

Prepared the technical design document for each job and developed the ETL mappings.

Involved in Performance Tuning at various levels including Target, Source, Mapping and Sessions.

Prepared the LLD, HLD and functional design documents and ETL process flow document.

Utilized Expressions, Aggregator, Union, Joiner, Router, Look up, Filter, Source Qualifier and Update Strategy transformations to model various standardized business processes and implement business logic.

Wrote DB2 queries to extract and load the data.

Interacted with mappers and testers regarding the mapping document and the code.

Developed, prepared and used test data/cases to verify ETL accuracy and completeness.

Prepared UTC, UTR and produce result to business.

Wrote UNIX scripts to schedule the jobs in third party scheduler Autosys.

Handled various functional and technical issues in the system.

Job for migration cycle between Development, UAT/QA, Stage and Production

Environment: DataStage 8.5, DB2, UNIX, Control-M, TFS, TAD.

Target Corporation, Minneapolis, MN Apr 2013 – Jul 2013

Title: ETL Solution Master

Create a new guest satisfaction program by 2013 which effectively captures feedback across all guest segments in the U.S. and future markets. The program will support Evolution of Service initiatives and provide; relevant, accurate, and actionable insights to store leaders and headquarters. The program will be designed to allow guests to feel their feedback is heard and valued by Target.

Responsibilities:

Business requirements gathering -Lease Management.

Converted functional requirements to detailed ETL technical design specs.

Created standard templates for efforts estimations, unit / system / integration / UAT / production testing docs and delivery process reviews/checklists.

Data modeling and creation of Star Schema data marts using ERWIN tool.

Designed ETL jobs incorporating complex transform methodologies using DataStage tool resulting in development of efficient interfaces between source and target systems.

Customized the DataStage jobs par with current business enhancements.

Wrote UNIX scripts for running and validating the job.

Scheduled staging, dimension (common, global and local) and fact jobs both on onetime / daily and on on-demand basis.

Followed up deployment process of DataStage code migration on different environments (development, test and production) with admin team.

Co-coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.

Monitoring daily jobs and log analysis whenever required.

Environment: DataStage 8.5, Teradata, UNIX, Control-M, TFS, TAD.

Client: Target Corporation, MN Jan 2011 – Mar 2013

Title: Technical Lead

MFD (Marketing Financial Dashboard) involves Enhancing and streamlining the financial forecasting process for marketing metrics. The main objectives of Marketing Financial Dashboard are to increase visibility to marketing financial data and increase efficiency of managing forecasting information. There 3 major source systems are involving such as MIX, ADFin, and ESSBASE.

Responsibilities:

Responsible for the design and development of ETL Jobs.

Interact with SMEs to gather and develop business requirements and worked with team to develop and implement creative solutions to solve business problems.

Interacted with business staff, leads and all levels of management.

Followed Agile methodology for SDLC.

Implement Type I, II, and III changes in slowly changing dimension tables.

Prepared the functional design document and ETL process flow document.

Involved extensively in performance improvement and optimizing the existing long running JOBS in productions.

Developed complex mapping to load the data from various sources using different transformations like Utilized Expressions, Aggregator, Union, Joiner, Router, Look up, Filter, Source Qualifier and Update Strategy transformations to model various standardized business processes and implement business logic.

Loading the data into the Staging and moving the data from Staging to ODS.

Following up deployment process of DataStage code migration on different environments (development, test and production) with admin team.

Prepared the technical design document for each job and developed the ETL mappings.

Involved in peer-peer reviews, Data match Duplicate cleanup activities, Data Recovery processes.

Develop, prepare and use test data/cases to verify accuracy and completeness of ETL.

programs/objects as well as proactively ensuring that unintended issues do not arise as a result of the implementation of developed solutions.

Involved in creating CMR, IMR and creating work request.

Responsible for providing the L1 support for the production failures

Environment: DataStage 7.5, Oracle, DB2, UNIX, Control-M, TFS, TAD.

Client: Target Corporation, MN Jun 2010 – Dec 2011

Title: Module Lead

Marketing Information Exchange is a central business management system used by the Marketing Pyramid to provide visibility into its project scope, budget, funding and estimates. Project involved integration of MIX with various sub-systems in both real time and batch mode. Marketing resource management (MRM) software that automates the process of getting marketing work done. It is a customized version of APRIMO

Responsibilities:

Responsible for the development of DataStage jobs.

Development experience with Oracle 10g, DB2.

Experience with DataStage parallel jobs.

Responsible for understanding Business Process.

Direct and design the ETL process involving data quality and testing.

Responsible for documenting user requirements and translated requirements into system solutions.

Written complex queries to facilitate the supply of data to other teams.

Implemented complex transformations by creating custom transformations in addition to using built-in ones.

Loading the data into the Staging and moving the data from Staging to ODS.

Following up deployment process of DataStage code migration on different environments (development, test and production) with admin team.

Developed Unit test cases and test plans.

Created and executed test cases for various modules.

Conducted peer review of test cases and provided feedback on areas of improvement.

Used SQL queries to retrieve data from Enterprise Data Warehouse (EDW) and validated them.

Communicated the testing status and issue logs with Development team and Mappers.

Environment: MIX (Aprimo 8.0), DataStage 7.5, Oracle, UNIX, Crystal Reports, .NET.

Client: Toppan Management, Singapore Feb 2009 – Jun 2010

Title: ETL Developer

System to manage transactions for all the items and stores which captures information on the item movement, vendor related information for store items including details of the stores / distribution center where it coming from or going to, Incremental data load will be done to identify insert/update and deletes. History information of all the items will be maintained in the dimension tables. Merchandise Item management is the next phase of item, where product id will be associated for all the items. If the same item moves to new item id, a new product id will be assigned to identify the item uniquely.

Responsibilities:

Designed a Data Warehouse to replace the legacy databases to provide decision support in a distributed environment.

Worked with the Business analysts for requirements gathering, business analysis, testing, and project coordination.

Documented user requirements, translated requirements into system solutions and develop implementation plan and schedule.

End-to-end development on DataStage - Hash files, OCI stages, Transformer, Sort stages

Involved in performance tuning of DataStage jobs to optimize performance using Director.

Used Data Warehouse techniques like Star-Schema, snowflake schema based on the environment.

Performed Unit Testing and also Regression testing when needed along with Documentation.

Developed many stored procedures, triggers, functions and packages used for the system.

Environment: DataStage 8.1, DB2, UNIX, TAD, TFS.

Exim Alert Software Solutions, Chennai, India Jun 2005 – Feb 2008

Title: Software Developer

Focus is a Logistics related application which is using by many logistics companies for cess, custom, tax calculations. This project is related to customer support for logging the Issues or help needed for the Focus customers. Based on the ticket queue customer support executives solve the issues.

Responsibilities:

Client communication at various phases such as requirement gathering, design, unit acceptance testing and support.

Responding to customer queries and providing possible solutions

Ownership of complete module from end-to-end

Code walk through and performance related activities

Project induction for the new members and imparting project specific training including functional and technical aspects of the project.

Build creation and deployment.

Root Cause analysis and bug fixes.

Environment: VB.Net, ASP.NET, SQL Server 2005.

EDUCATION:

Master of Science in Computer Science

Contact this candidate