SUMMARY:

• Over 13+ years of experience in Information Technology with strong emphasis on software analysis, design, development and implementation of Data Warehousing applications using ETL tools like SAP Data Services, Informatica 8.1/9x, Informatica Metadata Manager, Embarcadero, SSIS, Data stage/ Info sphere, SQL Loader and OLAP tools like Business Objects, ApEx
• Over 10+ years’ experience as a Business Analyst/Data Analyst/UAT Lead with good management skills, requirement writing, data analysis and User Acceptance Testing (UAT) of any financial applications and followed the Software Development Life cycle (SDLC) methodologies.
• Over 10 years of experience working on Oracle 11g/ 10g/9.x/8.x/7.x, SQL server 2000/7.0, DB2, MS Access 7.0/’97/2000.
• Over 9 years of experience using the full system development lifecycle including Business/ Data Requirement Analysis, Quality Assurance, Development, Report Writing, Technical writing, support and installation
• Over 6 Years of experience in specialization in Data Governance, Data Quality, (IAM) identity and Access Management.
• Strong experience in Data Warehousing, Data Architecture, Data Modeling, Data Mining, Data Analysis, Decision Support System (DSS) and GUI applications
• Working knowledge on different data sources ranging from flat files, Excel, Oracle, MYSQL, Sybase IQ, SQL Server, UDB DB2 databases, XML, DTD, VSAM files
• Very good background in design and implementation of Data Modeling at both OLTP and OLAP with Relational, Star Schema, Snowflake Schema and Multi Dimensional Modeling using the ERStudio, ERWIN, MYSQL
• Experience in data analysis including the understanding of business requirements and documenting clear data requirements for complex business rules for data transformation. Experience working with business experts to validate the requirements for comprehensive and accurate.
• Experience analyzing source system data to research and validate data requirements clearly communicating data issues and working toward a resolution in the data design.
• Experience working with data modelers to provide a clear understanding of data relationships and cardinality. Working with the data modeler to ensure the model correctly expresses the data requirement.
• Strong working knowledge of data warehouse techniques and practices, including ETL processes, dimensional data modeling, OLTP/OLAP, star schema and ETL performance tuning
• Adept at handling multiple projects and tasks simultaneously to deliver solutions from conceptual stage to delivery to end user.
• Excellent interpersonal and communication skills, Strong analytical and problem solving skills.

TECHNICAL SKILLS:

ETL tools: Informatica Metadata Management 9.x, SAP Business Objects Data Services 4x, Embarcadero DT - Studio, SAP Business Objects Information Stewart, Informatica Power Mart 4.7/6.1/6.2/8.1/9. x, Power Center 8.1/7.1/6.2, Data Stage 6. X / 7.x (Designer, Director, ManagerAdministrator), SQL * Loader. 6.0. SQL Server DTS, SSIS

OLAP Tools: Business Objects 4.0/5.0/6.0, Cognos 7.0 Impromptu and Power playApEx

Databases: Oracle 11g/10g/9i/8i, MS SQL Server 6.5/7.0/2000, MYSQL 4/5X, UDB DB2, Sybase IQ, MS Access, Teradata

Case Tools: Rational Rose, Erwin4.2

Languages: JDK1.3/1.2/1.1, JSDK1.2, Java Script1.2, VB Script 5.0, PL/SQL 8.x/2.2, CC++, C#

GUI: AWT, SWING 1.1, VB 6.0/5.0

Web Technologies: HTML, DHTML, J2EE, ASP.Net

Web Design Tools: Netscape 4, Internet Explorer, MS FrontPage, Dream Weaver.

PROFESSIONAL EXPERIENCE:

Confidential, McLean VA

Business Data Analyst/ Architect/ ETL Architect

Responsibilities:

