SUMMARY

• Over 15 years of progressive experience in IT development in Software and Databases, focused on Data Analysis, Data Modeling, Data/database Architecture, Data Mining, Data profiling, Database Administration, and Data Facilitation.
• Information Modeling, Data Modeling Logical, Physical, Star schema using ER-Win, IBM RDA, ER Studio, Designer 2000, Data Analysis, database Administration, database system analysis, design, testing and implementation. Siebel Certified Consultant, experience in Siebel Data migration and Data Modeling.
• Roles seeking: Financial LBO Analyst/Associate/Data Architect/Information/Financial Modeler etc.
• Experienced in ETL projects doing Data analysis, Data cleansing/massaging/transforming, Data profiling standardization, Source to target mappings, and loading from several legacy systems into the TO-BE systems which includes both Oracle and SQL Server databases. Wrote/built Data Integration packages involving several mappings/workflows in SQL Server which is similar to Informatica mappings/workflows.
• Expert in communicating with business technical people at various different levels and multiple teams with Developers/Testers, Stake holders, PMs etc.
• Involved in Requirement gathering, JAD sessions, Interview SMEs, conduct walkthroughs.
• Experienced in ERP and CRM SAP Siebel , Oracle 10g, Oracle 9i, Oracle 8, Oracle 7, Microsoft SQL Server. Trained in TeraData
• Several years experience working on CRM projects and a Siebel 7.5 Certified Core Consultant. Some experience in OBIEE 11g
• Some experience working with SAP applications including PS, SD, MM, HR, FI, SRM, CRM, CIM, BI/BW, Portals
• Experienced with public sector GSA etc. and commercial Automotive, Finance, Insurance, Telecommunications, Communications etc. industry segments, using proven methodologies, repeatable processes and reusable work products.
• Received Intensive formal training in Siebel OBIEE, Teradata, Informatica and SAP BI/BW.

TECHNICAL SKILLS

• Domain Expertise Solutions CRM, ERP, Siebel 7 Certified Professional, Application Development, Database, Design, Data Modelling and Integration, Data Conversion, Data Migration
• COTS packages Siebel, SAP, CRM, ERP, Data Modelling ER-Win etc.
• Databases Oracle 6,7,8,9i,10g, 11g, Microsoft SQLServer, TeraData, DB2, Access, Informix
• Operating Systems Windows, UNIX Linux
• Trained in: DataWarehouse, Informatica, Business Objects, Data Stage, Cognos, Brio
• Programming Languages Tools SQL, PL/SQL, Perl, PowerBuilder, UNIX Shell Scripting, HTML, VB Script, C, JavaScript

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Analyst

Project involves modeling Financial Credit data requirements using Embarcadero ER Studio in the CDR Credit Data Repository project. Responsible for collecting data elements for MDM Master Data Management and also making sure that Meta Data information is complete in the modules worked.

Mortgage Servicer Performance Scorecard Data Analyst

This project includes multiple components that offer a well-rounded view of Mortgage servicer performance, provide a broad and in-depth analysis of servicing of performing and non-performing loans, and support ongoing discussions regarding performance strengths and challenges. The program focuses on all aspects of mortgage servicing and aligns with the overall objectives of the Servicing Alignment Initiative to improve Servicer performance through defined metrics, benchmarks, requirements, financial incentives, and compensatory fees.

• Reverse engineered the ETL too code Informatica into the BRS Business Rules Spreadsheets
• Delivered about 100 BRSs which included Fact and Dimension table business rule spreadsheets.
• Performed Data Analysis, Data Profiling Validity, Data cleansing rules etc.
• Developed mapping spreadsheets that will provide the Data Warehouse Development ETL team with source to target data mapping.
• Mentored junior members of the team members

Confidential

Mortgage Loan Origination/Servicing Data Analyst/Data Modeler

ING Bank, doing business as ING DIRECT, provides commercial banking services. The Bank offers investment and retirement accounts, mortgages, personal and business savings accounts, certificates of deposit, and home loans and online retail banking services. The project was about integration of the Confidential and enhancement of credit risk methodology to maintain Basel II standards.

