SUMMARY

• 9 years of experience in IT industry in Data warehousing.
• Experienced application developer with expertise in the requirements gathering, analysis, design, development, testing and implementation of Decision Support, OLAP, and web systems in Windows and UNIX environments
• TEMPHas 8+ years of experience in architecture, analysis, design, development and testing of Data Warehouse/Data mart systems.
• Successfully delivered multiple projects by involving right from the requirement gathering to Design till delivery of the product to the client.
• TEMPHas Sound noledge on OLAP tools like IBM Cognos 10.1/8. 1.1/8.1.2/8.2/8.3/8.4 , Cognos Report Net 1.0/1.1 MR2/MR3, Informatica 9.1/8.5 and IBM Cognos TM1 9.4.1, IBM Cognos Transformer 10.1/8.4/8.3
• Architected, Installed, configured and upgraded multiple reporting environments involving all versions till IBM Cognos 10.1 BI on Windows, Linux and Solaris environments.
• TEMPHas Sound noledge and experience on IBM Cognos Transformer and TEMPhas built numerous cubes to be used for analysis and reporting in Cognos BI.
• Trained by IBM Corporation on Cognos Administration and Cognos FrameWork Manager.
• TEMPHas sound noledge of various components within Cognos architecture and how they interact with each other.
• Migrated and upgraded Reports & Packages from CRN 1.1 to Cognos 10/ 8.1/8.2/8.3/8.4.
• TEMPHas sound noledge on Integrating Cognos 10 BI with third party applications like Microsoft Sharepoint, IBM Websphere portals.
• Extensively used Cognos 8 SDK for embedding Cognos 8 BI into the Customized Java application.
• TEMPHas sound noledge on various reporting tools like Tableau, Oracle Business Intelligence, and QlikView etc.
• Involved in number of Business Intelligence Migration Projects in various environments through out the Career.
• Performed End to End activities as a Cognos Administrator including third party configurations in vaious environments using Cognos SDK.
• TEMPHas hands on Experience on end to end aspects of Data Warehousing including ETL, Reporting, Budgeting and Forecasting.
• TEMPHas Strong data modeling experience and TEMPhas developed various Logical and Physical data models for multiple projects.
• Experienced and TEMPhas strong noledge on data integration techniques especially with Informatica Powercenter.
• TEMPHas Sound noledge in Oracle SQL, PL/SQL, and DB2 SQL.
• TEMPHas Strong noledge in writing and debugging Teradata Sql queries.
• Gained good noledge on .Net 3.5 by supporting a custom .NET based forecasting solution.
• Strong in designing and developing Cubes and Universes in IBM Cognos Transformer and Business Objects Designer.
• Expert in Query performance optimization and re - using queries by using Tabular references to reduce development effort.
• Experience in Integration of data sources like Oracle, SQL Server, Flat Files.
• Involved in various activities of the Software Life Cycle.
• Self-starter with drive, initiative and a positive attitude. Able to meet very stringent deadlines and always deliver results, even under pressure.
• Strong analytical & good communication Skills. Very keen and enthusiastic; constant desire to learn; genuine commitment to excel.
• TEMPHas worked in HR benefits including Insurance, consulting, Financial, Marketing, Public Sector, Energy and service domains and TEMPhas very good understanding about their operations.

TECHNICAL SKILLS

Reporting Tools: IBM Cognos 10.1, Cognos 8 BI 8.1/8.2/8.3/8.4 (Report Studio, Query Studio, Analysis Studio, Event Studio, CognosConnection, Framework Manager, Metric Studio), MS-Excel, MS-SSRSOracle Hyperion Essbase 9.3.1, IBM Cognos TM1 9.4.1, Tableau

ETL Tools: Informatica PowerCenter 9.1/8.5

Data Modeling tool: Erwin3.5.2/4.1, Embarcadero.

Platform: UNIX, AIX,Solaris,Windows 2000/2003/2008/ XP/NT.

Networking & protocols: TCP/IP, DNS, Active Directory, IIS, HTTP, POP3, and SMTP.

Languages: PL/SQL, HTML, DHTML, C, C++, Java., VBA,.NET 3.5

Database Connectivity Interfaces: ODBC, JDBC.

Databases: DB2 V 9.7, MS SQL Server 2008, Oracle 10g/9i/8i/7.x, MS-Access 2010.

