Data Manager
Resume:
Usha Mandali
Lead /Senior Informatica Developer
Ph: 585-***-**** Email: ****.*************@*****.***
Experience Summary
Over 8.6+ Years of experience in analysis, design, development, testing, deployment, project management and production support of Data Mart, Data Warehouse systems.
Experience in interacting with Business users in analyzing the Business requirements and transforming them into documenting, designing, and rolling out the deliverables.
Extensively worked on Informatica Designer Components-Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor.
Experience in creating of transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica designer.
Excellent knowledge in various operating systems and database systems such as UNIX, Windows, Oracle 10g/11g
Extensive experience in handling large volumes of data and handling Performance issues during ETL load
Experience in writing UNIX shell scripts, scheduling jobs through control4
Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, SQL, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets
Experience in writing, testing and implementation of the triggers, cursors, procedures, and functions at database level using PL/SQL
Experience in managing projects, interact with various teams, prepare Project plans and ensure the deliverables are met and issues managed.
Experience in analyzing the business processes, analyzing the data quality, defining data granularity, data elements mapping, and data modeling for data warehouse systems.
Expertise in implementation of SFTP, FTP services to retrieve Flat Files from the external sources
Excellent working experience on Data Warehousing applications with direct responsibility for the Extraction, Staging, Transformation, Pre Loading and Loading of data from multiple sources into Data Warehouse.
Strong knowledge and experience in data warehouse systems development life cycle.
Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements
Experience in providing support in post-deployment phase and project transition to product support.
Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to learn quickly.
Ability to work effectively and efficiently in a team and individual environments with excellent interpersonal, technical and communication skills.
Working as onsite coordinator and leading a team of 10 members
Education:
Bachelor degree in Computer Science and Engineering – Jawaharlal Nehru and Technology University, India
Skills Profile
ETL
Informatica Power Center 8.x/9.x
Scripting Tools
UNIX Shell Script, VBScript
Database
Oracle 11g,10g/9i,SQL Server
Software
Control4
Version Manager
Visual SourceSafe, CVS, SVN
Tools
Toad, Filezilla, WinSCP,MS Visio, PL/SQL Developer,SQL developer,SSIS and SSMS,CDP
Work Experience
Client: Xerox Corporation
Role: Onsite Coordinator, Implementation Lead Sep 2014 –Till Date
Name: Xerox Brazil, Mexico and Marketing Operations Support
Description:
Xerox Brazil and Mexico applications will process data feeds from various third party vendors of Xerox like utility bill payer, building Maintenance group. Providing necessary financial outlook using various reports. These applications will send invoices to Brazilian and Mexico governments for further processing.
Responsibilities:
Informatica, PL/SQL Developer and Onsite Coordinator with rich experience in developing and maintaining wide variety of business applications/products
Perform Requirements gathering, analysis, design, implement, test and deploy applications using Informatica-power center, Oracle and UNIX Shell Scripting.
Prepared Estimation based on the complexity and object details and Schedule, Plan Resources and Task Tracking
Managed quality of code deliverables by performing code review
Developed Functional requirement specification and data architecture document and held meetings with the concerned stakeholders. Conducted Impact and feasibility analysis.
Working in a production supporting environment applications
Increased Code Reusability using Shortcuts, Mapplets, Reusable Transformations and Reusable Sessions to reduce redundancy in code.
Successfully handling onshore-offshore co-ordination duties.
Excellent interpersonal & Client Management Skills and the ability to interact professionally with a diverse group, executives, managers and subject matter experts.
Possesses strong analytical skills to interprets customer business needs and translate them into application and operational requirements
Continuously working with various stake holders to ensure smooth production roll-outs.
Working on Common Delivery Process which is ticketing system for Xerox to log production issues.
Environment:
Informatica Power Center 9.5, Oracle PL/SQL, UNIX Shell Scripting,Control4
Client: Xerox Corporation
Role: Senior Lead Developer Oct 2013 – Aug 2014
Name: XPRO Services
Description:
FIX (Financial Information for Xerox) system assists Xerox in managing the profitability of accounts by providing revenue and expense reporting.
The goal of project XPRO is to upgrade the software technology and reengineer FIX to both efficiently and effectively meet the expected needs. The scope and purpose of new project is technology upgrade components for each application in the FIX legacy environment (SALSA, Financials, Materials Inventory, and the Variable Billing System) and the reengineering for each of these same systems.
Responsibilities:
Developed complex workflows and used various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision, Session in the workflow manager.
Worked with heterogeneous source to Extracted data from Oracle database and flat files and loaded to a relational Oracle warehouse.
Implemented the security by having the information in parameter files.
Created test cases and involved in Unit testing, System Testing, User Acceptance Testing to verify accuracy followed by regression testing and completeness of ETL process.
Extensively worked on performance tuning at all levels of the Data warehouse. Implemented performance tuning by using lookup caches, gathering stats, dropped indexes and re-created them after loading data to targets and increased the commit interval.
Implemented SFTP, FTP services to retrieve Flat Files from the external sources, Created shell script to connect external servers using SSH, SFTP and FTP process.
Created shell script to connect Informatica repositories and control4 server to execute the jobs
Developed shell scripts for Daily and weekly Loads and scheduling them using Unix Cron utility and control4
Used Debugger to test the data flow and fix the mappings.
Performed Code and quality reviews on the deliverables to deliver the robust, reusable and defect free solutions with high performance
Worked with reporting team to help understand them the data structure and the dimensions and measures on them.
Worked on other tools like WinSCP for transferring the files from Windows to UNIX and vice-versa, Control4, Putty for connecting to UNIX and run the scripts.
Migrated repository objects and scripts from development environment to production environment
Environment:
Informatica Power Center 9.1, Oracle PL/SQL, UNIX Shell Scripting, Control4
Client: Xerox Corporation
Role: Senior Lead Developer June 2012–Sep 2013
Name: NER Canada
Description:
The Natural Expense Reporting (NER) is a Global Purchasing analysis tool. The system’s purpose is to provide users with information regarding Xerox’s vendor spend. It provides them with the means to analyze where US Xerox non-production dollars and Xerox Europe production and non-production dollars are being spent.
Responsibilities:
Analyzing the current application code and developing/modifying the existing Mappings as per the new requirement.
Designed and developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and oracle tables to target tables
Tuned mappings using Power Center-Designer and used the best practices to provide maximum efficiency and performance.
Developed Pre and Post SQL scripts to drop and/or create indexes on Target tables to optimize loading query speed.
Developing and scheduling the SSIS packages
Hands on experience in creating the Views, Stored procedures and Functions.
Involved in the maintenance, bug fixes & request analysis of the existing reports
Preparation of System End to End documents.
Environment:
Informatica Power Center 8.6,SSIS, SSMS, Oracle PL/SQL, UNIX Shell Scripting
Client: Xerox Corporation
Role: Developer Mar 2011 - May 2012
Name: NAOSC Application Development
Description:
North American Outbound Supply Chain (NAOSC) Data Warehouse is a solution set for the business challenge of Xerox Information Management. It addresses and provides solution for all the departments like parts, supplies and equipment. There is huge number of sources for data that comes into the system. Primary source of parts, supplies and equipment inventory data are the Webster Logistics Center, 3 Distribution Centers, 60 District Part Centers, CSE’s, PDCs, and Supply Centers.
Responsibilities:
Understanding the existing system, business requirements and executing new change requests for enhancing the existing system.
Preparing ETL specifications for identifying sources, targets and data transformations.
Extensively Developed Informatica mappings using various transformations like Joiner, Lookup, Source Qualifier, Filter, Rank, Router, Sequence generator, Normalizer, Update Strategy transformations.
Developing CRON tabs to execute the above Informatica extracts in an orderly manner.
Make sure that all the daily, monthly data loads are happened and should be available to Business on time.
Operations support (OPS) monitoring for the Informatica loads in all the production systems.
Monitoring, analyzing and fixing any production issues during the OPS support.
Running the failed Daily, Weekly, Monthly DW/RPT reports.
Providing end–to–end support for all the activities that is being carried out in the OPS monitoring process.
Alerting the concerned person (DBA, in case of any critical issues).
Hands on experience in creating the Views, Stored procedures and Functions.
Environment:
Informatica 8.6,Unix Shell Scripting, Oracle PL/SQL
Client: Xerox Corporation
Role: Developer Dec 2009 – Feb 2011
Name: Distributed Data Stream
Description:
Distributed data stream delivery and dissemination systems today produce stream data at multiple, geographically distributed locations. It is often too expensive to stream all of the data to a centralized processor, both because of the high communication costs, and the high and yet continuously changing processing load at the central server. Therefore, in order to ensure efficiency and scalability, these naturally distributed applications adopt a distributed processing paradigm.
Responsibilities:
Created new procedures, functions, triggers, packages, and SQL*Loader scripts, and modified existing c codes, tables, views, and SQL*Loader scripts
Developed ETL programs using Informatica to implement the business requirements
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center
Involved in extracting the data from the Flat Files and Relational databases into staging area
Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow
Fine tuned long running reports.
Tuned SQL queries to improve response time.
Extensively worked in performance tuning of programs and processes.
Worked closely with DBA for proper backup and recovery plans.
Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
Fixed the invalid mappings and troubleshoot the technical problems of the database
Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules
Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques
Environment:
Informatica 8.6,Unix Shell Scripting, Oracle PL/SQL
Client: Secure grid Network Technologies June 2007 – November 2009
Role: Developer (Intern)
Name: Distributed Data Stream
Description: Distributed data stream delivery and dissemination systems today produce stream data at multiple, geographically distributed locations. It is often too expensive to stream all of the data to a centralized processor, both because of the high communication costs, and the high and yet continuously changing processing load at the central server. Therefore, in order to ensure efficiency and scalability, these naturally distributed applications adopt a distributed processing paradigm.
Instead of shipping all data streams to a single node and processing all the file transfers from a centralized server, many have shown that performing distributed processing of file transfers using techniques such as in-network processing and filtering at the source minimizes the communication overhead on the system and helps spread processing load, significantly improving performance.
Responsibilities:
Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
Created new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
Develop the mappings using needed Transformations in Informatica tool according to technical specifications
Developed mappings/sessions for data loading.
Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup, Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
Write Shell script running workflows in unix environment.
Optimizing performance tuning at source, target,mapping and session level
Tuned SQL queries to improve response time.
Wrote UNIX shell scripts to run SQL scripts daily.
Extensively worked in performance tuning of programs and processes.
Worked closely with DBA for proper backup and recovery plans.
Monitored performance and changed performance requirements through application of Database tuning and performance optimization techniques
Environment: Informatica 8.5, Unix Shell Scripting, PL/SQL
Contact this candidate