Environment SAP R/3 (Ver. 4.6C), HP-UNIX, Windows NT/2000, IBM Mainframes, Baan, DB2, Oracle 9i, TOAD

Union Switch & Signal (US&S) is a global supplier of signaling, control and automation systems for mass transit, conventional and high-speed railways. They design, manufacture, and provide systems and products that signal, automate, control, and manage rail-based traffic.

Responsibilities:

• Worked on data analysis, extraction, cleansing, transformation, and create flat files for SAP migration from IBM Mainframes, Baan and other legacy systems.
• Member of Data Migration team and worked on data migration for SAP- MM, IM modules.
• Involved in transaction data analysis, work requirements estimation, planning of training and testing.
• Coordinated all data migration activities with other team members, BPOs, and BPEs
• Participate in SAP data migration brainstorming sessions with SAP functional consultants.
• Developed tables, views in staging Oracle database for data cleansing.
• Created Stored Procedures, Functions required for data extraction and loading data into corresponding tables.
• Interacting with functional consultants to understand SAP configuration and data requirements for SAP load
• Documenting Data extraction, Cleansing and Migration processes.

Confidential. Cleveland, OH. May '03 - Oct ’03

Role 10g up gradation, Functionality Transformation, Data Migration
Environment HP-UNIX, HP-9000, AIX 5L, Windows NT/2000,Oracle 9i/10g, Sql server, MS Access, TOAD VB, ASP, VB .NET, C#, XML, All Fusion Harvest CM 5.2.1

Ohio Savings Bank is highly innovative and progressive financial service organization offering Banking & mortgage services.
Worked on new functionality development, modifications, 10g up-gradation and data migration.

Responsibilities:

• Development of new projects using Oracle (9i/10g) integrating with VB / ASP / .Net / C# / XML.
• Modifying existing database objects to accommodate new business functionality changes.
• Modifying database objects for 10g up gradation.
• Wrote Oracle sql statements, stored procedures, triggers for various data operations
• Involved in creation of Materialized views, Temporary Tables, Procedures to calculate Loan commitment details with draw amounts, and participation amounts.
• Created scheduled batch jobs using Oracle PL/SQL for downloading data into temporary tables to generate the data required for some of the reports.
• Optimized the performance of the database queries and involved in de-normalization of queries.
• Developed and deployed reports for Data mart, Loans, Checking Account, Saving Account modules
• Worked on troubleshooting of different database connectivity, performance tuning.
• UNIX shell scripting for new functionality transformation. UNIX batch job processing.
• UNIX batch jobs conversion for 10g up gradation and ControlM job issues.
• Investigate fields for Database cleaning and their dependencies.
• Unix 10g regression testing issues
• Wholesale Mortgage functionality transformation.
• Identifying Data model requirements and SQL requirements for new projects.
• Development, Deployment, Migration, Post transformation and Production support issues.

Confidential, Pittsburgh, PA. Sept '00 – April ‘03

Role Sr.Developer, Database / Data warehouse development, Data Migration, Production Support Lead.
Environment HP-UNIX, HP-9000, Windows NT/2000
Oracle 9i / 8i/ 8.x, Sql server, Informix, Ingress, MS Access, Visual Basic, Pro*C, Erwin, Informatica Power Center 6.2/5.1, PVCS Version Manager, SQL Navigator.

Reese Teleservices Inc. provides clients with high quality, value-added call center solutions that include constant evaluation, monitoring and enhancement. Some of the clients are AT&T, Providian, Chase, MCI, Bank of America and Bank One etc.

Responsibilities:

• Database development using SQL, Pl/Sql, Stored Procedures, Functions, Packages and Triggers.
• Unix Shell Scripting for loading, transfer of data across multiple databases, batch jobs automation and cron jobs automation.
• Design, Develop and Maintenance of Call Center applications, and DNC (Do Not Call) applications interacting with business analysts and end users.
• Data Architecture, Integration, Data Governance, and metadata management.
• Translating user requirements into system solutions. Writing program specifications, designing physical databases
• Populate Oracle database from flat files using Sql * Loader.
• Maintenance of Development, Test and Production Databases.
• Maintaining data dictionary, setting db parameters, Space Management, On-line and off-line backups.
• Deploying roles, privileges, profiles, policies for group of users, etc.
• Implementing Performance-tuning techniques and hints at Application, Database and System levels.
• Development, modification and testing of different modules.
• Documentation, Version Control, Debugging, Code Optimization.
• Collecting and documenting business requirements, developing normalized relational data models in Erwin and designing OLTP systems for complex business processes.
• Review all proposed data models for new systems & enhancement of existing systems.
• Development of functional hierarchy, data flow, process diagrams, entity relationship diagrams.
• Designing data model for a data warehouse from complex OLTP systems that has over 300 tables using Star Schema model and other OLAP Principles.
• Application analysis, data modeling and systems integration with focus on customer data extraction, data integration, key generalization, data scrubbing, and preparation for loading into data warehouse.
• Review all proposed data models for new systems & enhancement of existing systems.
• Development of functional hierarchy, data flow, process diagrams, entity relationship diagrams for ‘Call center application’ & ‘DNC application’.
• Forward engineering logical data model to create physical model and Reverse Engineering of source data and creating mappings.
• Integrating data models for different operational data stores.
• Data scrubbing and data integration and system integration algorithms.
• Documenting data mappings between data warehouse and various source systems.
• Identify and resolve disparity between the logical enterprise model and the implemented physical database without causing performance problems or downtime to production databases.
• Designing ETL (Informatica) process flows for entire DWH application and developing data mapping spreadsheets to define transformation rules for each stage of ETL process.
• Extensively used Informatica client tools - Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformations, Informatica Repository Manager and Informatica Server Manager.
• Developed complex Informatica mappings, Mapplets and Worklets to load ODS and DataMarts to process millions of input records
• Extensively worked in the performance tuning of Informatica, Databases, Programs, ETL Procedures and Processes.
• Created and Monitored Batches and Sessions using Informatica PowerMart Server. Generating completion messages and status reports using Informatica Server manager.
• Used Informatica Workflow Manager (Informatica 6.2) to create, Schedule, execute and Monitor Sessions, Worklets and Workflows.
• Designing and implementing Security Policies.
• Lead a team for 24 *7 Production support

Confidential, U.K Jan’98 - Jun ‘00

Projects Inventory Control, Sales, Customer Support
Software UNIX, Oracle 7.x / 8.0, Designer 2000, Erwin, Developer 2000
Role Data modeling, Database development

Responsibilities:

• Database design, Data collection / analysis, ER / Logical / Physical modeling, Normalization
• Database development using SQL, Pl/Sql, Stored Procedures, Functions, Packages, Triggers, Unix Shell Scripting.

Confidential May ’96 - Dec ‘97

Projects Financial Accounting, Customer Order Processing, Export & Import Management, Payroll & HRMS
Software UNIX, Oracle 7.x
Role Business Analysis, Functional Analysis, Development

Responsibilities:

• Business Analysis, Data Analysis, System Analysis
• Development using SQL, Pl/Sql, Stored Procedures, Functions, Packages and Triggers.