Application Servers: Apache Tomcat, Oracle Weblogic 10.3/9.8

Others: AQT, SQL Loader, Toad 7.5, MS Office 2010, Winrunner, Loadrunner, Microsoft Sharepoint

PROFESSIONAL EXPERIENCE

Confidential, IL

IT BI Development Technology Lead

Responsibilities:

• Successfully Lead and coordinated a team of more TEMPthan 6 people both onsite and offshore on multiple projects using Informatica 9.1, Cognos BI 10.1 and successfully delivered them within the committed timeline.
• Worked extensively with multiple Business groups for gathering the requirements, design/development and UAT signoffs in a time based manner.
• Actively involved in architecting the entire reporting environment and installing and configuring IBM Cognos 10 on Solaris/DB2/Tomcat/Apache 2.2 Distributed environment.
• Actively involved in the creating the logical and physical data models for a data warehouse to load the new client activity data from the SFDC.
• Extensively used IBM Cognos transformer 10.1 and 8.4 for building various Financial data multi dimensional power cubes.
• Extensively used Transfomer to design and develop dimensional data models based on Cognos BI Framework Manager packages, report definitions, CSV’s, .iqd’s and flat files.
• Implemented complex security requirements into the Transformer’s data model.
• Successfully automated the Cube builing in IBM Cognos transformer 10.1 using unix scripts and Transformer command line options.
• Published transformer Powercubes as datasource and package to Cognos BI and created mutilple financial dashboards.
• Performed POC on Tableau and Qlikview reporting tools after installing and configuring them for use by Finance teams.
• Developed Various interactive Dashboards by extracting data from multiple sources and stored them into QVD files and wriiten the ETL scripts using Qlikview script builder application and developed UI based on the requirements.
• Created technical design documents explaining the data flow from Source to target for Various Informatica ETL mappings.
• Extensively used Informatica Powercenter Client 9.1 to develop various complex ETL mappings, mapplets, sessions and workflows.
• Actively participated in developing an ETL solution using the Informatica powercenter’s web service consumer transformation to fetch the data from the third party MS Sharepoint web application and loaded into the Warehouse.
• Created Complex Stored procedures, functions, views and triggers in DB2 9.7 and Sql server 2008 to solve complex data integration, reporting and forecasting requirements.
• Extensively used IBM Cognos TM1 9.5 for planning and budgeting purposes in creating cubes and chores to automatically refresh the cubes using Turbo Integrator and Perspectives clients.
• Accessed the Cubes developed through TM1 9.5 in Cognos BI 10.1 by creating IBM Cognos Powercube data source and modelled the cube metadata for Reporting purposes and published into BI using Frame work manager and created various dash board reports using Cognos Workspace advanced and Analysis studio tools.
• Created various drill through and Burst reports using Report studio.
• Worked extensively on time based manner in resolving the critical production issues through intense analysis and closely working with business users involving Cognos BI 10.1, Informatica 9.1 and .NET3.5 based applications.
• Extensively involved in the development of a VBA, MS Access based custom application for allocating the IT and Real estate costs into the general ledger.
• Acted as the Administrator of the IBM Cognos 10 reporting environment and implemented the application security using LDAP, performed migrations and created data sources pointing to relational databases and to TM1 cubes.
• Successfully configured Single sign on using Siteminder.
• Successfully integrated the IBM Cognos 10 BI application with the Microsoft sharepoint and exposed dashboards created using Cognos workspace advanced in the Sharepoint portal.
• Successfully used Control-m as the scheduling tool and integrated it with Cognos 10 BI to run the reports and burst the outputs to 5000 users based on the Control-m schedule.
• Monitored the Performance of Cognos application using performance metrics and tuning on Content Manager Database, Application Servers, WebServers.
• TEMPHas developed numerous functional and technical design documents for various Data integration and reporting projects.
• Created documentation and trained the Business users about using IBM Cognos 10 studios and IBM Cognos TM1 clients to access the cubes, reports etc..
• Successfully integrated Cognos 10.1 BI with the Microsoft Sharepoint and created various dashboard portals for different functional teams.
• Created Various metrics dashboard for client facing medical benefits management teams to monitor the number of health insurance enrollments happening during the enrollment period for a client.

