Summary:

• Accomplished Data Warehouse and BI professional with aproven expertise in ETL, BI and DBA.
• More than 9 years of total software experience.
• Extensive experience in building and maintaining data and reports in Retail, Healthcare,Pharmaceuticals,Financial, Manufacturing,Telecommunications and Software industry.
• Experience with SAP FI, oracle financials and HRMS, QAD EE, PeopleSoftand Seibel. Reported off the views created on oracle HRMS system.
• Proficient in all phases of Data warehousing concepts. Experience with Dimensional modeling, like Star Join Schema, Snowflake Schema, FACT, Dimension Tables and logical/Physical data modeling using ERWIN.
• Expertise in SQL, PL/SQL and Dynamic SQL for stored procedures.
• Excellent knowledge of Data Analysis Report Building
• Proficient in designing complex reports using Conditional Prompts, Filters, Cross Tab, Graphs, Chart, Dynamic Reports, Dash boards and Drill-Through Reports.
• Experience in creating scripts to refresh the cubes and automating the process using TIDAL and command Center.
• Experience in Cognos Administration like setting up Security access to clients using Access Manager, Setting up Users, Groups, Roles, Data Source Connection, Content Administration, Dispatchers and Services and Deployment of content from Development to Production Servers.
• Extensive experience in cognos security and external security like LDAP, AD and OAM.
• Extensive experience with Data warehousing and ETL concepts
• Extensive experience in performance tuning in database oracle and framework manager to enhance the report performance.
• Experience in developing SDK applications using Java for execution and extraction of reports and upgrading the reportnet 1.1 SDK applications to cognos 8 SDK applications.
• Extensive domain knowledge around Budgeting, Forecasting and Planning Business Process.
• Expert in creating cooperate level Dashboard for better visibility of overall metricsaffecting the performance. Used Cognos NOW to provide real time continuous monitoring of operational metrics and KPIs Key Performance Metrics
• Effective Team Player with excellent analytical, programming, written and verbal communication skills.
• Excellent interpersonal and technical skills with a sharp acumen for understanding and grasping of the various needs of businesses.

Technicalskills :

• Languages:C, C , Pascal, JAVA, SQL, HTML, DHTML, CSS, PHP, PERL, JavaScript, XML, XLS, NetLogo, MS Visual Basic,VB.NET, Flash, shell scripting
• Networking:Socket programming, LAN, WAN
• Platforms:Windows 9x, NT, 2000, XP , UNIX, MS-DOS, HP-UX, SOLARIS, LINUX.
• Database:mySQL, Oracle9i, Oracle 10g, Teradata, MS SQL server 2000, Access
• Applications: Microsoft cc: Word/Excel/PowerPoint , Adobe Photoshop, J2SE, J2EE, JSDK 1.4, EJB, Servlets, Hibenate, JSP Struts J2EE, portlets JSR 168, JSR 286, WSRP , Swing Java , ClearCase, ClearQuest.
• Network Management Tools:eHealth, CISCO WAN Manager, Unicenter, UAM, USD, URC.
• IDEs: Win Runner, Visual Studio 6.0, Netbeans 5.0
• ETL Tool: INFORMATICA 7.0,Oracle Warehouse Builder, Design Stream.
• ERP Solutions: Oracle apps, QAD, SAP
• Reporting and BI tools:COGNOS 10
• Planning Tools: Cognos TM1 10.2
• Scheduling Tool: TIDAL, Command Center
• Web servers: Apache, IIS 6,7

Work Experience

Confidential

Position: Sr. Cognos developer/BI Lead

Worked as BI lead in Global Financial Systems GFS , an IT organization under amazon responsible to cater Finance. Created and managed a BI platform for Finance, Gift Cards, Oracle Financial Applications and Finance Planning and Analysis FP A . FP A system is responsible to quarterly results and guidelines for amazon.com.

Environment: Oracle 10g/11g, SQL, PL/SQL, TOAD,Netezza,Informatica 9.5,T-SQL,Cognos 10 BI, Cognos 10 Planning, TM1 10.2, Cognos command center, CDM, CAF 10.2, TM1 Perspectives,SunOne LDAP, VeritasNetbackup, SCOM, OBIEE, Tableau 8.2,Motio CI, Motio PI, PRTG.

Responsibilities:

• Provided architecture, design and support for Cognos BI, EP including TM1 , OBIEE and Tableau platforms as per the best practices with active failovers .
• Performed capacity planning and deployed Cognos 10.2.1 BI and TM1 10.2 on Linux and windows distributed environment .
• Created Business Requirement Documents BRDs , Functional Requirement Documents FRDs and Technical Design documents for Cognos BI and TM1.
• Created DR documents for Cognos Local and Regional DR .
• Created Cognos models and packages using framework manager.
• Create complex reports with drill down and slice and dice functionality in Cognos using reports studio, query studio and analysis studio.
• Created Cognos BI dashboards and active reports.
• Configured CAF 10.2 by creating a TM1 application server and created reports using TM1 as data source.
• Validated report data by running SQL queries in oracle.
• Created alerts and monitored Cognos BI and TM1 URLs using PRTG.
• Used Netezza as a data source for Cognos BI reports for better performance.
• Implemented Cognos Disclosure Management CDM with SQL server to store the objects.
• Created dynamic reports and dashboards in MS word using CDM for oracle and excel data sources. Checked in the reports and dashboard to cognos connection to others to view and edit. Updated the reporting package and refreshed the reports in the word documents.
• Imported and refreshed reports in MS word through CDM for users to get dynamic up to date results.
• Created and managed the object workflow in CDM to track progress.
• Worked extensively with BI Dynamic cubes, TM1 Operations console, TM1 Web, TM1 applications server, TM1 Perspectives, command center and CDM
• Created TI processes and chores in TM1.
• Created reports and dashboards in Tableau desktop and published them to the server.
• Lead a team of 3 developers to create ETLs for new geographies: Europe and Japan.
• Arranged meetings with the stake holders to understand their requirements and created a project plan with milestones.
• Created ETLs using informatica to load data from source Oracle Financial R12 OFA into the financial data warehouse.
• Created ETLs based on POS business systems logic.
• Created a POC for POS system using Hadoop MapReduce.
• Designed metadata models for reports.
• Developed dashboards representing forecasted numbers vs the actuals.
• Troubleshot the day to day challenges involved with the software performance and environment anomalies.
• Worked with FP A to build Cognos packages and canned reports.
• Created capex and opex cubes in TM1 using feeders and TI processes.
• Installed Motio CI and used for version control and prod promotion. Executed queries on CM throughMotio PI.

Confidential

Position: Sr. Data warehouse developer/Software Engineer II

Confidential is the central organization behind the various 39 BCBS organizations covering over 100 million Americans. BCBSA has a system called NRS which allows plans to request reports in order to get a better idea about the various healthcare professionals and organizations around their area. This helps them to get insurance contracts in their areas from commercial and non-commercial organizations.

Environment: Oracle 9i/10g, PL/SQL, DB2, clearcase, Cognos 8.4, Framework Manager, Power Play, Cognos 8 Planning 8.4 Analyst, 8.4 Contributor, TIDAL, websphere, informatica.

Responsibilities:

• Successfully upgraded ReportNet 1.1 to Cognos 8.4.
• Successfully fixed formatting, data and other issues related to the upgrade mostly in Report Studio, Framework Manager . This included some underlying model changes.
• Created Cognos go dashboards for business users.
• Designed the data warehouse for NRS in oracle.
• Created ETL mappings using Informatica and PL SQL to load data from ODS to the staging area of data warehouse and to the fact and dimension tables.
• Involved in the unit testing prior to giving the code to QA.

Confidential

Position: Sr. IT BI Analyst

Medtronic decided to move from CorVu to cognos 8.4. So the project involved creating the data warehouse in SQL server for cognos and creating models and packages through Framework manager where the data source is in SAP.

Environment: Oracle 9i/10g, SQL Server 2005, T-SQL, Progress, Cognos 8.4, Framework Manager, Impromptu, Power Play, Cognos 8 Planning 8.4 Analyst, 8.4 Contributor, TIDAL, SAP, QAD EE, QAD transformer, informatica.

Responsibilities:

• Successfully installed and configured cognos on Prod environment Distributed installation
• Served as cognos administrator for creating user security. Also created object, package and data level security.
• Integrated SAP with cognos for reporting.
• Worked Extensively on Data Warehouse Workbench and customized info objects, info cubes, DSOs, Data Sources, DTPs, Transformations and multiproviders
• Designed the data warehouse for cognos models. Populated the data warehouse using SAP supply chain management scripts and informatica.
• Designed and created FM models and published packages for shipments reports and Sales Datamart for finance.
• Created complex finance reports using HTML and javascript.
• Created a number of sophisticated Data Transformation Services DTS in T-SQL and VBScript in SQL Server
• Served as subject matter expert SME for reporting cognos and ETL.
• Created ETL scripts using progress 4-GL language to load the data in the datawarehouse.
• Gathered business requirements and converted them into the design specs.

Confidential

Position: Software Engineer

pharmaceutical company specializing in oncology. Their product Confidential is a blockbuster billion dollar drug.

