Summary:

Fifteen years of strong experience business analysis, application design, development, customization, migration and implementation of several software applications involving EPIC,SAP, DataMart/Center, Hyperion, Informatica Power Connect, Erwin Platinum, Cognos Power Play , Cognos Impromptu , Impromptu Web Reports, Business Objects , Hyperion Essbase,Architect, Portfolio, Visualizer, Developer studio , Access Manager, Upfront ,First Logic, Cobol, Java, JSP, HTML, Informix ,V.B, IMS, SQL, SQL , PL/SQL, SQL Loader, Crystal Reports, Power Play Enterprise Server, SQL Server , IWR Server, MS Access, Sybase, DB2 and Oracle under Unix, Solaris, AIX, MVS and Windows NT environment.

• 5yrs of experience working on EPIC,SAP,Siebel,Telematics
• 10yrs of experience working on MDM
• 15yrs of experience working as Database/Data warehouse Architect
• 15yrs of experience working on Data Analysis, Data Profiling and Data Governance
• 15yrs of experience working on Informatica, Business Objects, Cognos, Essbase,Hyperion
• 15yrs of experience working on Oracle, Sybase, DB2, SQLServer, Teradata, Pl/Sql, Stored Procedures

Skills/Tools:

• Applications: EPIC, Telematics, SAP R/3 3.1H
• ETL Tools: Informatica, SQL Loader, Export/Import, Oracle Warehouse Builder 2.1. Informatica Power Mart/Center, Informatica Power Connect, Informatica Power Bridge, Ab INITIO, Hyperion Essbase 6.5/5.x.
• Data Modeling: Erwin, Designer
• OLAP: BusinessObjectsDesigner, HyperionEssbase, Cognos Transformer, Brio, Hyperion, Microstrategy
• Reporting/DSS: Cognos, Business Objects, Hyperion, Microstrategy
• Analysis: Business Miner, Power Prompts, Developer studio .First Logic
• Languages: C, C , VB, JAVA, Trans-SQL, Sql Plus, PL/SQL, SQL Loader
• RDBMS: Universal DB2 UDB , SQL Server, DB2, Sybase, Oracle
• Scripts: Shell Scripts, Perl Scripts, VB Script
• Scheduling: Autosys, Jils
• Internet Technologies: HTML, DHTML, ASP, Cold Fusion, XML, Script, JavaScript, Applets, JAVA, JDBC, Servlets, JSP, Rational Rose
• Operating Systems: UNIX, Solaris, AIX, MVS, Windows

Experience

Confidential

Data Architect

• Responsible for Cognos Architecture, Project Management and Deployment of changes to Production after Unit, System, Integration and UAT Testing.
• Worked with MDM team to achieve the MDM Vision by defining the tasks, specific Master data attributes and authoritative systems.
• Integrated and implemented MDM, Business Intelligence and Data Warehousing Solutions.
• Used Erwin for logical and physical design of the Star Schema.
• Designed Custom Reporting Solution in Hyperion so that the Back Office Team could specifically analyze and validate particular dataset of interest.
• Created Process Flow Diagrams, Data Flow Diagrams and Step by Step User Manual Documents for BackOffice Business Process Team.
• Extracted data from various source systems like Azero, Verizon into DSS System for Data Analysis and Integration.
• Created Informatica ETL processes to lookup the master data like the most recent VIN Transaction and load the detail Tables such as Retail Vin.
• Worked with various Subscription data like Entune, Enform, Safety Connect and Connected Services to find overlap and gaps between Subscriptions.
• Designed Reports that validates the correct Wholesale record for a particular VIN and every retail VIN record has a valid Wholesale Record.
• Designed Verizon Summary and Aggregate Tables to match the invoice from the Vendor and created Cognos Dashboard Reports to track the variance in charges and Usage.
• Created a process that would track the order of the Subscriptions of an account and load the transactions into a custom Table.
• Involved in troubleshooting Microstrategy Prompt, filter, template, consolidation and custom group objects in DataWarehouse.
• Created several Stored Procedures, Custom Tables, and Parameter Tables for migration several business processes such as F A process from Microsoft Access to Decision Support System in Hyperion.
• Created a process to reconcile the Recycle and Reject VIN data .Reconciliation process identifies the reason for the VIN to be in Recycle or Reject group.

