SUMMARY

• IT professional with over Twenty years of experience in design and development of Information Systems, Business Intelligence and Data Warehousing systems and applications. Strong experience in Data Warehouse Design and Multidimensional Analysis.
• Extensive experience in designing and developing Business Intelligence applications using design tools like ERWIN, ETL tools like Informatica/SSIS/Cognos Data Manager/BW 3.5/BI 7, Reporting tools like Cognos Analytics/Cognos 10.x/Microstrategy/BODS
• Demonstrated ability to effectively transfer knowledge to clients, team members & business professionals and to create clear, concise documentation.
• Marked ability to set clear goals and stay focused on the task at hand until completed, keeping the task in perspective with the overall project plan or IT strategy.
• Highly motivated with excellent leadership, interpersonal, communication, organizational, mentoring, troubleshooting and analytical skills.
• Extensive experience in Cognos Analytics/10.x/8.x reporting with Data Manager, Framework Manager, Analysis Studio, Report Studio, Query Studio, Cognos Connection, Event Studio, Cognos SDK and etc.
• Extensive hands on experience Planning, Installing, Testing and Troubleshooting Cognos 10 installations both in the Unix and Windows environments.
• Expert level knowledge on Cognos 7 suite consisting of Impromptu, PowerPlay (including PowerPlay Windows, PowerPlay Enterprise Server/PowerPlay Web and Transformer), Access Manager, Upfront/IWR, Cognos Visualizer, Cognos NoticeCast, Cognos Metrics Manager, Cognos Query/Architect in both the Windows and the Unix environments. Expert security management knowledge with Access Manager.
• Extensive experience in Informatica 9x/8x with Powercenter Designer, Powercenter Workflow Manager, Powercenter Workflow Monitor and Powercenter Repository Manager
• Expert level knowledge in building complex Data Marts with L1, L2 & L3 dimensions and facts.
• Good experience in integrating data from multiple sources and platforms and merging the same to a common MDM
• Extensive experience in transport of application between different environments
• Over Sixteen years of Data Warehousing experience in Healthcare, Pharmaceutical, Finance, Insurance, Utilities and Sales Analytics verticals
• Strong ETL expertise with other analytical tools like SSIS, SAP BW/BI and IBM Data Stage/ Ascential and reporting experience with Crystal Reports, Microstrategy, IBM Maximo 6.2 etc.
• Expertise in Requirements Gathering and Analysis, Data Modeling (Star schema, Snowflake schema and etc.)
• Implemented design using ERWin. Also experiencd in Business Process analysis and Reengineering, Design and Full life cycle development using OOAD, Scrum/JIRA and etc.
• Strong SQL, PL/SQL skills and administering databases like Oracle 11i/10g/9i, SQL Server 2005/2008, Teradata 12/13/14
• Extensive Implementation experience of various applications in Client/Server & 3 - tier environments using tools like MFC/VC++/ATL and Commerce Server.

TECHNICAL SKILLS

EDW: Informatica (9.x,8.x), Cognos (Analytics, 10.2, 8.4.1, EP7, Reportnet), SSIS 2012/2008, BI7(Netweaver 2004s), SAP BW 3.5, MS - OLAP.

ERP: SAP R/3 4.7, SEM 4.0

BI Microstrategy: IBM DataStage, Cognos ReportNet 1.x, Impromptu 7.x (User and Admin Versions), IWR 7.x with IIS, Query, Ticket Server, Netscape Directory Server 3.x/4.x, Power Play Transformer 7.x, Power Play Enterprise for Web 7.x with Upfront, Access Manager 7.x, Power Prompts 7.x, Architect 7.x, Decision Stream 6.5.

RDBMS: DB2, Oracle 9i/10g/11i, SQL Server 2005/2008, Teradata 12/13/14

Programming Languages: ABAP, SQL, PL/SQL, C, C++, MFC 4.0, STL, ATL 3.0, Cobol, Fortran, 80X86 Assembly and Lisp.

S/E Methodologies: ASAP, SSAD, OOAD (Rumbaugh)

Web Technologies: HTML, XML, Java Script, VB Script, Commerce Server 2000.

Software/Tools: MS TurboAnalyst, MS Visual Modeller 2.0, Erwin 4.0, MS Visio.

Security: SunOne Directory Server, Windows Active Directory

Operating Systems: MS-DOS, SCO UNIX Open Server 5.2, Sun Solaris 8.0, Confidential - Unix, Windows XP/2000/NT/98/95, Novell Netware 3.x

PROFESSIONAL EXPERIENCE

Confidential, Saint Louis, MO

Data Architect

Responsibilities:

• I am a part of the corporate Provider Data Management team responsible for building systems to automate the identification and resolution of NQPends, Designing and implementing applications to support the CAQH UPD process, Integrating data from various sources into the Vistar Database
• Designing and Building datamarts to replace the Portico Reporter functionality, delivering data feeds to a variety of state health plans to meet various compliance requirements and also provide data feeds to various third party vendors like Optum etc.

