Data Engineer

Priti Sutone *** Araneo Drive, West Orange, NJ - *7052

Sr. Business/Systems Data Analyst Phone : 617-***-****

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

Profile Summary

A result-oriented professional with 8 years of experience in Information Technology

and a thorough understanding of software development life cycle.

Core competencies constitute client interfacing, project/program management,

application development and support, business/systems data analysis, production

control, change management, business analysis and co-ordination on IT projects.

Proficient in process analysis, requirements gathering & management, writing

functional specifications, business requirement documents, test plan / test case

creation and acceptance testing.

A strategic thinker with a goal-driven mindset, with tremendous persistence and

initiative. Ability to build productive relationships with colleagues, clients and

vendors across all technical and functional disciplines providing focussed business

and systems analyses.

Proficient in tools such as MS Office, MS Visio, Toad and DB Artisan.

Also possess a sound technical acumen with experience in tools such as Clarify, SAP.

Encompass, Autosys, Sharepoint, ETI (ETL Tool) and DataStage. Hands on with

PL/SQL-Crystal Reports, Oracle, UNIX, SQL Server, ASP.

Have been on a career break since February 2008, initially due to temporary

disability and later made a personal choice to care for my daughter. Very sincere

about my work and will get on board within no time.

Experience Summary Apr 07 - Feb 08

Datacom Technology Group Inc.New York

Data Governance Analyst, CIT - New Jersey

PROVIDING BUSINESS SOLUTIONS TO IMPORT FINANCIAL DATA FROM VARIOUS LEGACY SYSTEMS

INTO A COMMON WAREHOUSE THAT HOUSES THE CLEANSED DATA.

Interviewing business personnel for gathering data feed requirements and creating a

Business Requirements document.

Writing Functional/Technical Specifications based on recommendations of banking laws

and regulations issued by the Basel Committee. Creating source-target mapping

documents for technical teams.

A liasion between Business and the Development Teams.

Profiling Data, reporting anomalies to create a work around situation for obtaining

optimum results.

Profiling domain data for Credit Risk and Collateral Management.

Key Data Governance Resource to promote the usage of Profiled and Certified Data for

critical business decisions.

Amtex Systems Inc. NYC Apr 06 - Apr 07

Sr.Market Data Analyst, CITIBANK - New York City

Data analysis on customers for Citibank's Thank You Rewards Network Program.

Worked closely with the marketing team on stragtegies to increase the use of Citi

products to gain points for every dollar spent.

Subject matter expert for Member, Account and Vendor data.

Performing audits on Vendor data before use for tele-marketing, Newsletters

distribution and email communications. Resolving any related data anomalies.

End to end design, development, implementation of transforms.

Responsible for release management.

Patni Computer Systems Inc. Boston Dec 00 - Apr 06

Subject Matter Expert, The Gillette Company - Boston

Subject matter expert for Global Customers and CRM Reports for an Enterprise Data

Warehouse(EDW).

Worked with Business and IT for introducing new feeds to and from the EDW.

Responsible for Business, Functional, Technical Specifications, High Level

Diagrams(HLDs), Data Flow Diagrams(DFDs) and Mapping documents.

Creating ETL Transforms using supplied business rules to the EDW.

Knowledge bank for Global Customers to Business and IT alongwith ownership of data

Hands on with various SAP Modules to storm data anomalies.

Study of raw inbound data in excel, csv,text files.

Advanced Planning and Optimization of Procurement based on Daily Sales/Global Sales

reports.

Project Achievements

Awarded with the VCA (valuable contribution award) from the Data Warehouse

Development Team

Project Leader, The Gillette Company - Boston

Managed all responsibilities in maintaining an Enterprise Data Warehouse.

Responsible for working with Business on new transforms and feeds to the EDW.

Gathering requirements and creating a business requirements document.

Worked with the project team to come up with solutions in implementing transforms.

Involvement in Data Analysis, Tranform Development, Implementation and Post

Production Support.

Quality Check of deliverables and co-ordination between offshore and onsite team

members.

Mentoring team members and participating in resourcing for projects.

Adhering to Service Level Agreements leading to the use of transactional data for

key Business Decisions by Senior management.

Sr.Software Specialist, The Gillette Company - Boston

Responsible for the design, development and support of a Sales Datamart.

Worked on creating load and extraction feeds to the Global Sales Datamart.

Interacting with business to gather detailed level specifications. Maintaining

Global Sales data and reporting per SLAs.

Troubleshooting any data anomalies and fixing them at the source.

Interacting with the offshore team members to deliver the deliverables.

Sr.Software Engineer, The Gillette Company - Boston

Worked as a team meber in development of the Data Hub, a decision making system that

harbored transactional data.

Worked on creating transforms and data feeds.

Designing batch schedules to load/extract data using Autosys for inbound/outbound

interfaces.

Troubleshooting data issues, interface failures and providing a quick fix.

Client site agent for the offshore development team.

Production Support Engineer, The Gillette Company - Boston

Systems knowledge of the EDW, support through batch scheduler, maintenance and

enhancement of the warehouse.

Detailed analysis and documentation of system generated scripts for troubleshooting

data problems and new requirements.

Execution of the Transaction and Master Cycles and provide a solution optimal in

case of failures.

Monitoring the Batch jobs in Autosys.

Tuning of the Production batches for increased performance.

Coordinating with the downstream systems for data deliveries.

Application Developer, Microlistics - Melbourne,Australia

Interacting with clients to gather technical specifications.

Preparing the Functional Specification document for the Billing Module.

Designing front end user interfaces and Crystal Reports.

Writing test cases and reviewing the code.

Quality Controller for outgoing deliverable and Defect Prevention Activities.

Documentation of the Billing Module and preparation of the User Manual to be

submitted to the client.

Providing post implementation support for new change requests and front end

interface changes.

Software Engineer, General Electric Medical Systems - Atlanta

Analysis of the database tables in Oracle R11i.

Study of the changes involved in database tables from Oracle R11 to Oracle R11i,

Reports 2.5 to Reports 6i.

Prepare Technical Specifications for database changes from Oracle R11 to Oracle

R11i.

Conversion and Modification of Reports 2.5 to migrate them to Reports 6i

environment.

Registering and testing the converted reports in Oracle Applications R11i version

Earnest John Technologies Private Limited, Mumbai - India Aug

00-Dec 00

Finance Portal Designer & Content Developer, In house Project

Study and document vortal requirements.

Designing of user interfaces for data entry.

Writing back end validations.

Documentation of project activities for periodic review.

Unit, system and cross-functional testing of the system

Creating user manuals for the systems.

Site maintenance

Academic Profile

Qualification Year Institution

Post Graduate Diploma in Dec 2002 Indira Gandhi national open

Business Management University,India

Master of Computer Applications June 2000 University of Pune, India

(M.C.A.)

Bachelor of Science June 1997 University Of Mumbai, India

Contact this candidate