Environment:

PeopleSoft, Oracle, Cognos, SQLServer,PL/SQL,SQL Loader,Microstrategy,Windows,Korn Shell, Toad, Power Designer, Microsoft Access, AS400, TSQL, Business Objects, Siebel, Informatica, Crystal Reports,Tivoli,J2EE,JAVA,Teradata,Vertica

Confidential

Data Architect

• Visited several hospitals and interacted with business and technical people to gather requirements
• Developed Process Flow Diagrams, which shows relationship between Business Process and Data.
• Identified Business Priorities on MDM Subject Areas.
• Used ER-Diagrams and Documentation to gather requirements completely.
• Worked with several Payer Companies to resolve and balance payments.
• Interacted with various teams and Business Analysts to understand the other applications which are feeding the Data Warehouse.
• Worked with Microstrategy Intelligence Server, Microstrategy Web and Microstrategy Administrator.
• Worked extensively with clinical data to extract and transform to data warehouse.
• Worked extensively with Siebel architecture and data model.
• Worked with Siebel Data Model and Extracted data from Siebel Source System and integrated to the Enterprise Data Warehouse
• Held meetings with end user and Business Analysts on regular basis.
• Done Logical and Physical Design of the Data Warehouse using Erwin
• Designed, coded, tested and implemented Medicaid Fee Schedule Process for NYU and Beth Israel Cancer Centers that would capture the true cost of the drugs after applying discounts and rebates.
• Created PL/SQL Stored Procedures using Cursor Data Structures for building the ETL process.
• Wrote several PL/SQL stored procedures to satisfy the business requirements.
• Designed and built Informatica Mappings for Extract Transform and Load Process
• Worked with Hospitals and users of various Healthcare Application Products for installation, implementation, testing and resolved any issues they encounter while using the products.
• Created Reports that would keep track of the Inventory of Drugs that is available in the Hospital after Purchase and Usage of Drugs. These reports are used by the hospitals to make sure that they are following the 340b program rules of that state.
• Created an application that would track the reimburse rates for patient charges for various Insurance such as Bluecross, Aetna, Cigna, Medicaid, Medicare at the unit and account level.
• Created a Data feed for EPIC project that would provide Charges, Encounters at the Unit level
• Created a Cube that would provide the outcome of various treatments for patients and there by capture the trend analysis for each type of treatment and drugs.
• Analyzed the data and created complex reports that would provide, the patients referred by a particular Referring MD by location and the charges associated with the patients.

Environment:

EPIC, SAP, Oracle 9i/10g, Cognos Series 7 - Cognos Impromptu, SQL Server2008, PL/SQL, SQL Loader,Powerdesigner,Windows2000/XP,KornShell,S,SiemensInvision,Microstrategy,AS400,SiemensDSS,Oracle,Healthcare Query,TSQL ,Business Objects,Access,Informatica, Crystal Reports, Microsoft Access

Confidential

Data Architect

• Done Data Modeling by gathering specifications and requirements and interacting with end users and done extensive Business analysis.
• Worked on multiple Data warehousing projects involving separation and integration of Boston Scientific and Abbott Vascular data.
• Did analysis, design, coding, testing, implementation and production support for Company Code Duplication Project.
• Wrote multiple Oracle stored procedures and PL/SQL Code to enhance and implement new ETL Processes
• Worked extensively with Oracle9i and Informatica7.1.
• Designed, coded and implemented Informatica Mappings as a part of solution implementation for NAM Reporting.
• Worked with Cognos Reportnet for OLAP Reporting.
• Worked extensively with Controlm Scheduling tool to schedule jobs and understand the process flow.
• Worked with UNIX Korn Shell Scripts for FTP and Copy files between Systems.

Environment:

Informatica Power Center 7.1/8.1.1, Oracle 9i/10g, Cognos Series 7 - Cognos Impromptu, PL/SQL, SQL Loader, Erwin3.5.5, Siebel,Vertica,Windows 2000/XP, Korn Shell, Mango DB

Confidential

Data Architect