Environment: Informatica 9.x, SSIS, Oracle 11i, SQL Server 2008/2012, Teradata 14.0, Portico PDM, Microstrategy, Cognos Analytics/10.x, Linux, Apache Tomcat, Tidal, Windows 2003/2008

Confidential, Saint Louis, MO

EDW Administrator/Architect

Responsibilities:

• I designed, administered and troubleshot a variety of Cognos 10.2 applications ranging from Cognos Transformer cubes, Dashboards, Reports and Framework Manager models.
• I also assist in the Global Production Support of a web farm consisting of Four Cube build servers, Two Dispatchers, an authentication server and a web server. A total of 1400 users are administered and supported.

Environment: Cognos 10.2 Transformer, Cognos 10.2 Framework Manager, Cognos 10.2 Report Studio, Cognos 7.3.1 Access Manager, Windows Server 2003, IBM DB2, MS SQL Server 2008.

Confidential, Chattanooga, TN

EDW Architect

Responsibilities:

• I am working on multiple reporting initiatives, the responsibilities of which include troubleshooting, testing and optimization of the existing corporate data warehouse
• Developing custom dashboards and reports for the Fossil power group and develop reconciliation reports using Cognos 8 for verifying data between the Maximo asset management system and the corporate data warehouse.
• The business process of planning, tracking and measuring the Asset/Infrastructure Improvement process was facilitated by these reports.
• The PER & CAP Corrective Actions report captured all the outstanding PER’s and reported them against the various division heads.
• The Business Planning Actions & Initiatives process tracked the Budgeting and Cost outlays by various sites and was facilitated by using the Service Desk, Action Tracking Items menu

Environment: IBM Maximo 6.8 Asset Management Suite, IBM Cognos 8.4 Framework Manager, IBM Cognos 8.4 Report Studio, IBM Cognos 8.4 Query Studio, IBM Cognos 8.4 Access Manager, Oracle 11i, IBM Websphere and JDK 1.5.

Confidential, Downers Grove, IL

Cognos Architect

Responsibilities:

• I worked on the Special Investigations Unit (SIU) and the Care Coordination Portal (CCP) reporting initiatives, both a part of the Federal Employee Program Enterprise Reporting project, the end client being the Blue Cross Blue Shield Associations (BCBSA).
• The SIU initiative consisted of a set of eight reports that investigated the various claims related to the Subscriber, the Care Provider and the Pharmacy benefits.
• The application was accessed by several users such as SIU Investigators, Pharmacy Benefit Managers, Plan executives and etc. The application provided users with an interactive interface that prompted the users based on the subject area of interest and which in turn ran an additional set of prompted reports.

Environment: Cognos 8.4 Framework Manager, Cognos 8.4 Report Studio, Cognos 8.4 Query Studio, Cognos 8.4 Access Manager, DB2, Ab-Initio, Tomcat Apache and JDK 1.5.

Confidential, Minnetonka, MN

Cognos Architect

Responsibilities:

• A JD Edwards Implementation for their Canada Deicing operations which had to be tightly integrated with the current existing US systems.
• The existing reporting application system also integrated a set of reports related to Asset Management of Confidential ’s various production, warehouse and distribution sites which was being managed using IBM Maximo. A series of 12 Impromptu reports and an Autopay handler auto scheduling process had to be customized.

Environment: Cognos Data Manager 8.2, Cognos Framework Manager 8.2, Cognos Report Studion 8.2, IBM Maximo Asset Management 7.0, Cognos Impromptu 7.4, Powerplay Transformer 7.4, Access Manager 7.4, JDE OneWorld, SQL Server 2005, Windows Server 2005, Tidal, MS-Visio and Sharepoint.

Confidential, Harrisburg, PA

Cognos Architect

Responsibilities:

• I worked on two different initiatives, Early Learning Network(ELN) for the PELICAN initiative and Workload Dashboard Management(WLD) for the eCIS initiative, the end client being the Department of Public Welfare(DPW) of the Commonwealth of Pennsylvania.
• This initiative consolidated information across all systems of the DPW, viz., Compass, Maintenance tickets, Images etc, and presented an integrated view of the lifecycle of these in terms of turnaround and efficiency. Work Items like Applications, Images, Compass Apps, Tickets, Rework Items etc were tracked and analyzed.
• This initiative incorporated the integration of the child assessment information from Pearson with the date related to the programs, children, families, providers, classrooms and teachers that is currently available in the Department of Public Welfare’s Enterprise Data Warehouse.

Environment: Cognos 8.3 Framework Manager, Cognos 8.3 Report Studio, Cognos 8.3 Query Studio, Cognos 8.3 Access Manager, Cognos 7.4 Transformer, Oracle 11i, Informatica and VSS.

Confidential, Madison, NJ

Cognos Architect

Responsibilities:

• I have designed, developed and implemented a Dimensional Model Reporting application that analyzed the sales data. Various dimensions like Customer, Product, Sales Force, Geography and etc. are analyzed for the Sales Effeciency, Potential and Performance against various classes of indexes.

