PROFESSIONAL SUMMARY:

• 20+ years of experience in IT. 15+ years of experience in leading and managing Datawarehouse project
• Around Seventeen Years of Experience in System Analysis, Design, Development and Administrating in the fields of Data warehousing, Database and Mainframe Technologies
• Around Fourteen years of Experience with Confidential Analytics/10/8.4 (Report Studio, Query Studio, Framework Manager, Event Studio, Powerplay Studio, Transformer, Workspace) Development and administration
• Experience in Installation, Configuration, Monitoring and Managing of Confidential 8/10/11 on Solaris/ z/Linux / Windows 2003 SP1/2008 R2 platforms
• Expertise in Migration from Reportnet to Confidential 8 and upgrades from Confidential 8 to Confidential 10, Confidential 10 to Confidential Analytics
• Experience in creating Packages and maintaining Models in Frame Work Manager using Report Net 1.1 MR2, Confidential 8, Confidential 10, Confidential 11
• Over Three and half years of Experience with Confidential Series 7 ( Confidential Impromptu 7/7.x, Confidential IWR 7/7.x, Analysis Tools such as Confidential Transformer & Power Play 7/7.x, Access Manager
• Expertise in deploying packages and reports to Production environment and handling production issues
• Thoroughly documented the steps, provided production support and Knowledge Transfer to end - users for Confidential 11, Confidential 10, Confidential 8, Report Net, Power Play and Impromptu Administration
• Lead and Managed DW and Mainframe projects
• 100% focused on achieving results and providing superior customer service. Known for soft skills such as being calm under pressure, a good listener, out of the box thinker, people manager. Accustomed to working closely with all levels of the senior management teams

SKILL SET:

Business Domain Expertise: Healthcare, Automotive, Supply Chain, Finance

Business Intelligence: Confidential 11, Confidential 10 and Confidential 8 (Framework Manager, Report Studio, Query Studio, Event Studio, Powerplay Studio, Confidential Administration), Confidential Series 7 (Impromptu Administrator, Server Administrator, Powerplay, Powerplay Transformer, Access Manager)

Programing: Java, Web Service Definition Language (WSDL), IBM Service Integration bus (SIBUS), Service Data Objects (SDO) Repository, IBM Data Power Appliance (DPA)

ETL: Informatica 8.6

ERP: SAP

Mainframe Specific: COBOL, AIX (UNIX), JCL, VSAM, DB2, IMS DB/DC, MQ series, TSO, ISPF, Xpediter, Strobe, File-Aid, Abend-Aid, Changeman, Jobtrac, CA-7

Database: Oracle, Teradata, DB2, UDB, SQL Server 2005

Operating System: Sun Solaris, UNIX, Windows 2000/2005/2008 , MVS, DOS

Tools: MS- Excel, MS Word, MS PowerPoint, MS Visio, MS-Project

PROFESSIONAL EXPERIENCE:

Confidential, MD

Senior Consultant / Senior Java Developer / Application Lead

Platform: Confidential 11, Confidential 10.2.1, Oracle 12c, DB2 10, Java, SDOREP, SIBUS, Websphere Application Server 7.0 and 8.5.5

Responsibilities:

• Migrating the environment from WAS 7.0 to WAS 8.5.5
• Working with business to gather and update the requirements
• Enhancement to system to create logging module for reporting
• Involved in Analysis, Design, Testing, Implementation, post production support for the project with Java, Confidential, DB stored procedure
• Designed and Implemented metadata models in Framework Manager
• Authored various types of reports in Report Studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts and Conditional Formatting
• Successfully designed and implemented security on different levels including object and row level security
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT process
• Performance tuning for long running reports
• Support upgrades and technical releases
• Configure, maintain and administer Confidential models, packages, reports and dashboards

Confidential, MD

Senior Confidential Consultant

Platform: Confidential 10.2.1, Oracle 11g

Responsibilities:

• Designed and Implemented metadata models in Framework Manager
• Authored various types of reports in Report Studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts and Conditional Formatting
• Successfully designed and implemented security on different levels including object and row level security
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT process
• Performance tuning for long running reports
• Support upgrades and technical releases
• Configure, maintain and administer Confidential models, packages, reports and dashboards

Confidential, MD

Senior Confidential Consultant

Platform: Confidential 10.2.1, SQL Server 2005

Responsibilities:

• Designed and Implemented dashboards
• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
• Authored various types of reports in Report Studio using functionalities like Render Variables, Conditional Blocking, Cascading Prompts and Conditional Formatting
• Successfully designed and implemented security on different levels including object and row level security
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT process
• Provided Training to different business users to develop dashboards in workspace and workspace advanced
• Performance tuning for long running reports
• Support upgrades and technical releases
• Configure, maintain and administer Confidential models, packages, reports and dashboards
• Troubleshoot issues identified by business and IT stakeholders

Confidential, MD

Senior Confidential Consultant

Platform: Sun Solaris, z/Linux, DB2 UDB, Teradata, Oracle 11g

Responsibilities:

• Install, configure, deploy and support Confidential solutions
• Support upgrades and technical releases (Involved in WAS 6 -> WAS 7 -> WAS 8.5 upgrade, Confidential 8.4.1 -> 10.1.1 -> 10.2.1 upgrade)
• Consult and interface with internal/external team members as well as IBM Confidential for service requests, maintenance and patching
• Configure, maintain and administer Confidential models, packages, reports and dashboards
• Troubleshoot issues identified by business and IT stakeholders
• LDAP migration
• Designed and Implemented metadata models in Framework Manager and Powerplay cubes in Transformer
• Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports, cubes and other objects
• Successfully designed and implemented security on different levels including object and row level security
• Performance tuning for long running reports

Confidential

Administrator

Platform: Windows 2003 Server, Windows 2008 Server, z/Linux, DB2 UDB, SQL Server 2000/2005, BI Confidential Series 7 (Impromptu Administrator, Powerplay, Powerplay Transformer, Access Manager), Confidential 8.4, Confidential 8.4.1, Confidential 10.1, TM1 9.5.2, Erwin, Java

Responsibilities:

• Improve system performance
• Setup Audit for keeping track of licenses
• Monitor report failures by setting up Audit
• Installing Confidential products on Windows Servers and users machine (client version like Imprompru Admin, Framework Manager, Powerplay transformer)
• Server maintenance on monthly basis (MS patch installed)
• Lay down processes and documenting the same for setting up access in Confidential, granting access to folder/package, cube access, publishing and setting up drill thru reports from cube, assigning capabilities to users
• Involve in SQL server migration
• Deploying packages and reports to Production environment and handling production issues
• Maintaining user access using series 7 (Windows server) and Sun one console (z/Linux)
• Migration from Confidential series 7 / CRN to Confidential 8.4.1
• Upgrade from Confidential 8.4.1 to Confidential 10.1
• Provide technical guidance to users for report / query / powerplay studio
• Helping developers for design of Framework Manager and Reports and building the same
• Work with IBM support and open PMR as and when required

Confidential

Onsite Project Lead

Platform: UNIX, UDB, BI ( Confidential Series 7 - Impromptu Administrator, Powerplay, Powerplay Transformer, Access Manager), Datawarehouse Concepts, Confidential 8.4 (Framework Manager, Report Studio, Query Studio), ETL (Informatica 8.6), SAP

Responsibilities:

• Getting information from Business and converting to specification
• Designing of Data Marts
• Create Projects and Packages using Framework Manager
• Design the models using Power play Transformer and build & testing of power play cubes
• Create list, cross tab reports using Report Studio
• Reviews of deliverables from offshore
• Work on Unix Scripts to load the data and validate against SAP
• Major highlights were
• Implementation of the “Power User” concept that enabled users to build their own reports without involving IT team while still having controls to manage the environment.
• Implementation of technical audit & controls for the end to end process published to the users via Confidential Portal

Confidential, MI

Onsite Project Leader

Platform: Mainframe(COBOL, JCL, VSAM, DB2, IMS/DB), UNIX, UDB, BI ( Confidential Series 7 - Impromptu Administrator, Server Administrator, Powerplay, Powerplay Transformer, Access Manager), Datawarehouse Concepts, Confidential 8 (Framework Manager, Report Studio)

Responsibilities:

• Designing of Data Marts
• Create catalogs and reports in Confidential Impromptu
• Design the models using Power play Transformer and build & testing of power play cubes
• Create list, cross tab reports using Impromptu for ad-hoc reporting
• Publish reports to Upfront and create users, user classes, user groups and grant permissions using Access Manager Administration
• Develop new Unix Scripts for enhancement to existing system
• Migrated Impromptu catalogs and reports, Transformer Models, IWR reports, Powerplay reports from Confidential 7.1 to Confidential 7.4
• Worked on Confidential 7 to Confidential 8 migration