• Designed and Developed EDW for sales, service, marketing and finance using Star Schema.
• Gathered requirements from end users and business and converted them to business rules.
• Done Process Flow Diagrams and ER diagrams using ERWIN.
• Designed the ETL process for various extracts and scheduled batch process to trigger the jobs.
• Wrote stored procedures to implement the business logic and load the data to Dimension and Fact Tables.
• Worked with Siebel Data Model and Extracted data from Siebel Source System and integrated to the Enterprise Data Warehouse.
• Done OLAP Data warehouse Reporting using Cognos Reportnet and Business Objects.
• Worked extensively with FrameManager, Query Studio and Report Studio.
• Done Cognos Report Net Configuration.
• Used Informatica and Decision stream to implement the ETL process.
• Done unit, system and parallel testing before successfully implementing in production.

Environment:

Informatica Power Center 7.1/ 6.2/5.1, Sun Solaris 2.7, Oracle10g/ 9i, SQL Server 2000, IMS, DB2, UDB, VSAM, Cognos Series 7 - Cognos Impromptu, Agent, Siebel, Architect, Intelligence Server, OWB,Tersdata,Narrowcastserver,PL/SQL, SQL Loader, Erwin3.5.5, Windows 2000/XP,Decision Stream, Vertica

Confidential

Data Integration/Architect

• Interacted with various teams and Business Analysts to understand the other applications which are feeding the Data Warehouse
• Gathered requirements for on going building of Data Mart.
• Trained and assisted end users on reports.
• Done technical support for existing Dataware House.
• Interacted with business and customers to understand their needs and provided support.
• Done Data Integration between DB2 and Oracle9i using ETL Process
• Developed various ETL process for complete end to end Data Integration.
• Used Cognos for OLAP reporting
• Used Informatica and Data stage for ETL Process.
• Developed Shell Scripts for automation of various processes.
• Done System, Integration and Parallel Testing for various ETL Processes

Environment:

Informatica Power Center 7.1/ 6.2/5.1, Sun Solaris 2.7, oracle 9i, SQL Server 2000, IMS, DB2, UDB, VSAM, Cognos Series 7 - Cognos Impromptu, Agent, Architect, Intelligence Server, OWB,Tersdata,Narrowcast server, PL/SQL, SQL Loader, Erwin3.5.5, Windows 2000/XP,Data Stage, Vertica

ORACLE CONSULTING

Confidential

Data Warehousing/Data Architect

• Done Data Modeling by gathering user requirements and specifications.
• Interacted with the end users and Business to take the new requirements for existing Data warehouse.
• Gathered Business Requirements and converted those requirements in to a model.
• Developed Process Flow Diagrams, which shows relationship between Business Process and Data.
• Used ER-Diagrams and Documentation to gather requirements completely.
• Interacted with various teams and Business Analysts to understand the other applications which are feeding the Data Warehouse.
• Held meetings with end user and Business Analysts on regular basis.
• Done Logical and Physical Design of the Data Warehouse using Erwin 3.5.2
• Designed Star schema to implement Data warehouse.
• Made the suggestions for the end client to select the software and tools needed to implement the Data Warehouse
• Interacted and worked with vendors like Informatica to get the specifications needed and installation of the tool
• Upgraded Informatica tool to the current version.
• Used CognosReportnet for OLAP Reporting.
• Interacted with end users and gathered requirements for Impromptu Reports.
• Wrote functional and technical specifications for Impromptu Reports.
• Helped end users solved their technical issues for generating reports.
• Worked on Informatica Power Center 6.2/7.1 tools Sources Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations
• Identified business rules for data migration, parsing high-level design spec to simple ETL coding and mapping standards.
• Used data base objects like Materialized view, Sequence generators, Parallel Partitioning and Stored Procedures for accomplishing the Complex logical situations and Memory Management.

Environment:

Informatica Power Center 7.1/ 6.2/5.1, Sun Solaris 2.7, oracle 9i, SQL Server 2000, IMS, DB2, UDB, VSAM, Micro strategy 6.0 Administrator, Agent, Architect, Intelligence Server, OWB,Tersdata,Narrowcast server, PL/SQL, SQL Loader, Erwin3.5.5, Windows 2000/XP, Cognos Series 7 - Cognos Impromptu, Impromptu Web Reports, Power Play, Power Play transformer, Power Play Enterprise Server PPES , Upfront,Reportnet Architect, Power Prompts, Cognos Query, scheduler, Access Manager, Oracle 9i.

