Shylaja Packiyanathan

Data Analyst

ac4g2c@r.postjobfree.com

(M)248-***-****

•Having 10+ years of experience in various phases of IT Project life cycle.

•Extensive experience and knowledge in Database Design, Database Modeling, Requirements Gathering, Analysis, Configuration, Integration, Testing, Migration, Administration and execution of end to end systems.

•Highly experienced in Oracle SQL and PL/SQL concepts.

•Extensive experience in using Informatica for data migration between various systems.

•Developed reusable mappings and workflows using designer tool set of Informatica.

•Instrumental in optimizing performance of Database dependent applications and DB queries.

•Extensive hands on experience in Siebel EIM. Developed interfaces using batch-processing concepts for automating EIM process.

•Extensive experience on Siebel DB reporting.

•Extensive hands on experience in using XSLT for data validation and transforming the XML.

•Good knowledge on ITIL processes, HP Quality Center for defect tracking, Source code management using Tortoise SVN.

•Coordinated with client and business effectively being onsite coordinator for the team.

•Worked extensively to convert business requirements into technical requirements.

•Experience working in Agile methodology.

•Experience working and leading in Onshore – Offshore model.

•Mentored junior database team members in Database SQL queries, SQL objects such as stored procedures, functions and trained them for performance optimizations.

•Goal – oriented team player adept at building strong relationships with team and customers.

•Always looking forward working with latest technologies and latest tools.

Experience Summary:

•Worked as Systems Analyst with ARMO Consultants since June 2015 till date.

•Worked as Systems Analyst with Birlasoft Inc. since Dec 2009 to June 2015.

•Worked as Sr. Operations Executive with Infosys Technologies Ltd since July 2006 to Dec 2009.

Skills:

•Database : Oracle, SQL Server

•ETL Tools : Informatica

•SIEBEL Versions : Siebel 7.8.X, Siebel 8.0, Siebel 8.1.X

•SIEBEL Skills : Siebel Open UI, Siebel EIM - EAI, Siebel Configuration, Siebel eScript

•Language : C, Java, HTML, Visual Basic, CSS, jQuery, HTML 5

Professional Experience:

Montgomery County, Elkridge, MD June 2016-Jan 2017

EICM project includes developing Data warehouse from different data feeds and other operational data sources. Built a central Database where data comes from different sources like oracle, SQL server and flat files. Actively involved as an Analyst for preparing design documents and interacted with the data modelers to understand the data model and design the ETL logic.

Roles and Responsibilities:

Responsible for Business Analysis and Requirements Collection.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Parsed high-level design specification to simple ETL coding and mapping standards.

Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

Created mapping documents to outline data flow from sources to targets.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Extensively used SQL loader to load data from flat files to the database tables in Oracle.

Used Debugger to test the mappings and fixed the bugs.

Created IFB files for moving the data from EIM to Siebel.

Performance tuning has been done in new data base.

Table fragmentation has been done for the large volume tables.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: Informatica Power Center 9.5, Oracle 11g, Siebel Public Sector, Siebel Tools, Siebel EIM.

NYCHA, New York City, NY June 2015 – June 2016

NYCHA Improving Customer Experience - is a significant, multi-year, initiative that will dramatically improve the way in which NYCHA conducts business with external customers as well as internal customers. NICE will automate manual processes within Leased Housing, Application and Tenancy Administration (ATAD) and Maintenance Operations, as well as expand enterprise-wide successful technology initiatives such as the Call Center and Hand Held Inspections. The technology at the core of NICE will allow documents to be scanned, will create electronic files that can be accessed by those who need them, and will provide standardized inspection programs on hand-held instruments. These changes will significantly reduce the number of times data will have to be entered into the system, and allow staff leased housing voucher holders and tenant’s landlords, and public housing residents to find answers to their questions expeditiously and accurately through multiple mediums, including telephone, in-person and computers. The data in the folders will be dynamic and will allow for automatic scheduling and for multiple people to work on applications and annual certifications simultaneously, thus increasing efficiency.

Roles and Responsibilities:

•Responsible for joint application requirement and design to understand business needs; preparation of process document and high level design documents.

•Worked with business users to transform business requirements into technical requirements.

•Was involved in Data Model and ETL Design (Mapping Specification and Mapping document).

•Used Transformations to load the data from flat file to holding tables and from holding tables to Siebel tables.

•Built complex PL/SQL procedures and packages.

•Built an interface between Siebel and mainframe systems.

•Created Oracle database links to establish connects between the systems and automated inbound and outbound transactions.

•Implemented error handling mechanism for various data interfaces.

•Used Siebel EIM for automating and Siebel RCR for scheduling the job.

•Worked on migrating history data from a Java based application into Siebel and sunset the java application.

Environment: Informatica Power Center 9.5, Oracle 11g, Siebel Public Sector, Siebel Tools, Siebel EIM.