• Worked with identified business users to define data requirements.
• Defined corporate metadata definitions for all Enterprise Data supported databases operational source systems, data stores and data marts .
• Performed Data Analysis, Data Profiling Validity, Data cleansing rules etc.
• Developed mapping spreadsheets that will provide the Data Warehouse Development ETL team with source to target data mapping.
• Took a leadership role when working with the Data Warehouse Development ETL team to research and define existing source to target mapping for the corporate Data Warehouse.
• Developed logical and physical data models that document source data from multiple sources Client's internal data systems, external source data systems, 3rd Party Data, Prospect Lists, etc. .
• Defined and developed designs to support departmental and functional data marts. Provided input to data modeling and physical database development standards with the Data Modeling Team. Assisted in the review of database structures of proposed business application purchases.
• Worked closely with analytical and reporting infrastructure teams to ensure operational and analytical data warehouses were able to support all business requirements for OLAP reporting across the organization.
• Assisted in the design and administration of the corporate Metadata Repository.
• Maintained Enterprise logical and physical data models, reflective of current environments.

Confidential

Data Warehouse Analyst

• Reviewed project requirements analysis document for requirements and Test scripts
• Support the design and development of a ETL strategy to perform environment and system integration validation including ETL using Informatica, Java Data Access, and web services technology.
• Conducted JAD sessions and Requirement gathering meetings with users, stakeholders, and subject matter experts to define and document Data Modeling requirements.
• Lead and Manage Metadata, Data Dictionary and Data governance efforts. Database used was Oracle 11g.
• Manage and coordinate deployment and testing effort for system integration and user acceptance testing.
• Support creation and execution of ETL and Database test cases in each environments and release in the iterative development lifecycle
• Walk through of Transformation rules document and the test cases to reflect these rules were being tested.
• Physical and Logical Data Modeling using IBM Rational Data Architect RDA case tool
• Reverse Engineered the Physical and Logical Data Model from the transactional database using Data Architect RDA case tool
• Provide project management support during testing initiative.
• Attend daily and weekly SCRUM meetings to track progress and help in issues resolution.

Confidential

Data Modeler SQL Server DBA

Project Description: IRS IDA is a Data Analytics and Data warehouse project with SQL Server 2008 as the RDBMS and two COTS packages - Autonomy and Identity Insight. Primarily this IRS IDA application would help in identifying the potential culprits related to fraud and abuse of IRS tax filings. Criminal Investigations CI Investigative Data Analytics IDA project provides both IRS and CI with the ability to better leverage IRS taxpayer, filing information and other data in support of law enforcement efforts against financial crimes. It analyzes a large volume of structured and unstructured data pertaining to leads, intelligence, financial transactions, taxpayer information and filings. IDA will enhance the search and analytical capabilities of the CI community by providing an integrated view of all available data. This will assist CI in their efforts to generate and develop leads, and will augment the gathering of evidence in support of criminal investigations. IDA uses two Commercial-Off-The-Shelf COTS products - Autonomy IDOL will support the enterprise search component and IBM Identity Insight II formerly Entity Analytic Solutions EAS will support the data consolidation component of the application. IDA uses .NET technology to construct the user interface UI .

Job Responsibilities

• Physical and Logical Data Modeling using ER-Win Data Modeler
• Database Oracle 11g Table partitioning to improve performance
• Routine Database support including Data refresh, data model, database synchronization etc.
• Responsible for Data Dictionary, Metadata definitions
• Performed Data Model walkthroughs with project stakeholders and peer review with other Data Modelers
• Support development team with resolution to Database issues
• Support Informatica Development/Developer

Confidential

Data Analyst/Modeler

Project Description: TSA Transportation Threat Assessment and Credentialing TTAC Aviation Channeling Services Project ACSP , August 2010 to October 2011, Data Modeler/Data Analyst/DBA support. The project involved enhancing the current Consolidated Screening Gateway CSG application to accommodate multiple enrollment providers and also provide update and delete capability of enrollments in the CSG system.

• Mr. Kola designed database model for System of Record SOR , Data Migration routines and functions. Provided SQL scripts as part of these modeling effort which involved end to end testing and validating the data migration rules written by the ETL developer.
• Incorporated details for additional scenarios for each of the above mentioned test cases.
• Performed GUI testing to make sure that data was being displayed in the application forms correctly and worked with the team of Java developers to fix bugs found.
• Reverse Engineered the Physical and Logical Data Model from the transactional database tool - Centralized Screening Gateway CSG database using ER-Win case, arranged the entities in logical groups and provided a physical data model to the development team and data administration team.
• Wrote SQL scripts and helped in the scrubbing of Personally Identifiable information PII for security reasons.
• Designed, developed and tested migration of documents and letters appeals, waiver request etc. into the CSG system.
• Supported the development team with database issues such as user access/privileges for SQL and PL/SQL errors etc.
• Worked briefly on the reports management system RMS , an Oracle OBIEE based Data Warehouse project to house the investigation program statistics.
• Provided assistance to OBIEE architecture and upgrade activities to OBIEE 11g.
• Attended Oracle OBIEE 11g boot camp by Oracle Corporation in Orlando, FL.
• Delivered an updated Centralized Screening Gateway CSG data dictionary.