Environment: Informatica Powercenter 9.1, IBM Cognos 10.1 BI Suite, DB2 v9.5, IBM Cognos TM1 9.5, Erwin 4.5, .NET 3.5, SQl server 2008, AQT, Microsoft Sharepoint, Microsoft Visio, VBA, MS Access 2010, MS Office 2010,Microsoft Windows Active Directory, Http Servers

Confidential, Houston, TX

Sr. Business Intelligence Developer/Administrator

Responsibilities:

• Involved in gathering the Business requirements and designed / architected the entire reporting environment.
• Installed and configured IBM Cognos 10 on Windows Server 2003/oracle11g/Tomcat/IIS distributed environment.
• Administered the IBM Cognos 10 environment and performed Deployments, performance tuning and other Server Administration tasks.
• Actively participated in the data modeling and development of a new data mart in star schema model using Erwin, Oracle 11g, Informatica Powercenter 8.5.
• Actively used Informatica powercenter 8.5 to populate the enrollment data mart by integrating the data from various data sources.
• Extensively used Source qualifier, Filter, expression, aggregator, and joiner and update strategy transformations in the designer to developed ETL mappings.
• Understood the complex SAS code and designed and recoded it into Oracle SQL using PL/SQL procedures and functions.
• Extensively used PL/SQL skills to translate and populate the SAS data into oracle tables.
• Developed materialized views to create aggregated data based on detail facts.
• Designed and Developed canned reports using Cognos 10 BI report studio based on the populated Oracle data.
• Extensively Used Cognos Framework Manager to create packages containing the query and model query subjects with filters and object level security.
• Extensively used Cognos 10 tranformer to develop models based on external flat files and created Powercubes to use this multidimensional data for analysis in Cognos 10 BI.
• Designed and developed datamart tables and used them in Oracle Hyperion Essbase 9.3.1 to create cubes and used in the analysis studio.
• Designed and delivered the Adhoc Package using Cognos Frame work Managers for creating adhoc reports using Query Studio and Business Insight for the business users.
• Closely worked with Business and the testing teams during all phases of testing and fixed all the issues in time.
• Created functional and technical design documents and share them with the Business and the IT teams.
• Trained the Business Users about using IBM Cognos 10 and creating adhoc reports and analysis studio reports.
• Prepared proper documentation including the minute details during all phases of the project.

Environment: Windows Server 2003 R2, Windows XP, IIS, Tomcat, Oracle 11g/10g RAC, Erwin 4.5, IBM Cognos 10 BI Suite, Informatica Powercenter 8.5, Toad, Microsoft Visio, Microsoft Windows Active Directory, Http Servers, Oracle Hyperion Essbase 9.3.1

Confidential, Santa Ana, CA

Sr. Cognos Developer

Responsibilities:

• Installed and Configured Cognos BI 8.3 and upgraded it to 8.4 on oracle10g/weblogic9.2/Sunone IPlanet Web server environment.
• Designed and implemented the application security and report security with multiple user groups and roles.
• Actively involved in the data modeling of the AOC data warehouse and created data models for reporting datamarts..
• Modelled Complex Security and Business requirements by efficiently using Cognos 8.4 Framework Manager.
• Efficiently implemented the Framework Modelling standards for implementing row, object level securities.
• Successfully built the mutli dimensional cubes using IBM Cognos Transformer 8.4 and published these cubes as package and data source to Cognos BI for analysis in Analysis studio and to create reports and dashboards.
• Actively worked on Informatica powercenter 8.5 to load the data into data warehouse and datamart using Powercenter applications such as Designer, workflow manager, workflow monitor and Repository Manager.
• Create various ETL mappings using all Transformations and developed mapplets to use in multiple mappings.
• Created ETL mappings to load Type 1 and type 2 slowly changing dimensions.
• Written the Technical Design documents for the Cognos reports and the FM model.
• Successfully developed complex crosstab and list reports containing up to 35 calculated data items and union/joined queries .
• Extensively used PL/SQL for writing Stored Procedures and used them as Data Query Stored Procedure objects in the Critical reports.
• Created Regular and Measure Dimensions dat contains Hierarchies with alternate drill paths and enabled Security on these.
• Efficiently implemented row level and object level security in the Framework Manager using Macros, Session Parameters and Parameter Maps.
• Resolved all the Data modeling challenges occurred because of the highly normalized and complex source data model using model query subjects.
• Performed Framework maintenance activities such as constantly updating the Model objects, their relationships and reports based on the source changes.
• TEMPHas developed design, build and training documentation throughout the project and shared them within the team and with the Business users.
• Created different Landing pages for different user groups and configured them successfully.
• Setup the Auditing to has all the Audit reports run successfully.
• Shared noledge with infrastructure team about monitoring the Performance of Cognos using performance metrics and tuning on Database, Application Servers, WebServers and Cognos System..
• Successfully Integrated Cognos to a customized application and enabled single sign on from this application to Cognos.
• Created customized roles in Cognos and provided capabilities and maintained the users.
• Efficiently coordinated with the ETL, Functional and testing teams during the development and testing phases and planned the code release cycles.
• Successfully delivered the components within the timelines.
• Involved in team excessively and shared noledge with the team members.
• Implemented regular backup procedures to over come Disaster Recovery events.