GE Capital, Danbury, CT Apr 2010 – June 2015

Siebel – ROW application deals with automation of Submittal, Risk Analysis, Approval and Lending of GE Loans to various customers. Siebel Financial Services 8.1.1.10 is integrated with various other applications through IBM MQ Series and ESB. Various business of GE is slowly integrated into the application in each release. Major objective is to reduce the manual intervention as much as possible and thereby fasten the complete process of lending loans.

Roles and Responsibilities:

•Was part of 8 major releases that included development of new functionalities, major and minor enhancements.

•Involved in requirements gathering, technical assessment, plan, design, build and assessment of various areas of Siebel application.

•Responsible for Business Analysis and Requirements Collection.

•Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

•Parsed high-level design specification to simple ETL coding and mapping standards.

•Designed and customized data models for Data warehouse supporting data from multiple sources on real time.

•Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

•Created mapping documents to outline data flow from sources to targets.

•Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

•Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

•Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.

•Used Debugger to test the mappings and fixed the bugs.

•Extensively used SQL loader to load data from flat files to the database tables in Oracle.

•Involved in coding several Oracle procedures, DB views needed for real time & batch interfaces.

Environment: Informatica, Oracle 10gR2/11gR2, Siebel 7.x/8.0/8.1.1, Open UI, Siebel Tools, MQ Series

GE Capital, India Dec 2009 – Mar 2010

Franchise Finance is one among divisions in GE. Siebel 7.5 Franchise finance is moved to Siebel 8.1 Financial Services. This involved migration of corresponding business data to newer application.

Roles and Responsibilities:

•Designed and developed Real-Time & Batch interfaces to integrate with various legacy systems.

•Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.

•Created mapping documents to outline data flow from sources to targets.

•Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

•Used complex transformations like routers, lookups, expression, filter, aggregator, sequence generator, etc. in Informatica mapping designer for data conversion.

•Involved in configuring Siebel Application, GUI & Business layer objects using Siebel Tools.

•Customized application by creating workflows, business services, Siebel eScript, BRPs, DVMs, Runtime events.

•Created Siebel EIM Configuration files to migrate all entities from Siebel 7.5 to Siebel 8.0.

•Involved in creating shell scripts for automation of all batch jobs.

•Involved in migrating Service Request attachments from Siebel 7.5 to Siebel 8.0 using EIM Export/Import processes.

Environment: Informatica, Oracle 10gR2/11gR2, Oracle PL/SQL, SQL Loader, Siebel 7.x/8.0/8.1.1, Siebel Tools, MQ Series.

DHL Express, India Nov 2008 – Nov 2009

COMET facilitates the automation of the Global Sales Process across new DHL organization. Provides complete picture of customers, monitors health of the business and identify future sales opportunities.

Roles and Responsibilities:

•Worked as a Maintenance & Development team member.

•Built new data load interfaces using batch processing for validation and to load data.

•Used Informatica to stage the data that needs to m=be imported to the Siebel staging area.

•Used complex transformations like routers, lookups, expression, filter, aggregator, sequence generator, etc. in Informatica mapping designer for data conversion.

•Created mapping documents to outline data flow from sources to targets.

•Created PL/SQL procedures and package to process the data.

•Implemented error handling mechanism.

•Fine tuned complex SQL queries to improve database performance.

•Loaded all major entities using Siebel EIM concept and batch processing.

•Troubleshooting and fine-tuning the existing interfaces.

•Was responsible for maintaining VSS with the updated documents.

•Mentoring the new teammates being a senior team member in the project.

Environment: Informatica, Oracle 9i & 10g, SQL Loader, Siebel EIM.

Johnson Controls INC, India Feb 2007 – Oct 2008

This project is a Siebel Greenfield implementation to enable its services business to drive higher differentiation. Dealt with migrating data from multiple systems into Siebel. Data conversion involved complex transformation rules moving large volumes of data into Siebel using Informatica and EIM.

Roles and Responsibilities:

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

•Importing source/target tables from the respective databases and created reusable transformations and Mappings using Designer Tool set of Informatica.

•Created Transformations and Mappings using Designer Tool set of Informatica.

•Used complex transformations like routers, lookups, expression, filter, aggregator, sequence generator, etc. in Informatica mapping designer for data conversion.

•Scheduled Workflows Using Workflow Manager.

•Created Siebel EIM codes (Configuration files) to migrate the data into Siebel 8.0 system.

•Loaded major entities like Accounts, Contacts, Opportunities, Activity Templates and Addresses.

•Involved in debugging and troubleshooting the Informatica processes and EIM processes.

•Was responsible for maintaining VSS with the updated project documents.

Environment: Informatica, Oracle 9i, Oracle PL/SQL, Batch processing, Siebel EIM.

Contact this candidate