Confidential

I developed an application in Microsoft Access and Microsoft Excel using VBA for the PMO to help them resolve Timesheet discrepancies between the Client timesheet and IBM time sheet. If the invoice did not match the hours between the two time sheets, the Client would hold payments. It typically took six man days 2 people for 3 days to manually resolve these issues once in every two weeks. The primary reason for the discrepancies was due to IBM having multiple sub charge codes for one client charge code.

Confidential

Data Modeler

• Reviewed BUCRS Use Cases FRs to understand requirements and business processes
• Collaborated in JAD design sessions with the stake holders
• Developed Conceptual, Logical Physical ER-model for the project
• Designed Siebel thick client Objects Siebel Partner Portal objects in Siebel Tools. Helped with screen mockups
• Helped with Siebel database Schema extensions
• Designed Siebel Correspondence Templates

Confidential

• Team Lead: Managed a team of five off-shore Siebel Development resources during Design and Analysis phase of the project.
• Responsible for the issues and risks management and resolution
• Responsible for Data Modeling for Conceptual, Logical and Physical models for PCR follow up and completion
• Responsible for the review of DADs Data Applet Design Documents , Operational Level Processes and business requirements.
• Responsible for managing and designing of Siebel Business Components
• Responsible for updating the PMO with Consolidated weekly Status.
• Participated in requirements gathering and design sessions with the client.

Critical DOD proposal Senior Software Data Analyst/Modeler

Position: Software PRISM Software Suite offers procurement and grant solutions for Federal Civilian, Defense and Intelligence agencies. PRISM is a web-architected, COTS solution that manages all aspects of procurement from requisitioning to closeout. A true web application with proven interoperability, PRISM simplifies the process of connecting users around the globe and sharing data between systems.

• Gathered data oriented requirements by coordinating with design, development team.
• Performed detailed Data Analysis, Data Profiling, and Data Quality checks
• Created Logical, Physical data models in Oracle 10g
• Performed Back-end testing using SQL Queries in ORACLE
• Tested the application manually by executing Test Cases
• Performed Black Box testing to check the accuracy of Data Structures
• Prepared test data for positive and negative test scenarios for functional testing as documented in the test plan.
• Used HP Quality Center

Responsibilities:

• Designed and developed a data migration strategy and a detailed design document to migrate Legacy Agent X data into Eagle One, specifically products, accounts, service requests, employees and list of values.
• Data Analyst for the Siebel team, collected requirements as to what AS-IS entity should be mapped to what entity in the Siebel Data model the To-BE system , helped with data mapping at the BC field and column level.
• Developed SQL scripts to extract data from the legacy system and populate staging tables.
• Developed Oracle stored procedures and packages to push data from staging tables to Siebel EIM tables.
• Coached, mentored and lead a small team of junior Developers
• Designed and developed Control Files to load data from external systems into Siebel EIM tables.
• Designed and developed Configuration files to run EIM processes Export, Import and Delete for various entities.
• Executed EIM jobs to migrate products, accounts, service requests, employees and list of values.
• Performed Data modeling for the tables affected using ERWIN 4.1, built logical and physical data models.
• Analyzed log files to fix data errors while migrating reference entities.
• Co-ordinated with DBA's with respect to performance tuning, building of indexes, increasing tablespace and rollback segments.
• Co-ordinated with Siebel TAM to finalize and fine tune some of the EIM processes.
• Tracked software requirements, defects and issues via the use of Mercury Quality Center
• Helped in the process of Statement of Work and contract creation to secure new and follow-on work

Confidential

SQL DBA

The state of Pennsylvania has several desperate systems to handle their case management tasks. Unisys won the contract to implement a single system to implement an EMC package FileNet P8 to consolidate all the desperate systems