The job position involves working with the data warehouse and BI for the sales of VECADE. The reports and cubes mainly involve sales analysis and reporting. The company moved from reportnet 1.1 to cognos 8 in jan 2008. Involved in the administration of cognos 7.3 and cognos 8.3/8.4. A major milestone was to troubleshoot and enhance the current reports, cubes and catalogs. Most of the reports were migrated from impromptu,reportnet 1.1 to cognos 8. Most of the powerplay reports were converted to analysis studio. The job required administering and supporting the application on a daily basis.

Environment: Oracle 9i, Oracle 10g, SQL server 2005, T-SQL, ReportNet 1.1 MR3, Cognos 8.4, Framework Manager, Impromptu, Power Play, Cognos 8 Planning 8.4 Analyst, Cognos 8 Planning 8.4 Contributor, TIDAL, Design Stream, MDM.

Responsibilities:

• Created calls/salescube in transformer8.4. Integrated sales and calls data in the cube.
• Created models and published packages to be used for report building.
• Upgrading reports from ReportNet 1.1 MR3 to Cognos8.4.
• Modified the existing sales reports through report studio. Created specs and SDLC documentation for them. Tested the data by querying the database and/or by the cubes.
• Used HTML and javascript to creat complex weekly sales reports.
• Converted business requirements into design artifacts.
• Recreated PowerPlay reports in Analysis Studio.
• Performed dry runs for the cognos8 qualification purpose.
• Updated the CRN 1.1 SDK to cognos8.4 SDK and scheduled the SDK to run through TIDAL.
• Published reports and cubes to the portal for the sales reps.
• Created sophisticated SQL Server 2005 complex queries T-SQL, DTS, triggers, stored procedures, functions, optimization and .NET data access components
• Created scripts to refresh the cubes to schedule them through TIDAL.
• Created users in Access Manager and assigned the corresponding access to them.
• Created security to users thorough Cognos connections.
• Installed Cognos in a single server environment.
• Created security in cubes so that the sales reps can see data only for their respective territories.
• Worked with the users to resolve their application and data related issues.
• Created incident and change control requests rfc through remedy.
• Modified the current sales cubes to include data for expanded sales force and added new date categories under the date dimension.
• Created reports by joining two queries.
• Assisted in redesigning the data warehouse and migrated the Customer Master CM to Siperian's MDM.
• Created/modified/enhanced D-Lists, D-cubes and D-Links in Cognos Planning Analyst. Used macros to automate the tasks.
• Enhanced the report performance by performing database tuning and optimization in FM framework manager.
• Determine correct calculation for forecasting year-end and monthly-end headcounts.
• Created cognos NOW real time continues monitoring the KPIs using Dashboards.
• Created and administered Cognos Planning Contributor applications.
• Created CGP Corporate Giving Program reports.
• Worked with Operational Data Store ODS to integrate data from multiple sources to facilitate operation, analysis and reporting.
• Created mappings for the incremental loads for various region of Sales.
• Developed Mappings to populate data marts using Informatica Power mart designer. This involved using the dimension tables as lookup tables for the keys in the fact tables.
• Created mapping to load the data from the error tables to the fact tables.
• Created views in the database to retrieve the required fields for the tables and filter the records as per requirements.
• Used debugger to evaluate ETL timings and optimized SQL's in mappings to run faster.
• Workflow manager to create Workflow sessions to define mapping sequence.
• Optimized mappings by using Aggregator, filter, Joiner, Expression, Lookups.
• Optimized the workflows for the better performance.
• Created Unix shell scripts to automate batch jobs through cron. Some of the jobs involved in populating or updating the dimension tables.

Confidential

Position: Engineering Co-op.

Environment: Oracle9i, PL/SQL, UNIX, HP-UX, SOLARIS, ReportNet1.1, Impromptu7.1, Powerplay7.1, PowerPlay transformer.

Confidential is a network governing application. When deployed in the system, it gathers information from the elements of the network and stores that in the database. This data can be then fetched from the database and populated in the reports Cognos . These reports give a complete picture of the network of the system. But before passing the data to Cognos it needs to be regularized, which is done through stored procedures.

Responsibilities:

• Generated customized reports in COGNOS ReportNet . This involved creating drill-thru reports, list reports, cross tab reports

• Developed eHealth Firebird, Nautilus Performance reports in Report Studio using Prompts, Filters and Calculated Fields to generate the required reports.
• Developed Ad-Hoc queries and complex reports using Query studio and Report Studio.
• Created different kinds of Query Subjects model, Sql and stored procedure , created links and defined the relationships and Cardinality.
• Design a Framework Model for ReportNet and created security levels on model.
• Automated COGNOS reports using WinRunner.
• Did scripting to automate the tasks.
• Used TOAD to confirm the accuracy of the data in the reports.
• Performed database oracle compression studies for economic utilization of space.