Data Management

ARCHANA TOSHNIWAL

Email: *******.*********@***.*** Phone: 917-***-****

Address: *** ***** **** ******, *** 78, Vineland, NJ 08360

EDUCATION

NYU Polytechnic School of Engineering, NY (Masters in Computer Science) Sept 2014

Relevant Courses: Design and analysis of Algorithms; Introduction to Java; Perl; Database Management; Operating systems

Solapur University, India (Bachelor of Technology) May 2012

Relevant Courses: Data structures; C, CPP programming; 8085/89C51 programming

COMPUTER SKILLS

• Programming Languages: C, C++, Core Java, Perl, PHP, .NET, JavaScript, SQL

• Internet Technologies: HTML, XML, ETL

• Platforms: Windows XP, Windows Vista, Windows 7, Linux, Mac OS

• Tools: Informatica, Oracle, Virtual Machine, MATLAB, Proteus, Xilinx, Protel, Kiel, Circuit Maker

WORK EXPERIENCE

ETL Developer, Bay State Health, Springfield, MA Sept 2014 – Present

• Responsible in gathering Requirements and IT review. Interacted with Business Users in the design of technical

specification documents.

• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat

files, ODS, SQL Server, etc. into the Staging table and then to the target database Oracle.

• Developed various Mappings, Mapplets, and Transformations for data marts and Data warehouse.

• Used Korn-Shell Scripting to automate the loading process.

• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged

the mapping of the failed session.

• Used Pipeline Partitioning feature in the sessions to reduce the load time.

• Used Mapplets and Reusable Transformations to prevent redundancy of transformation usage and

modularity.

• Worked extensively with complex mappings using expressions, aggregators, filters, routers, lookups, joiners, sequence

generator and procedures to develop and feed in Data Warehouse.

• Developed the pre & post session shell scripts, which will create the parameter file dynamically.

• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer

length and target based commit interval.

• Extensive use of Persistent cache to reduce session processing time

• Involved in Unit and Integration testing of Mappings and sessions.

Intern, Fifth Bar Mobile Services Pvt. Ltd, Pune, India June 2012 – Dec 2012

• Worked with databases creating SQL objects like Tables and Stored Procedures

• Able to manage and work with large complex sets of data

• Involved in gathering requirements, performing source system analysis and development of ETL jobs to migrate data

from the source to the target Data Warehouse

• Analyzed business document and created functional requirement document mapping all the business requirements

• Designed and Developed ETL mappings using transformation logic for extracting the data from various sources

• Developed Informatica sessions and workflows for all mappings

Intern, Micromax Instruments Pvt. Ltd, Pune, India Dec 2010 – Jan 2011

• Used XML to create Web-based tools for transactions on SQL and Oracle databases.

• Troubleshot and resolved bugs in .NET applications to ensure optimal development environment.

• Responsible for creating SQL queries and stored procedures

ACADEMIC PROJECTS/ REPORTS

Conway’s Game of Life, NYU Poly, Brooklyn, NY Sept 2013

• Implemented Conway’s game of life in java programming. Created a GUI for the game.

Memory management in Windows Operating System, NYU Poly, Brooklyn, NY May 2013

• Studied about the memory management techniques and its requirements in windows system.

ACHIEVEMENTS

• President: Electronics and Tele Communication Students Association, 2011- 2012

• Graduate Assistant: Worked as Team Lead at Department of Mathematics, NYU, 2013 - 2014

• Recipient: First prize for paper presentation on “Memristors” at the National level event.

Contact this candidate