• Analyzed the existing application’s information by understanding the data transition between systems.
• Experience in leading interactions with the business users to break down business requirements into Information/Data requirements, including transformation logic.
• Responsible for performing the management functions of planning, coordinating, implementing and controlling related to various data quality assessment tasks.
• Interacted with business users, system analysts and technical teams for obtaining details about the requirements and also to come up with the best solutions for design
• Based on the technical specification documents, designed logical/ physical data models in Erwin/ER-Studio to support the warehouse and the data marts.
• Convert the business requirements to technical/ETL specifications and applied the business rules during development.
• Working with SF CFO Change management team and developed hands-on experience on Finance Accounting systems and SOX controls testing’s.
• Perform analyses of data, business processes, products and services to help design business reports, metrics and make recommendations to improve and support business activities/groups.
• Extensively involved in managing UAT sessions, Test planning, Test design, writing Test cases, Test automation, Test execution and related artifacts.
• Automated the complete UAT progression/regression testing (SQL scripts) and also automated the critical SFTA/Multifamily key Control005 (Auditing) scripts for all scenarios using the ETL tool (Informatica) and PLSQL.
• Extensively worked on various data sources DB2, Oracle, XML/Flat files and loaded into MS-Excel/MS-Access to analyze the data.
• Worked on impact analysis, gap analysis on any changes that occurred in SFTA sub ledger (OSL)/ Phoenix Accounting systems.
• Prepared the High Level Design document to provide an overview of the technical design specification system required for SFTA Automation (UAT/ Auditors testing/SIT Testbed) .
• Extensively worked on the Source to target mapping with business rules where ever it is required.
• Worked & managed the technical team (Informatica ETL developers, DB2 & Oracle DBA’s) to create the test environment (test bed) and automate the process which helps testing teams (SIT) or UAT teams to test the all the scenarios for the accounting events easily.
• Worked with business users and the technical teams on fixing defects and on issue resolutions

Environment: UNIX, Linux, Windows XP Professional, MS-Office tools, web services, Rapid SQL, SQL Developer, Erwin, DOORS, Informatica power center 9.x, DB2, Oracle, Excel VBA - Macros

Confidential, McLean, VA

Metadata Analyst/ Sr Data Analyst

Responsibilities:

• Analyzed the existing applications metadata information and understanding the data transition between systems.
• Interact with the both the functional and technical team frequently to come up with the best ETL, Data Modelling solutions
• Participated in the analysis of the current business process of the Integration Data warehouse (IDW) and provided feedback with Impact Analysis, Data Lineage reports on the entire system (Data modelling, ETL Programs, and Teradata database) and Business Glossary.
• Extensively worked on the Informatica Metadata Management (9.x) tool to extract the metadata of various applications repositories like business reporting intelligence (Cogno’s, Business objects etc.), Data Integration (Informatica Power center 9.x), data modelling ( Erwin, ER-Studio etc.), Relational metadata sources(Teradata) and loading into the centralized metadata warehouse ( Metadata Manager warehouse.)
• Performed Impact Analysis of ETL programs and provided ETL support on as needed basis.
• Worked with the Informatica Administrator and Configured the Informatica metadata tool with the Power Center, Erwin, Terdata, Cognos, Business objects.
• Developed the User Guide to simplify the search/browse on all the metadata catalogs, data lineage for analysis of metadata objects and business terms.
• Developed the Runbook / Operational support guide to maintain the Resources loads, Configuration information, application security such as access/user roles etc., schedule/monitoring, naming standards etc.
• Analyzed on the lineage breakages and designed the Custom data model using the Informatica Custom XConnect / Informatica Configuration management tool to create the linkages.
• Responsible for performing the management functions of planning, coordinating, implementing and controlling related to various data quality assessment tasks.
• Used the consolidated mapping documents as input and loaded metadata into the custom models to resolve the lineage breakages between the sources to target lineages.
• Created the Custom model resources, mapping rules to resolve the linkage breakages between the catalog objects, source to targets relationships.

Environment: Informatica Metadata Manager 9.5, Informatica Analyzer 9.x, Informatica power center, Teradata, UNIX, Linux, Windows XP Professional, MS Office/ Visio, PowerPoint, PL/SQL, Teradata SQL assistance, SQL Developer, Erwin, Cognos, Business Objects

Confidential, Arlington, VA

