Gitanjali Parida

Email Id: ada2it@r.postjobfree.com

PROFILE:

•Having 10 years of IT experience in Analysis, Design, Development, Conversion, Support and Implementation of wide range of Business Applications (Telecommunication & Healthcare).

•Around 8 years of Design & Development experience in ETL design & development in Data Warehouses Projects using ETL tools, Autosys, UNIX, DB2, SQL and ORACLE.

•Extensively worked on ETL – Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Debugger.

•Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in file hub and database.

•Developed complex mappings in Informatica to load the data from various sources to meet the Business requirements.

•Experience in debugging, error handling and performance tuning of sources, targets, mappings and sessions with the help of error logs generated by Informatica server.

•Extensively worked in scheduling tool to automate the process, achieve and clear the folders.

•Have good experience in working with Scrum and Agile methodology.

•Involved in production support to make sure all issues are fixed in the respective turn-around times.

•Executed all phases of SDLC (analysis, design, development, testing and implementation of software application) and has a strong focus on the quality assurance/Process Improvement/Best Practices.

•Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.

•Excellent working knowledge on Order Management, Product Management, Pricing and Workflow Processes.

•Independently perform complex troubleshooting, root-cause analysis and development.

•Enthusiastic self-starter with great work attitude.

ACADEMIC DETAILS:

•MSITM, in Campbellsville University, Louisville, KY with 3.8 (Out of 4).

•Master’s in Computer Application from OUAT University, Odisha with 8.34(out of 10).

TRAINING:

•Complete the Training on Informatica PowerCenter.

•Complete the training in Order Management, Product Management and Pricing Management.

•Successfully completed the Telecom Specific industry training.

AWARDS & RECOGNITION:

•Outstanding Performance Award from IBM IND PVT LTD.

•Best Performance Award from Mindtree Consulting PVT LTD.

WORK EXPERIENCE:

•Currently working as a Technical Designer in Prudential.

•Worked as Solutions Architecture in Ericsson Global Services from April 2012 to 2017.

•Worked as a Package Solution Consultant in IBM PVT LTD, from August 2006 to 2012.

•Worked as a Programmer analyst in Mindtree Consulting PVT LTD, from August 2005 to 2006.

KEY SKILLS:

ETL: Informatica PowerCenter

Tools: SQL Developer, Toad, WinSCP, Putty, Autosys

CRM: Siebel 7.X & 8.1

Operating Systems: Windows 95/98/NT, Linux

Language: SQL & Unix Shell Scripting

Scripting Language: eScript

Database Systems: Oracle 11g/10g, DB2

Web Technologies: HTML, XML

Professional Experience:

Currently working as a Technical Designer in Prudential USA.

Environment: Informatica 10.

Project Description:

Prudential is a diversified insurance and financial services organization. Its goal is to provide comprehensive financial solutions that help our customers secure their retirement and manage life transitions.

The project is following the Agile/Scrum approaches to analyzing business requirements and provides ETL solution. Translating business processes into Informatica mappings and send the file into different downstream through FMH. This project also needs prudent monitoring on the dashboards and reports to make sure that the data load to the Data Warehouses are proper and providing timely fixes to bugs that appear in the production environment.

Roles and Responsibilities:

•Created complex mappings using Unconnected and Connected Lookup Transformations.

•Develop the requirements with a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.

•Written SQL queries to extract the data in regular intervals to meet the business requirements.

•Incorporate the frame work changes such as creating dynamic parameter file, error handling process, make entries in DB2 tables for audit purpose in the existing mappings.

•Extracted daily and incremental data from various sources and transfer it into various file format depend upon the down-stream.

•Developed the mapping to read the data from fixed length files and create multiple files depend upon the condition for corresponding down-streams.

•Create and set up the Autosys jobs for daily, Adhoc request for inbound and outbound files.

•Write the batch files to run the jobs in windows server.

•Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Connected and unconnected lookup, Rank and Filter.

•Performed unit testing on the given tasks after performing the appropriate mappings.

•Responsible for the performance tuning of the ETL process at the source level, target level, mapping level, and session level.

•Performed E2E unit testing in DEV and UAT environment.

Working as a Solutions Architecture in Ericsson Global Services. April 2012 – 2017

Environment: Informatica 9 &10.

Project Description:

Zain revolutionized telecommunications in Jordan by introducing GSM mobile services into the country. Zain quickly became the foremost telecom company in Jordan. It was the first Middle Eastern operator to launch MMS and mobile data services and infotainment solutions. Zain introduce WAP connectivity in Jordan first and the first to support BlackBerry communication services in Jordan.

Roles and Responsibilities:

•Attended business meeting with the end clients and vendors to analyze the scope of the migration and the project life cycle from end to end process.

•Maintain data models working with the Data Architect.

•Created mapping documents for deliverables.

•Translates business and technical requirements into application modules.

•Contributes significantly to the development of information models. Scheduled walkthroughs of mapping documents, specifications, code, etc. as appropriate throughout project lifecycle.

•Core responsibility for preparing FSD, TDD, designing solution, mapping sheet, implementing the solution and handling tickets raised by client.

•Developed several complex mappings in Informatica with a variety of PowerCenter transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica PowerCenter.