Environment: Solaris, Windows XP, Sunone Iplanet, Weblogic 9.2, websphere 5.x, DB2, Oracle 11g/10g RAC,, SQL Server, Erwin 4.5, Cognos Cognos 8 BI 8.3/8.4, Cognos Transformer 8.4, Toad,IBM Rational Clearcase, Humming Bird, Microsoft Visio, Microsoft Windows Active Directory, Http Servers

Confidential, TX

Cognos Administrator / Developer

Responsibilities:

• Understood the complex Business Model and requirements and implemented the reporting environment from begin to end using Cognos 8 BI and informatica.
• Upgraded CRN1.1 to CRN 8.1.1 in a distributed environment and migrated all the reports and users to 8.1.1
• Resolved various issues with the migrated reports.
• Installed and Configured Cognos 8 BI 8.3 on a Distributed Environment (Oracle 10g RAC/Tomcat/Apache 2.0 webserver) along with Composite Servers.
• Configured Microsoft Active Directory Namespace to Cognos 8 BI 8.3.
• Configured Single Sign-on using IBM TAM for Cognos ReportNet and Cognos 8 BI 8.3
• Successfully Installed and Configured Cognos 8.3 transformer.
• Developed multi dimensional data models based on Cognos BI Packages and reports and implemented Security into the data models
• Developed Multidimensional data cubes using Cognos 8.3 transformer and used them for analysis in Analysis Studio.
• Fixed the issues which occurred while upgrading the reports from CRN 8.1 to Cognos 8 BI 8.3
• Installed and Configured Cognos 8.3 SDK.
• Developed a Java application using Cognos 8.3 SDK for dynamic scheduling and posting of reports onto a common webportal.
• Configured AppWorx 5.0 to the custom built SDK application for kicking off the Jobs.
• Configured Microsoft Share Point to Cognos for Displaying Score cards and Dash boards built on Cognos to the End users.
• Successfully configured Teradata data source using ODBC connectivity and created a set of reports on Teradata database.
• Learnt and used Teradata Sql to create and Debug Pass through sql reports.
• Administered the Cognos 8.3 environment from end to end..
• Administered tasks such as Scheduling, Deployment, Dispatchers Maintenance.
• Configured Cognos 8.3 BI to a Logging database and a Data source for Auditing Purposes. Deployed the Sample Audit Package into Cognos and Developed the own Audit reports.
• Deployed Data from one Environment to Another.
• Developed Complex Reports having many calculations, child reports, HTML items etc in Report Studio.
• Used SDK for taking Back-ups, Scheduling jobs and also for Custom Provided Autantication.
• Provided the Entire Production Support from End to End in Cognos including the Applications dat were built using SDK.
• Prepared User documentation to train users and functionality of each report.
• Trained the Business users and other developers about Analysis studio, event Studio, Frame work Manager and transformer.
• Maintained the Product Licenses for Cognos Report net & Cognos Impromptu.

Environment: Linux, AIX 5.2, Windows XP, Apache 2.0, Tomcat, websphere 5.x, DB2, Oracle 10g RAC, Teradata VR2 5.0, SQL Server, Cognos Report Net 1.1 MR2/8.1.1, Cognos 8 BI 8.3, Pl/Sql developer, Humming Bird, Microsoft Visio, Microsoft Windows Active Directory, Http Servers, Appworx 5.0, Informatica 8.5, Microsoft SharePoint