• Responsible to help with the data migration effort from their fifty desperate systems into a single database of the FileNet system. The RDBMS being used for the To-Be system is SQL Server.
• Helping out in the requirements gathering BA Business Analyst and testing efforts.
• DBA activities and ETL of Data using DTS packages.
• Performed Data modeling using ER-Win. Built maintained a Logical and Physical Data Model of the entities and Tables used
• Database creation and management
• Database Backups and Recovery, and SQL Performance Tuning
• Managing database and object security
• Study and Analysis of Legacy Main Frame systems, SQL Server Databases, Access etc.
• Extensive T-SQL scripting for Data cleansing, massaging, Migration Activities
• Wrote stored procedures for Data Migration. Conversion Activities
• Used Visual Studio 2003 for data validation and exception handling
• Developed several DTS packages for data migration.
• Developed Data Migration initial plan document

SQL DBA/Data Migration/Analysis

• Studied data models of various source systems, to get a good understanding of the system and business rules.
• Prepared Entity Mapping documents between the source and destination entities.
• Built maintained a Logical and Physical Data Model , used ER-Win 3.5 case tool
• Designed a high level plan of action and time line required for the data migration effort.
• Wrote DTS packages to migrated look up tables data from source to destination tables.
• Wrote Transact SQL and Visual Basic code/scripts as part of migration tasks.
• Used DTS Data Transformation Services , a Microsoft SQL SERVER native ETL tool to extract, transform and load the data from more than thirty source databases to a single destination database.

Environment SQL Server 2000 and 2005, Windows Server 2003, Visual Studio 2003, ER Win 3.5

Responsibilities:

• Assisted in the Upgrade/Migration of Siebel 6 to Siebel 7.
• Cleaning up the Siebel Repository.
• Installed Siebel Server, Siebel database Server, Gateway Server, Siebel client, Siebel Tools etc.
• Mapping of data from legacy system to Siebel Interface tables
• Performed Data Modeling ER-Win and data mapping as the change of phases took place.
• Responsible for schema changes as per the business requirements.
• Fixed bugs in the existing system and also helped in enhancements of the system.
• Worked with Oracle DBA in fixing the Data errors occurred while running EIM
• Used EIM to perform various imports and merging of data related to Opportunities, Contacts, and Products.
• Created extension columns to accommodate the client's business requirements.
• Configured prototype with selected functionality to demonstrate to the steering committee.
• Developed specifications for each stage of business process to create / customize necessary pplets, views and screens.
• Set up development and testing environment by installing Siebel Tools and Client.
• Created new views and applets using existing business components and business objects.

Responsibilities:

• Date Mapping of the clients current system to the Siebel System.
• Maintaining and updating Entity Relationship diagram using ER-Win Case Tool.
• Built a Logical and Physical Data Model.
• Comparing the client's requirements to the functionality in Siebel application identify new and reusable object definitions.
• Designing Siebel Reports prototypes and developed the same in Actuate as per the clients requirements.

Confidential

SAP Consultant

Responsibilities:

• A division of Deloitte Touche based in Chicago, USA specializing in implementing Siebel, SAP, Peoplesoft, Oracle and Baan.
• Responsible for studying the client's Business scenarios, developing To-be processes and mapping each To-be process with a SAP process.
• Carried out SAP Configuration to meet the Business requirements and identified GAPs and prepared the Functional Specifications.
• Configured and customizes SAP applications to TO-BE specifications especially SAP HR Benefits.
• Familiar with ABAP4 programming.
• Independent project in Designing and developing Fee Filer FF , part of a big Financial System called The Collections System used to record the receipt of all money paid to the FCC. FF is being developed using PowerBuilder as the front end and Sybase SQL Anywhere as the RDBMS. FF is used by payers to pay regulatory fees. Developed stored procedures to achieve integration of business processes.
• Involved in the design and development of Inquiry Tracking Module for CILHI. This module was developed using PowerBuilder 5.0/Power Tool as the front end and Oracle 7.1 as the RDBMS. Interacted extensive with the users. The system is used to keep track of the inquiries by various requestors about the US soldiers who were killed in wars like WWI, WWII, Vietnam war,
• As a member of the team, involved in the design and development of OMS. OMS was developed using PowerBuilder 5.0/PFC's as the front end and Oracle 7.1 as the RDBMS. The system keeps track of existing groups and subscribers. It allows the users to enroll prospective subscribers and their respective members.