SUMMARY:

• Eighteen 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, Confidential
• 12yrs of experience working on MDM/DataGoverance/Data Security
• 18yrs of experience working as Database/Data warehouse Architect
• 18yrs of experience working on Data Analysis, Data Profiling and Data Governance/Data Security
• 18yrs of experience working on Informatica, Business Objects, Cognos, Essbase, Hyperion
• 18yrs of experience working on Oracle, Sybase, DB2, SQLServer, Teradata, Pl/Sql, Stored Procedures

SKILLS/TOOLS:

Applications: EPIC, Confidential, 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 Warehousing

• Redesigned the Data Architecture to support Big Data and new Change Data Capture Process.
• Implemented several new techniques to improve overall ETL performance.
• Designed customized processes to support various business requirements.
• Created Data Governance Framework, that met the data Objectives of the Organization.
• Worked closely with the business users to build Cognos models and delivered based on the sign-off.
• Performed Master Data additions, changes, and deletions in accordance with established procedures and business rules and responded to Master Data information requests.
• Worked on Informatica MDM HUB for Match Merge Processes.
• Implemented Data Governance and Data security by developing data dictionary & implementing change control framework to establish common data usage. Framework ensures taxonomy standards, enterprise data Validation and clear accountability for meta data in data owner community.
• Create, amend, suspend, or de-activate client accounts in order to supportGovernance as a result of the KYCS (Know Your Client Sustainability) review.
• Worked on Level2&3 support for W applications and provided 24/7 Support, which involves responsibilities of resolving abended jobs/processes under predefined SLA’s

Environment: PeopleSoft, Oracle, Cognos, SQLServer,PL/SQL,SQL*Loader,Microstrategy,Windows,Korn Shell,Toad,Erwin,MicrosoftAccess,AS400,TSQL,Siebel,Informatica,CrystaReports,Teradata

Confidential - Confidential - Confidential

Data Warehousing

• 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.
• Done Data Governance and Monitoring in accordance to the application/environment standards and methodology.
• Provided Strategic Planning and Process Re-engineering efforts forGovernance improvement, performance management, and the development of operational KPIs as well as operational and tactical dashboards
• 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.
• Done Statistical Data Modeling and worked with statistical programming languages for Data analysis and data mining.
• Involved in troubleshooting Microstrategy Prompt, filter, template, consolidation and custom group objects in Data Warehouse.
• 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

Confidential

Data Warehousing

• 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 Confidential t 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 Confidential ts 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 Confidential ts referred by a particular Referring MD by location and the charges associated with the Confidential ts.

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 Warehousing

• 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 Confidential 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 Warehousing

• 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 Report net and Business Objects.
• Worked extensively with Framework Manager, 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

• Interacted with various teams and Business Analysts to understand the other applications which are feeding the Data Warehouse
• Gathered requirements for ongoing building of Data Mart.
• Trained and assisted end users on reports.
• Done technical support for existing Data warehouse.
• 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

Confidential

Data Warehousing

• 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, Teradata, 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 ( Confidential ), CHICAGO

Data Warehousing

• 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 Clear Case for version control
• Done labeling, branching and merging in Clear Case
• 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 outline 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, CHICAGO

Data Warehousing

• 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.