Environment: Cognos 8.2 Framework Manager, Cognos 8.2 Report Studio, Cognos 8 Access Manager, Javascript, Cognos 8.3 Transformer, Cognos 8.3 Data Manager, Oracle 10g, Informatica Powercenter 8.3, SAP R/3 4.7, SAP BI 7.0

Confidential, Manhatten, NY

Cognos Consultant

Responsibilities:

• I was associated with Investment Management Support operations. Financial Analytical applications like Principia and Summit populate the Oracle database with data related to Valuables such as Generic Bonds
• Callable Bonds and Bond Options, Derivatives, Swapations, Money market record, Amortization Schedule, Cash Flows, Portfolios, Counterparty Credit history tracking and etc.
• This data in turn drives the analytical information processing which is facilitated by a custom datamart designed using Data Manager.

Environment: Principia Analytical system, TCL, Cognos 8.0 (Data Manager, Analytical Studio, Framework Manager, Report Studio, Query Studio, Cognos Connection), SQL, PL/SQL, Oracle 9i, Windows 2003, and Confidential -Unix.

Confidential, Woodcliff Lake, NJ

Cognos Consultant

Responsibilities:

• I analyzed, troubleshot, redefined and re-implemented the LSR Lead Status Reporting application. The application was analyzed for errors and discrepancies which resulted in many loopholes being uncovered and plugged successfully.
• Many modifications were simultaneously undertaken resulting in the application meeting the User requirements. Finally, the entire project was migrated to the ReportNet platform.

Environment: Cognos Impromptu 7.1, Cognos PowerPlay 7.1, Cognos Transformer 7.1, Cognos IWR/Upfront 7.1, ReportNet 1.1 MR2 (Framework Manager, Report Studio, Query Studio), Oracle 9i, SQL, PL/SQL, Windows XP/2003, Informatica PowerCenter 7.1.2, PVCS 6.6

Confidential, Wilmington, DE

Cognos Consultant/Analyst

Responsibilities:

• I worked at the MIS division of Confidential . The project pertained to Personal Lines Claims System (PLCS). I helped build, implement and maintain a data warehouse in Oracle, called PLCW that captures information off the Personal Lines Claims Transaction system.
• I have also assisted in the generation of a series of 70 reports and 8 multi-dimensional cubes as a part of the reporting team. Helped setup the Cognos environment to cater to the needs of the Claims Department.
• Created a matrix of reporting hierarchy consisting of 1500 users in Upfront. Helped create SQL edited reports, stored procedure reports, reports based off database views and regular Impromptu reports(List, Grouped List, Crosstab reports and etc.). Created a series of complex cubes and powerplay reports.

Environment: Cognos ReportNet 1.x, Cognos Impromptu 7.1 MR3, IWR/Upfront, Powerplay Transformer 7.1, Powerplay 7.1, Powerplay Enterprise Server, Access Manager, Ascential DataStage/MetaStage, Erwin 4.0, Confidential UNIX 9, PL/SQL, SQL, Oracle 9i/10g/11i, Autosys, ReportNet.

Confidential, Atlanta, GA

Cognos Developer

Responsibilities:

• I extracted data from Peoplesoft CRM application databases using Decision Stream and built Data marts for Peoplesoft CRM system by identifying the Dimensions, hierarchies, Facts and measures.
• I also Modified and Implemented the CASE module of the Peoplesoft CRM Analytics Application and built a series of Impromptu reports and Powerplay cubes to facilitate multi dimensional analysis.

Environment: Cognos Decision Stream 6.5, Cognos Impromptu 7.0, Cognos PowerPlay 7.0, Cognos Transformer, Cognos Metrics Manager, Oracle 8i, SQL, PL/SQL, SQL Server 2000, Windows NT 4.0, IWR, Peoplesoft CRM, Cognos JDEdwards e-Apps

Confidential, Redmond, Washington

BI Consultant

Responsibilities:

• I customized and developed the Business Analytics component of MS Commerce Server 2000 application that involved using Analysis Services of SQL Server 2000. Cognos Impromptu was used for generating the desktop reports while MS-OLAP served as the basis for multi dimensional analysis.

Environment: Commerce Server 2000, MS-OLAP, SQL Server 2000 Analytical Services, Cognos Impromptu 6.0, Cognos PowerPlay 6.0, Windows NT 4.0, ASP 3.0., XML, Javascript.

Confidential

Sr S/W Engineer

Responsibilities:

• I worked on building a windows based platform to interface to a PLC controller and program it for ladder logic and other automation applications.

Environment: C++/VC++/MFC, Windows 98, Nexgen PLC 4000 series

Confidential

S/W Engineer

Responsibilities:

• Analyzed, Designed and Implemented a prototype using the COM infrastructure for supporting the cash management lifecycle of a World Bank affiliate

Environment: C++/VC++/MFC, ActiveX, COM/ATL, Windows 2000, Windows 98

Confidential

IT Consultant

Responsibilities:

• Analyzed, Designed and Implemented various applications to support the Glass Fiber research center requirements for project management, knowledge management and building an automation control suite to interface to RTM machines.

Environment: C++/VC++/MFC, ActiveX, COM/ATL, Windows 2000, Windows 98