SUMMARY

• 8+ years of IT experience in Software Analysis, Design, Development, Implementation of business applications for Pharmaceutical, Financial, Insurance and Telecom verticals.
• 6+ years of Dimensional Data Modeling experience in Data modeling, using Sybase Power Designer 12, (ERwin 4.0/3.5.5/3.5.2 ) Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Physical & logical data modeling and Oracle Designer
• 5 years of strong Data Analysis, Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• 5 years of ETL and data integration experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 8.1/7.1/7.0/6.1/5.2/5.1/1.7 Power Mart 6.2/6.1/5.2/5.1/4.7 using Designer, Repository Manager, Repository Server, Workflow Manager & Workflow Monitor, PowerConnect, Autosys, Control M, Maestro, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader.
• 4 years of experience in Business Intelligence tools like Business Objects 6.5/6.0/5.1, Web Intelligence 2.5, Business Objects Designer, Business Objects Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Business Object Universe Developer, Business Objects Set Analyzer 2.0, Business Objects Reporting,
• 7 years experience using Oracle 9i/8i/7.x, Loader utilities including SQL Loader and Teradata, MS SQL Server 2000/7.0/6.5 , Sybase SQL Server 12.0/11.x, Teradata V2R5/V2R4, DB2 8.0/7.0, MS Access 7.0/2000, IMS Data, SQR 3.0, SQL, PL/SQL, Sun Solaris 2.x, HP - UX, AIX, SCO-UNIX, Sun-Ultra, Sun-Sparc.
• Expertise at Enterprise Database Integration and Management among MS SQL Server, Oracle, Sybase, MS Access, Teradata and DB2

TECHNICAL SKILLS

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Sybase Power Designer 12, Erwin 4.5/4.0/3.5.2/3. x, Oracle Designer

Data Warehousing: Informatica Power Center 8.0/7.1/7.0/6.2/6.1/5.2/5.1/1.7 , Informatica Power Mart 6.2/6.1/5.2/5.1/4.7 , Informatica Power Analyzer, Power Connect, Data Profiling, Data cleansing, OLAP, ROLAP, MOLAP, Autosys, Control M, Maestro, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader

Teradata: Teradata V2R6/V2R5/V2R4.1/V2R3, data load/unload utilities like BTEQ, FastLoad, MultiLoad, TPump, FastExport and Teradata administrative utilities like Archive/Restore, Table Rebuild, Check Table, Configuration, Reconfiguration, Filer, DIP., ), OLAP, OLTP, ETL, BI, Sync sort for UNIX/Mainframes, NCR 4300/5200

Databases: Oracle 10g/9i/8i/8.0/7.0, DB2 8.0/7.0, IMS Data, Sybase SQL Server 12.0/11.x, MS SQL 7.0, SQL Server 2000, MS Access 7.0/97/2000BI & Reporting Tools Cognos Series 7.0/6.0, Business Objects XI 6.5/6.0/5.1/5.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0), Data Reports, SAS, Developer 2000, MS Access Reports

GUI: Visual Basic 5.0/6.0, Oracle Forms 6.0, Oracle Reports 6.0, VC++, MS Excel-VBA Macros, MS Word (VBA) Macros, FrontPage 97/98/2000, Visio

Programming: SQL, PL/SQL, ANSI SQL, Transact SQL, SQL*Plus 3.3/8.0, Visual Basic 6.0/5.0, HTML, DHTML, C, C++, UNIX Shell Scripting

Environment: HPUX11/10/9, IBMAIX 4.0/3.1,AS/400, SunSolaris 9/8/7/2.6/2.5, SCO-UNIX, LINUX, Windows95/98/2000/XP, WinNT4.0, MSDOS6.22

PROFESSIONAL EXPERIENCE

Confidential, MO

DATA ARCHITECT

Responsibilities:

• Actively participated in the brain storming sessions with subject matter experts to gather the requirements to build a conceptual model.
• Gathered all the requirements in an Access Database.
• Created a Conceptual Model in Sybase Power Designer 12 for with all the warehouse concepts and content.
• Developed Conceptual model independently of any target database platform, Data extraction, Reporting, or Data summarization considerations.
• Mapped all the Requirements from Source to Target Entity Model in Access Database.
• Defined Relationships in Access to organize the data and pull out accordingly.
• Generated Reports and created new Queries to pull the data that is needed as per the Clients Requirements.
• Held Responsible to conduct the JAD Sessions in building out Logical Model.
• Worked closely with the Team and SME’s to discuss the Action Items and Notes that were kept track in all JAD Sessions to improve the model build out.
• Extensively worked on Test Case Scenarios to make the model more flexible.
• Created Templates for Data Model Review Process and Note Taking Format.
• Subject Area starts out with a PARTY, which uniquely identifies a person or organization in which Well point has an interaction.
• Created Placeholder Entities and associated Attributes in the model to allow for Future Expansion.
• Generated Metadata for SA and made constant Updates and Changes.
• Build out the Logical Data Model by expanding the scope of the Requirements and adding new Entities, Attributes, Relationships, Data types and Keys.
• Provided the Team with Logical Lockdown Model.
• Logged all the changes in a Change Log by developing a New Template.
• Created a new Codes spreadsheet with all the codes in the model to submit to CMS (Code Management System) to help them implement as Views.
• Generated an Ownership Model by Specifying which entities are owned by which SA’s.
• Worked on Phase of Logical Physical Development of .
• In this phase was responsible in doing Quality Assurance of the model.
• Worked on Using Well point Standard Abbreviation file to abbreviate all the Attributes and Entities.
• Held responsible for the Physical Sessions with DBA’s to determine where to add Surrogate Keys and replace Business Keys.
• Worked on Demoralization, Point in time history, Key replacement and Surrogate Key Review.
• Handed over the Logical Physical Models to the DBA’s to create Physical Tables.
• Build Confirmed Staging for the SA.

Environment: ERwin 4.5/4.0/3.5.2/3. xInformatica 8, Sybase Power Designer 12, VB Scripts, Teradata V12, Access Database, Microsoft Excel, Oracle, Teradata Sql Assistant 7.2, Business Objects 6.5.

Confidential, Amsterdam, NY

Data Architect

Responsibilities:

• Gathered Requirements from the Business Users dealing with customer data.
• Hold the responsibility to conduct Brain storming sessions with Business users to gather right and Important Information.
• Analyzed the source data from legacy system.
• Created and Analyzed the Functional Specs Documents.
• Created an Entity/Class definition template for related attributes.
• Designed and created a Customer Data Model using ERWIN Data Modeling Tool.
• Worked on ERwin DESIGNER-DATABASE to develop a data model.
• Defined relationships between Several Tables.
• Created a Database for the model developed in the objects tab in the ERwin Designer.
• Extensively Worked on Mapping a Model from Conceptual View to Logical View and Physical View.
• Assigned Business Rules, Constraints and Comments for the related attributes and tables.
• Generated a Word Document with Database Presentation, Tables, Views.
• Generated and Created a SQL Script for the model.
• Provide Consultation to browser and reporting Front end developers regarding the development of supporting tables, views, indexes, triggers, stored procedures.
• Involved in Capturing Several Requirement Views that need to be captured in Solution Architecture Template.
• Used the Normalization Techniques to reduce Data redundancy and also De normalize to Improve performance.
• Performed Business Data Flow Analysis and Data Dictionary.
• Created Schema Objects like Indexes, Views and Sequences.
• Created and Maintained the Metadata Repository.
• Developed Supporting Master Codes for Model.
• Extensively worked in removing Duplicates in the Customer Data in the Legacy System.
• Gathered All the Customer data to do proper data cleansing with a Third Party Tool NETRICS.
• Worked With DBA to generate Database Table structures, indexes and design for Database Creation.
• Coordinated with the Testing Unit and helped in the process of Unit Testing, User Interface Testing and Integration Testing.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.

