Som - IT Consultant - Mumbai, MH, India

Neelakshi Som

Mumbai, MH, India

Services

IT Consultant

  • Full time
  • Part time
  • One time
  • Contract
  • Temp

Summary:

Having 8 years of IT experience

Work History

Senior Software Engineer

Wipro Technologies Ltd

From October 2010

Project Name ET - Retail
Client Contact Energy
Role Testing Lead
Responsibilities
• Leading a team of 12 people
• Onsite/Offshore calls/meetings
• Manage daily activities of the team

Duration Dec 2012 till Date
Environment Database: Oracle Tools: Datastage 8.x
Team Size 12
Description
• Involved in day to day activities of the project
• Involved in ETL testing phase of the project.
• Co-ordination amongst various team (involving development and support teams)

Lead/Team Member

Fifth Third Bank

October 2010 - November 2012

Responsibilities Maintenance and Production Support
Duration Oct 2010 to Nov 2012
Environment Database: DB2 Tools: Datastage 7.x/8.x
Team Size 5
Description
• Involved in day to day activities of the project
• Handled project deployments into Production Environment
• Co-ordination amongst various team (involving testing, support and development teams)

Team Member, Developer + Tester

General Electric

May 2010 - September 2010

Responsibilities • Analysis & Testing.
Duration May 2010 to Sep 2010
Environment Database: Oracle Tools: Informatica, PL/SQL Developer.
Team Size 10
Description
• PMS (Portfolio Management System) is an application hosted in Mainframe System; the backend used for this is IDMS.
• PMS is an application hosted in mainframe; it's using IDMS as its backend.


Project Name EPE BO 6.5 to BO XI Migration
Client General Electric (G. E.)
Role Offshore Project Lead + Developer
Responsibilities
• Analysis, Implementation, Testing.
• Converting Informatica Mappings writing PL/SQL Scripts.
• Writing a report to test the performance of BO 6.5 v/s BO XI.
• Interacting with Client and leading the team at offshore.

SQL Developer

BO XI, PL

November 2009 - April 2010

Team Size 5
Description
• All Initial Report Layouts
• Business Rules and Performance Standards
• Data Mapping Document & Technical Design Document (TDD)
• Test Strategy Document
• User Acceptance Test Cases & Test Plan Document
• Unit & Integration Test Cases
• Code Documentation
• Functional Test Cases
• Functional Test Scripts
• Performance Test Scripts


Project Name Power Gen BI SWAT Offshore
Client General Electric (G. E.)
Role Project Lead + Developer + BI Analyst
Responsibilities
• Analysis, Implementation, Testing.
• Use debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Interaction directly with Clients and Onsite through calls and Communication through e-mails everyday for on going work (status) and to follow up with them for its progress.
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks.
• Experienced in Tuning BO 6.5 Reports to identify and remove processing bottlenecks.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used mail for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio, Excel, Word and PowerPoint.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.
• Also, exposed to JAROS Data Modeling Architecture.

Informatica, BO

July 2009 - April 2010

Environment Database: Oracle Tools: Informatica, BO 6.5.
Team Size 5
Description
• Gathering the list of businesses to be involved along with the IM identified stakeholders & also gathering problem statement from the respective businesses
• Brainstorming with IM Team to fix priorities to the pain areas reported by business
• Gather details related to database, ETL, reporting technology (BO, any other tool) implemented
• Finalize the template to be used with IM Team
• Prepare a detailed BI Landscape document with detailed information on the existing BI Landscape across GE Power and Water Business


Project Name CITI CONVERSION (Acquisitions CoE Programs)
Client General Electric (G. E.)
Role Developer + Acting Tech. Lead
Responsibilities
• Analysis, Implementation, Testing.
• Mentoring trainees (new joinees) in developing mappings, sessions and workflows and analyzing the requirements.
• Use debugger in identifying bugs in existing mappings by analyzing data flow and evaluating transformations.
• Interaction directly with Clients and Onsite through calls and Communication through e-mails everyday for on going work (status) and to follow up with them for its progress.
• Experienced in Tuning Informatica Mappings to identify and remove processing bottlenecks.
• Experienced at Creating effective Test data and development thorough Unit test cases to ensure successful execution of the data & used mail for notifying the alerts after successful completion.
• Excellent communication, documentation and presentation skills using tools like Visio, Excel, Word and PowerPoint.
• Provided support and quality validation thru test cases for all stages Unit and Integration testing.

