Mahalakshmi S

Email: ac3fol@r.postjobfree.com, Phone: +1-858-***-****

Work Summary:

Having 6 Years of experience in IT Industry as ETL Developer/ Senior Software Engineer

Excellent knowledge in Data Warehousing Concepts, ETL, Database concepts, OOPS concepts

Experienced in Development, Implementations, Testing and Supporting of Data warehousing

Expert in Oracle Data Integrator, SQL

Good understanding in basics of PL/SQL, C, C++, java, XML, Unix

Technical Skills

Oracle Data Integrator (10 G & 11 G), IBM Datastage

SQL

Unix

Oracle

HDFS, HIVE, PIG, Map reduce, Java

Projects

Stage Customer:(Aug 2016 - Feb 2017)

The project is to replace the existing PHP layer which pushes data into ATG repository with ODI. Challenge is to understand how ATG works and the constraints it has on the repositories.

Customer Information Portal:(Dec 2015 – Apr 2016)

Develop services that help customers better manage their Records & Information Management (RIM) program and demonstrate their performance/success to internal stakeholders.

Responsibility:

Study existing CIP portal and its logic.

Develop hive and pig scripts for the same. Process the same in hdfs

Booking to Billing:(Jul 2015 – Nov 2015)

Bookings to Billings are to bring the Opportunity and Opportunity Order data from SKP into BI and give the users the ability to report on the Billings associated with Orders that are in turn tied to a certain Opportunity.

Responsibilities:

Translate the business requirements into technical specifications

Coordinated with the front-end teams in sketching out the interface specification document

Assisted the team in coding complex logic

Conducted reviews on code, unit and functional test plan evidences

supported deployment of the application across environments

Proactively worked with the production support team in analyzing root cause for any issues

Provided business and technical knowledge transition to new comers in the project

Omnitracs:(Mar 2014 – Dec 2014)

Provide reporting which can be used to measure and drive adoption of Omnitracs (device installed in Iron Mountain trucks). Produce a weekly report for the business to track down the vehicles that are being driven without the driver logging in to the Omnitracs console.

Responsibilities:

Participated in design and high level requirement discussions

Designed and implemented the logic

Conducted reviews on code, unit and functional test plan evidences

supported deployment of the application across environments

Proactively worked with the production support team in analyzing root cause for any issues

Sales Hierarchy at Iron Mountain:(Apr 2013 – Dec 2013)

Iron Mountain Business changed its hierarchy, which has impact on billing systems. This project is to enhance/modify the existing system so that it will reflect the change in business hierarchy

Responsibilities:

Understand the business change, analyzed the change for impacts in the existing billing system

Understood the end-to end flow of the Iron Mountain- DW requirements

Understand the new rules, new hierarchy and new billing rules

Added few marts for new hierarchy and assignments, modified few marts for customer, transaction and rate information

Interact with functional and technical team to test the impacted marts

Provide guidance throughout development and testing

Shred Segmentation at Iron Mountain (Feb 2013 – Apr 2013)

Developed a one-time module to calculate the revenue generated as part of shredding business and provide information about the shred services, shred transactions and rates. Generate the customer shred billing who has transaction for shred bill code in past 2 years

Responsibilities:

Worked closely with Solution Architect and understand the requirements

Responsible for design, development, integration testing and deployment

Implemented and delivered the pilot project in timely manner which helps organization for taking decision on Steady Term Phase.

Trained few employees on the Domain, who were assigned to work on steady term integration phase

Revenue Management Phase 2 at Iron Mountain (Nov 2012 – Feb 2013)

The Purpose of this project to feed consolidated enterprise data in to a third-party price optimization tool PROS Pricing Software Suite (PPSS)

Responsibilities:

Installed and configured ODI/ODQ 11g and 10g on Development environment

Provided guidance and training on domain to the freshers and new joiner to the BI/DW development team

Created high level and detailed technical design and ETL flow documents

Reviewed data models and mapping specifications that are provided by the solution architect

Created BI Development Guidelines documentation for ODI

Used LAG / LEAD / DENSE RANKING Oracle analytical functions to solve business logical issues

Migrated ODI Scenarios from Development environment to QA/UAT/Production following SDLC practices

Participated in reviews, meetings, status updates and Client Meetings

Account Manager Book of Business:(May 2011 – Nov 2012)

The Purpose of this project is to

To calculate the commission amount for each account managers based on revenue from the clients associated with them

To provide a data mart to support Account Management reporting

Responsibilities:

Understand the requirements and the existing code.

Modified the existing code to satisfy the requirement as well as to debug it.

Changed few table designs and the load strategy according to the requirements.

Scheduled the package based on all the dependencies for the project.

Developed the interfaces, procedures, packages and deployed the scenario from Development to UAT and then to production.

Documented the Technical Design, Unit Test Case and the technical Instruction.

Revenue Management (PROS) Phase 1 for Iron Mountain - VIRTUSA

Jun 2011 – May 2012

Responsibilities:

Developed numerous packages in ODI which allowed me to explore various features of ODI (Variable usage, Interfaces, Procedures, Scenarios, ODI OS commands,)

Developed the Interfaces for extracting data from different sources and unit tested it.

Developed a basic understanding of master data management (Dimension and Fact tables)

Generated the output in the form of XML files via ODI as per the requirements

Created Technical design documents (TDD), Unit Test cases and Sql scripts for data validation.

Implemented SCD I and SCD II with the help of Knowledge Modules to load the data into the 3NF tables.

Placed the configuration details in a table for easy maintenance

Designed Integrated test cases to ensure the quality

Data Migration for JPMC Client at Virtusa(Aug 2010 – May 2011)

Responsibilities:

Understanding the Business requirement and Design LLD.

Developed the Mapping documents from the Stored Procedures.

Worked on DS Designer Client & Director

Created Sequence jobs, DS Parallel jobs.

Involved in Unit Testing and prepared test cases.

Educational Qualification:

Obtained BE in Computer Science Engineering from Anna University-Chennai, India

Achievements:

Won the Personal Excellance award in “PEP RAVE (Recognize and value each other)”, for my contribution in PROS Integration team.

Received Outstanding Performance award for in Iron Mountain

OCA certified

Contact this candidate