Confidential

Data Warehousing/Data Architect

• Done Data Modeling by gathering user requirements and specifications.
• Visited several hospitals and interacted with business and technical people to gather requirements.
• Developed Process Flow Diagrams, which shows relationship between Business Process and Data.
• Done meetings with the end users and business on daily basis and gathered requirements.
• Made the suggestions for the end client to select the software and tools needed to implement the Data Warehouse
• Interacted with various teams and Business Analysts to understand the other applications which are feeding the Data Warehouse
• Interacted and worked with vendors like Informatica to get the specifications needed and installation of the tool
• Used Oracle warehouse builder for ETL process
• Done logical and physical design of the warehouse using Erwin 3.5.2
• Developed a hybrid model of Star and Snow Flake schema that satisfied all the user requirements.
• Done ETL process with DTS and Informatica
• Helped end users solved their technical issues for generating reports
• Worked extensively with Informatica Power Center, Informatica Power Connect, Informatica Power Analyzer
• Done OLAP reporting using Informatica Power Analyzer
• Worked extensively with Business Objects for OLAP reporting.
• Worked with Microsoft Analysis Services for OLAP cube generation
• Done database builds for Centricity7.7 application in SQL Server 2000
• Done data migration from ellipse application to SQL Server 2000
• Managed AUTOSYS scheduling in Distributed Systems/Environments by creating Job definition, Advanced Scheduling including complex job dependencies and conditional Job Flow.
• Done extensive VB Scripting
• Worked extensively with ClearCase for version control
• Done labeling, branching and merging in ClearCase
• Responsible for the Designing the universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Designed Cubes with Slice Dice and Drill Down operations.
• Created the reports Master/Detail, Cross tab, Chart templates and out line reports in Business objects and Web Intelligence using the universes as the main data providers and writing the complex queries including sub Queries.
• Generated the reports for the web users using the Web Intelligence 2.x Info View. Reports are created using the Web Intelligence explorer and Reporter modules

Environment:

Informatica Power mart 4.7/5.0/5.1/6.1, Informatica Power Center 1.7/5.0/5.1/6.1/6.2, Informatica Power Connect, Informatica Power Analyzer, Erwin 3.5.2, DB2, Teradata, COBOL files, Clear Case, VB Script, IMS, Flat files, Oracle 8i/9i, SQL Server 7.0/2000, Sybase, ER/Studio 3.5/4.0, SQL, PL/SQL, Transact-SQL, Autosys, ASP 2.0, Business Objects 5.1/6.1, Sun Solaris 2.6, HP-UX, Windows NT 4.0.

Confidential

Data Warehousing/Data Architect

• Done Data Modeling by gathering specifications and requirements and interacting with end users and done extensive Business analysis.
• Designed star schema
• Worked on Informatica Source Analyzer, Data warehousing designer, Mapping Designer Maples and Transformations. Involved in the development of Informatica mappings and also tuned them for better performance.
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data.
• Done OLAP reporting using Informatica Power Analyzer
• Validated Informatica mappings.
• Done unit testing on Informatica mappings.
• Managed metadata using repository
• Used most of the transformations such as the Source qualifier, Aggregators, lookups, Filters Sequence.

Environment:

Informatica Power mart 4.7/5.0/5.1/6.1,Informatica Power Center 1.7/5.0/5.1/6.1, Informatica Power Connect, Informatica Power Analyzer, Erwin3.5.2, DB2, Teradata, COBOL files, VB Script, IMS, Flat files, SQL Server 7.0/2000, SQL, PL/SQL, Transact-SQL, ASP 2.0, Sun Solaris 2.6, HP-UX, Windows NT 4.0.

Summary

Data Warehousing/Data Architect

Responsible for development, implementation and Support of various RDBMS oracle based IT projects specially related to ETL, Data warehousing, and Data marts, reporting and Various batch jobs. Tested designed applications, analyzed and determined information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities. Research and evaluate alternatives and recommend solutions for business issues. Total Responsibility for all development and implementation of Database Oracle RDBMS , work that includes OLTP Database as well various reporting data marts, Data warehouse, ETL, providing data feed to various groups.