•Worked extensively most of the transformations such as the Source qualifier, Expression, Router, Joiner, Sorter, Filter, Rank, Sequence Generator, Aggregator and Lookup as per the business requirement for populating target files in efficient manner.

•Written complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements.

•Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and by using various components like Variables and Parameter files.

•Analyzed session log files in session failures to resolve errors in mapping or session configuration. Also debugging the mapping to fix the issues.

•Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.

•Prepare the Test case for the requirement.

Worked as a Package Solution Consultant in IBM. August 2006 – 2012

Environment: Informatica 9.x.

Project Description:

Deusche Telekom is one of the world's leading telecommunications companies. Deusche Telekom offers millions of private and corporate customers all over the world the entire spectrum of modern information technology and telecommunications services from wireless communications, Internet and fixed-network to complex IT and telecommunications solutions.

Roles and Responsibilities:

•Involved in analysis of business requirements and keeping track of data available from various data sources, transform and load the data into Target Tables using Informatica Power Center.

•Attended the Business Users Meetings to understand their requirements and designed, developed and Supported Extraction, Transformation and Load Process.

•Extensively worked with Informatica – Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Manager, and Workflow Monitor to develop various complex mappings, mapplets, reusable transformations, session tasks and Workflows.

•Extensively worked on data Extraction, Transformation and Loading from source to target system using Informatica.

•Involved in gathering information for various scenario for Change Data Capture.

•Actively involved in designing different types of mappings for to have effective data process to achieve high performance.

•Involved in system testing, performance and System Integration testing stages of the project.

•Created post-session and pre-session shell scripts and mail-notifications.

•Worked extensively with the connected lookup Transformations using dynamic cache.

•Monitored Workflows and Sessions using Workflow Monitor.

•Supported the applications in Production on rotation basis and provided solutions for failed jobs.

Client: Thomson Reuters

Environment: Siebel CRM, ETL, Oracle 10g, Windows 2000.

Project Description:

Thomson Reuters Corporation is a provider of information for the world's businesses and professionals. The Markets division of the company, consists of Sales & Trading, Investment & Advisory, Enterprise and Media businesses. The Company's corporate headquarters are in New York, with major operations in the United Kingdom, India, and Eagan, Minnesota. It operates in over 100 countries.

Thomson Reuters has multiple implementations which are used by TR’s internal users. The applications have multiple integrations with systems like Informatica, EAI, ICM (Incentive Compensation Management), etc.

Assignment 1: Reuters Informatica Production Support

This is third level production and Implementation support done at IBM, Bangalore following the offshore model. The primary objective of this team for Enhancing, Solving and Supporting requests raised by the business users. Receive the source files from different admin systems and external vendor systems and process the file as per Business requirement. Generate the Tableau Reports for the Business users.

Roles and Responsibilities:

•The project consists of Releases, Fast Tracks, ADHOC requests and Production Support.

•Roles and Responsibilities:

•Utilize in-depth knowledge of functional and Technical experience in conjunction with business skills to deliver solutions to customer.

•Deliver new and complex high-quality solutions to clients in response to varying business requirements.

•Responsible for effective communication between the project team and the customer. Provide day to day direction to the project team and regular project status to the customer.

•Responsible for planning the project execution from offshore and coordination of the design, development, testing and implementation activities from offshore.

•Translate business requirements into Functional Requirements Document and to Detailed Design Documents.

•Lead the efforts including programming and testing that conclude in client acceptance of the results.

•Worked with Source Analyzer, Data Mappings, Transformations, Informatica Repository Manager, Workflow Manager and Monitor.

Assignment 2: Reuters Siebel CRM Development 4.4.300

This is an up-gradation Project from 4.4.200 to 4.4.300 CRM development being done at IBM, Bangalore following the offshore model. The primary objective of this team is to enable the up gradation meeting certain change requests as a part of the development release scheduled in April 2007. The team is responsible for fixing all the issues faced during migration along with handling the change requests raised by the customer.

Roles and Responsibilities:

•Understand the Requirement and prepare the design document

•Estimate the time.

•Implementing a Change Request for modifying the way in which the Email Inbound activities related to sales functionality are created through Work flow process and assigned automatically via Assignment Manager.

•Done the Unit testing.

•Handling TD defects raised by testers and solving them up.

Worked as a Programmer analyst in Mindtree Consulting. August 2005 – 2006

Environment: Siebel CRM, Oracle 9, Windows-2000, Java Script

Project Description:

This is third level production and Implementation support done at Mindtree, Bangalore. Primary objective of this team is to provide production support and do the small enhancement as a part of the development release. Trailer Fleet Services (TFS) is one of the Four Divisions under GE Equipment Services. As an industry leader with one of the most diverse fleets more than 135,000 units it delivers customer-focused services through the extensive network of 100+ branches throughout North America.

GETFS uses Siebel Sales Application to cater its Unique Business needs to attain Customer Satisfaction.

Roles and Responsibilities:

•Involved in Territory Realignment, which happens on a quarterly Basis, to Assign Records Using Assignment Manager Server Component.

•Involved in the Schedule job and modify the interface side code according to the Siebel field.

•Server Components Monitoring on a weekly Basis in addition to Untimely Shutdowns.

•Customizing the Necessary Applets and Views Based on Business requirements.

•Designed Workflows for automating the related Standard Procedures.

Contact this candidate