Environment: ERwin Data Modeling Tool 4.5, Informatica Power Center 8.0/7.1/6.2 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), NETRICS, Legacy Data, Flat Files, AS400, Business Objects 6.5, Enterprise DB.

Confidential, Philadelphia, PA

SR. DW Data Modeler

Responsibilities:

• Requirement gathering and Business Analysis.
• Getting customer requirements and designing and developing the Data Marts.
• Analyzed the Functional Specs provided by the Architect and created Technical Specs documents for all the mappings.
• Data modeling and design of for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Played a key role in designing the application which would migrate the existing data into Health Insurance warehouse effectively by using Informatica Power Center.
• Worked on Power Center Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.
• Created and managed the local repositories and permissions using Repository Manager in Oracle Database.
• Created users and groups and assigned privileges using Repository Manager.
• Created Fact Tables and Cubes (Dimensions and Measures).
• Implemented Join, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Moving mapping and sessions from development to production environment.
• Created Schema objects like Indexes, Views, and Sequences.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Tuned mappings for improving performance.
• Tuned performance of Informatica sessions for large data files by increasing block size, data cache size and, sequence buffer length.
• Automated load run on Informatica sessions through UNIX cron, PL/SQL scripts and implemented pre and post-session scripts, also automated load failures with successful notification through email.
• Written SQL Scripts and PL/SQL Scripts to extract data from Database.
• Developed Stored Procedures.
• Worked with Business Objects Supervisor for creating repository, creating and managing the universes, creating categories, creating and managing the users, giving access permissions for Business Objects Reports.
• Created various aliases and contexts for resolving loops in universes.
• Created Business Objects Queries and Reports in User Module by analyzing the users’ requirements.
• Created complex reports by linking data from multiple sources, using functionalities like Slice and Dice, Drill Down, Master Detail etc.
• Created various geographical and time dimension reports.

Environment: Erwin 4.5, Informatica Power Center 8.0/7.1/6.2 (Workflow Manager, Workflow Monitor, Worklets, Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformations), Power Exchange, Unix Shell Scripting, Oracle 10g/9i, COBOL, Flat files, PL/SQL, SQL* Loader, TOAD, Business Objects 6.5, Sun Solaris.

Confidential, PARSIPANNY, NJ

SR. DW Data Modeler

Responsibilities:

• Designed and developed end-to-end ETL process for Sales Data Mart.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Analyzed IMS Data using Xponent and Xponent Plantrak, regarding segmentation & profiling.
• Drilled out each of the data flow on a page to plan which tables to work on, and for sequencing the transformations within each data set.
• Used Informatica power center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Extracted data from source systems to a staging database and loaded in to Teradata Target Database using utilities like MultiLoad, and FastLoad.
• Imported Source/Target Tables from the respective databases and created reusable transformations (Joiner, Routers, Lookups, Rank, Filter, Expression, Aggregator) in a Mapplet and created new mappings using Designer module of Informatica.
• Modeled the data warehousing data marts in Star join schema.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Sessions to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Created Event Driven and Time Dependent Sessions
• Extensively worked on the performance tuning of the Mappings as well as the tuning of the sessions.
• Performed extensive SQL tuning and optimization on views and queries generated by reporting front-end packages and developers.
• Tuning of SQL queries for better performance.
• Working with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Created Views and Materialized Views in Teradata.
• Extensively used Autosys for scheduling jobs and implemented UNIX shell script jobs.
• Coordinated with the testers and helped in the process of integration testing.
• Exported the universes to the Repository to make resources available to the users and to generate reports for the Sales and Marketing department.
• Maintained hierarchies in the designing of the Universe for drill down capabilities.
• Generated Ad hoc reports using the Business Objects free hand SQL.

Environment: ERwin 4.0, Informatica PowerCenter 6.1/5.2, Business Objects 5.1, Autosys, PL/SQL, Sybase, Teradata V2R5/V2R4, SQL Server 2000,IMS Data, SQL*Loader, SCO-UNIX, Windows 2000.

Confidential, NYC, NY

DW Data Modeler

Responsibilities:

• Analyzed source data and gathered requirements from the business users.
• Developed approach paper according to the business rules.
• Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.
• Extracted data from source systems to a staging database and loaded in to Teradata Target Database using utilities like MultiLoad, and FastLoad.
• Developed mappings with transformations and mapplets confirming to the business rules.
• Processed session data using threads and various tasks (session, command etc.) and managed database connections and scheduled workflows.
• Performance tuning of mappings, transformations and sessions to optimize session performance.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Extensively used stored procedures and also worked with parallel processing.
• Created snapshot for the transactional tables in distributed databases and also created Triggers, Procedures and Functions for the backend Development.
• Created shared folders, local and global shortcuts to reuse metadata.
• Worked on issues with migration from development to testing.
• Used Cognos for report generation.
• Developed Logical and Physical data models that capture current state data elements and data flows using Cognos Modelling.

Environment: ERwin 4.0, Informatica Power Center 6.2/5.1, PowerConnect, Cognos 7.0, Oracle 9i, PL/SQL, Teradata V2R5/V2R4, DB2 7.0, SQL Server 2000, Unix Shell Scripting, HP-Unix, TOAD, Putty, Maestro.

Confidential, NJ

Data Modeler

Responsibilities:

• Understanding and converting the financial hierarchy for Fact and Understand business needs and implement the same into a functional Database design.
• Created data model for an Operational Data Store using ERwin.
• Analyzed and designed data extractions, transformations, and loads for the finance data mart.
• Performed all development, documentation and support for ETL (Extract, Transform, Load) routines using Informatica 5.1 for the Finance Data Mart.
• Developed several Informatica mappings, and tuned them for better performance.
• Tuned the mappings using PowerMart and Designer performance was improved using different kind of logic to provide maximum efficiency.
• Created Mapplets and reusable transformations to be re-used in the Informatica mappings.
• Designed and developed complex join, look up transformation rules (business rules) to generate consolidated data.
• Extensively worked in the performance tuning of programs, ETL procedures and processes.
• Error checking and testing of the ETL procedures and programs using Informatica session log.
• Provide all necessary logical and physical data modeling DDL (SQL Data Definition Language) code to data architecture and database administration teams as required to develop and support the financial reporting system data repository.
• Provide consultation to browser and reporting front-end developers regarding the development of supporting Oracle tables, indexes, views, triggers, packages, procedures, in-line functions, SQL queries, etc.
• Created Worklets to run several sessions sequentially and concurrently.
• Developed schedules to automate the updated processes and Informatica Sessions/Worklets.
• Generated various reports using Business Objects as per the client's requirements.
• Validated the data in the reports against the databases. Fine-tuned query performance of all the reports.

Environment: ERwin 3.5.x, MS SQL Server 2000, PL/SQL, Informatica PowerCenter 5.1, PowerMart 4.7, Informatica PowerConnect, (Repository Manger, Designer, Server Manager), Flat files, Oracle 8i, UNIX (Solaris), Windows NT, Business Objects, Autosys, MS Access 2000, Work Flow Manager, AIX, DB2, Work Flow Monitor, Shell Programming, SQL * Loader, IBM DB2 UDB, Mainframes, OS/390, JCL, Sun Solaris, Visual Basic, SQL Navigator, Excel and Unix scripting, Windows NT

Confidential

APPLICATIONS PROGRAMMER

Responsibilities:

• Designed the Oracle Database and developed scripts for creation of tables, triggers and indexes.
• Design and development of UNIX Shell scripts and PL/SQL Scripts.
• Security aspects like Authorization and Authentication have been addressed through the creation of Database triggers. Audit is done with stored procedures and triggers.
• Used Crystal Reports for generating various Statutory Reports with respect to the Tax amount deducted in the form of monthly/half-yearly/yearly Reports.
• Developed Forms using MS Access using Forms and Reports for reporting.

Environment: Oracle 7.x, PL/SQL, Crystal Reports, MS Access 97, Windows NT 4.0, Unix, Shell Scripting, Korn Shell.