Lead ETL/ Sr Data Analyst/ Data Architect/ System Analyst

Responsibilities:

• Analyze the existing transactional application systems data to identify the nature/structure of the data, relationships and referential integrity among the tables that leads to the creation of a logical design of the enterprise data warehouse and the data mart
• Analyze the reporting/business requirements from the business users and convert them into technical specifications.
• Worked with the Informatica Administrator and Configured the Informatica metadata tool with the Power Center, Erwin, Teradata, Cognos, Business objects.
• Responsible for performing the management functions of planning, coordinating, implementing and controlling related to various data quality assessment tasks.
• Lead the effort in converting the logical design to physical design by enforcing naming standards, referential integrity across multiple subject areas
• Based on the technical specification documents, designed logical/ physical data models in Erwin/ER-Studio to support the warehouse and the data marts.
• Heavily involved in gathering technical requirements, analyze data, leading ETL Development/ Administration, provide technical solution and production support for Enterprise Data warehouse (EDW) and Regional Data Mart Modernization (RDMM) Projects.
• Worked as a data analyst including the understanding of business requirements and documenting clear data requirements for complex business rules for data transformation
• Developed ETL Mappings/ Programs using SAP Data Services, Informatica9.x, Embarcadero, Data Stage / Info sphere, SQL Loader & PL/SQL, SSIS over the tenure at FDIC
• Actively involved in design and develop Corporate Data Dictionary for accessing the corporate wide metadata.
• Created multiple reports within Informatica 9X IDQ / SAP Business Objects Information Stewart focusing on data governance, metadata management (MDM) and the data lineage starting from business objects reporting elements to BO universe to the actual database and then capturing the transformations through the ETL tool and further tying it with the Erwin/ER-Studio data models.
• Created the enterprise data warehouse design in third normal form and the data mart design as de-normalized with fact and dimension tables created star schema’s and snowflake schema’s where required and enforced conformity across the subject areas to avoid any stove piping
• Convert the business requirements to technical/ETL specifications and applied the business rules during development
• Tuned the ETL processes for better performance by identifying the bottlenecks at the source and target databases, mapping and task levels and optimized them by implementing best solutions.
• Involved in Migrating the code to higher environments and supported operations and maintenance for the application.
• Developed Stored Procedures on Oracle as needed to Extract, Transform and load the data from multiple source systems to the enterprise data warehouse.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Involved in all the DBA activities like installing the Oracle software, backup, restore, creating users and all database maintenance activities.
• Worked closely with Informatica/SAP ETL Administrator related activities on creating the user groups, folders, Installing/Upgrading, server related activities like patches, re-boots etc.
• Developed interactive reporting application for the client and a data search engine on Oracle Application Express to run ad hoc queries and create reports
• Analyzed existing SQL Server, COBOL, MYSQL programs to extract business logic and convert them into packages/stored procedures on Oracle to load the data into fact tables.
• Analyze the SAS datasets and convert the existing SAS programs to stored procedures with an in depth understanding of the business rules.
• Developed ad hoc reports on Documentum database to maintain the Personal Identification Information across FDIC.
• Write macros in excel for manipulating and formatting the templates and merge all the templates to one standard data file.
• Analyzed the data to come up with validation rules and data quality checks to further implement them using the Informatica IDQ data quality tool.
• Prepared standard operating procedures and manuals to provide adequate information on application *maintenance
• Used Share Point for defect handling and documents sharing.

Environment: Informatica 8.1/9.x, SAP Data Services, SAP Business Objects Information Stewart, IBM Data Sage 7.5/ Info sphere 8x,MYSQL 4.0/5x, SQL Developer, Oracle 10g/11g, Oracle APEX 3.1/4x, UNIX, Linux, Windows XP Professional, Linux, MS Office/ Visio, PowerPoint, Soap web services, Advanced Query Tool, SQL Developer, Embarcadero, SQL Loader, Erwin, ER-Studio

Confidential, Washington, DC

Data Warehouse/ Sr Informatica Consultant

Responsibilities:

• Gather and analyze the business requirements of the project by understanding the data transition between one systems to another.
• Interact with the both the functional and technical team frequently to come up with the best ETL solutions
• Analyze the existing mappings, Re-wired and validated them to meet the requirements.
• Involved in migration from Informatica 6.1 version to 8.1 version for several application
• Reviewed the existing Stored procedures that are in Sybase database and converted, ran successfully in Oracle 10g
• Worked extensively on Informatica Power Center 8.1 tools such as designer, Workflow Manager in creating complex mappings involving Reusable Transformations, created Mapplets, sessions and workflows
• Changed the SQL Override Queries from Sybase/ MYSQL to Oracle across multiple mappings and validated to meet the requirements
• Analyzed the dependencies of the data load and scheduled the sessions by running them sequentially and in parallel for optimization
• Involved in writing test cases Unit Testing, Integration Testing, UAT Testing.
• Involved in Migrating the code to the production environment and also supported the application for stability
• Tuned the ETL processes for better performance by identifying the bottlenecks at the source, target, mapping and session levels and eliminated them by implementing best solutions
• Analyzed and solved the bugs/defects opened by the testers and end users and documented them for future assistance
• Worked on the defect handling system (Mercury Quality Center 9.0) to handle the defects and maintain the history
• Currently working on the production Support and also preparing the Knowledge Transfer document which provides necessary information requires supporting the application.

Environment: Informatica Power Center 8.1/6.1, Sybase/Oracle 10g, MYSQL 4.0, UNIX, Windows XP Professional, MS Excel, MS Access, SQL Developer, Mercury Quality Center 9.0, Reflection, FACETS 4.31

Confidential, WestPoint, PA

Data Warehouse/ Sr Informatica Consultant

Responsibilities:

• Actively involved in gathering requirements and acquiring application knowledge from Business Managers & Application Owners.
• Prepared the High level Design document to provide an overview of the technical design specification system required for Application Enhancements.
• Involved in designing the process flow for extracting the data across various systems interacting.
• Developed ETL routines using Informatica Power Center and created mappings involving transformations like Lookup, Aggregator, Ranking, Expressions, Mapplets, connected and unconnected stored procedures, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers.
• Worked on Business objects tool to maintain the Users, Reports and building the adoc reports
• Used workflow manager for session management, database connection management and scheduled the jobs to run in the batch process.
• Troubleshoot the issues by checking sessions and workflow logs.
• Involved in analyzing the bugs, performance of PL/SQL Queries and provided solutions to improve the same.
• Worked with pre and post sessions, and extracted data from Transaction System into Staging Area.
• Created stored procedures for loading of data into ODS using Informatica on weekly and monthly basis.
• Written and used UNIX shell scripts extensively for scheduling and pre/post session management
• Involved in the performance tuning process by identifying and optimizing source, target, and mapping and session bottlenecks.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Provided data loading, monitoring, system support and general trouble shooting necessary for all the workflows involved in the application during its production support phase.

Environment: Informatica Power Center 7.1.4, Business objects 5.1, Oracle 9i, DB2, UNIX, Windows XP Professional, UltraEdit-32, MS Visio 2002, MS Excel, MS Access, SQL Navigator, Clear Quest, Clear Case, and Mercury

Confidential

Software Engineer

Responsibilities:

• The user Interface items such as JButton, JPanel, JTable, JCombo, JList JTabbedPanel, and JPopupMenu were developed using the SWING components.
• Responsible for design and development the thin client for multi-tier generic application, using Java2 (swing-1.1, 2D, Drag & Drop API).
• Utilized JDBC API and PL/SQL to manipulate data on the Oracle database
• Designed and maintained the database as well as wrote Stored procedures for functionalities such as: updating, filtering, deleting, inserting, retrieving, sorting and grouping data; working with sub-queries and combining queries interacting with ORACLE Server
• Responsible for design specification (UML/Test Cases)
• Designed and developed the entire front-end implementing MVC design pattern

Environment: Java, Servlets, JDBC, JavaScript, Applets Oracle 8.0, Swing, UML.