Informatica, Caliber, Citrix

October 2008 - April 2009

Environment Database: Oracle Tools: Informatica, Caliber, Citrix.
Team Size 4
Description
• Providing support while acquiring new portfolios, in the form of Data Extraction from existing systems and porting the same to the VFS system
• Enhancement of existing Process of Acquisition
• Coding new Programs as and when required for different Acquisition
• Carrying out Conversion Process as per the Business needs
• Documentation of all the new/enhanced Processes.


Project Name RISK OPERATIONAL CONTROLLERSHIP
Client General Electric (G. E.)
Role Developer
Responsibilities
• Involved in Design Specifications and technical Sessions and also create detailed project outlines and application design specifications.
• Requirements Gathering, Analysis, Preparing Design Documents, Coding, Testing, Deployment of final product.
• Understood the Business point of view to implement coding using Informatica power center designer.
• Experience with high volume datasets from various sources like Oracle Relational Tables (sources and targets).
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica power center designer and workflow manager Ver 8.1.1.
• Performance tuning has been done to increase the through put for both mapping and session level and SQL Queries Optimization as well.
• Provided support and quality validation through test cases for all stages Unit and Integration testing.
• Performed Informatica code migrations, test, debug, document to maintain programs and deployed.
• Provided support and quality validation through test cases for all stages of implementation.
• Post Production support is done to resolve Issues.
• Experienced in Informatica software installation, configuration for the Informatica client and upgrades as needed.
• Designed and created complex source to target mappings using various transformations inclusive of Aggregator, Lookups, Joiner, Source Qualifier, Expression,...

Assistant Systems Engineer

Tata Consultancy Services Ltd

May 2007 - September 2010

Informatica & Business Objects

May 2007 - September 2008

Environment Database: Oracle Tools: Informatica & Business Objects 6.5 , XI v2
Team Size 1
Description
• It is a part of Corporate Financial Services (CFS). The main aim of ROC project is to find out Discrepancies, incompleteness, mismatches of data in the data warehouse source systems and report them.
• ROC is divided into 2 groups:
Risk • Customer level defects
Operational • Deal, Facility and Loan level defects.

Teradata Tools: Informatica

May 2006 - March 2007

Environment Database: Teradata Tools: Informatica
Team Size 40
Description
WellPoint, Inc. is a large, U.S. based Health Insurance Company and the largest member of the BlueCross BlueShield Association. It was formed when WellPoint Health Networks, Inc. merged into Anthem, Inc., with the surviving Anthem adopting the name, WellPoint, Inc.

Software Engineer

Infosys Technologies Ltd

September 2005 - March 2007

Project Name ENTERPRISE DATA LAYER
Client WELLPOINT INC.
Role Developer
Responsibilities
• Requirements Gathering, Analysis, preparing design documents, coding, testing.
• Provide Wing to Wing Solution and involved in Design Specifications and technical Sessions and also create detailed project outlines and application design specifications
• Create/Define Integration Strategies that are repeatable (Same process or components can be used for different integration.
• Provide Productivity and cost benefits by leveraging offshore facilities for integration activities.
• Experience with high volume datasets from various sources like Teradata Relational Tables (sources and targets) and also used connectivity with Informatica using Teradata Utilities.
• Interaction with Onsite (Tech Leads) everyday for on going work (status) and to follow up with them for its progress.
• Designed source to target mappings using various transformations inclusive of Source Qualifier, Expression, Filter and Router Transformations.

Qualifications & Certifications

SNDT Women's University

Mithibai College

Mount Mary High School

University / Board

Information Technology

SNDT Women's College

Skillpages has been acquired by Bark.com!

Bark.com is pioneering the way people find local services. Skillpages is the world’s premier directory of service providers.

Find out more


Supported Countries
Choose your country

×