Professional Summary:

• Over 9 Years of solid experience with expertise in Analysis, Design, Development, Implementation and Testing Environments in Various Business Intelligence systems(BIS) ,BI Data ware House(DWH) and Application Development
• Worked on complete BI Life Cycle Development process(SDLC) which includes Gathering User Requirements, Installations, Administering Security , ETL, Modeling, Authoring, Maintenance, Testing and End-User Training
• Experienced in working on Media, Healthcare and Manufacturing Industries
• Experienced in Onsite/Offshore model and successfully managed Offshore team in India
• Excellent experience in using IBM Cognos BI suite tools(Including Cognos10.1.1), Informatica,

MS Visual Studio, Pentaho ETL and RDBMS and OLAP like DB2, Teradata, SQL Server, Oracle and IBM Power play Cubes

• Experienced in Analyzing the Business requirements and converting them to Functional documents and also have a good experience in preparing LOE’s for Capital projects or Interim projects
• Experienced in creating POC’s and also coordinating with Vendors like Netezza, IBM,BSP in creating POC’s and presenting them to the Higher management for optimal solutions for BI
• Good knowledge of Data warehousing Concepts like Star Schema , Snowflake schema and good knowledge of using Erwin modeling tool
• Experienced in Designing, Developing, Testing, supporting and maintaining the ETL processes using Informatica Power Center and Pentaho ETL tools
• Good working knowledge with Cognos Modeling tools Framework Manager, Metric Designer
• Expertise in Authoring professional reports using Business Insight, Active Reports in Cognos 10, Report Studio with advanced techniques and using Query Studio for Ad-hoc queries ,Analysis Studio, Metric Studio and Event Studio
• Designing, Installing ,Configuring and Administrating all IBM Cognos BI suite tools on Windows and UNIX systems over distributed environment and standalone environment,
• Excellent in writing Complex SQL’s, PL/SQL Blocks, Stored Procedures, Triggers
• Experienced in developing Applications using Java, Microsoft Tools, Oracle Forms/Reports
• Excellent Analytical, Problem Solving, Communication and Inter-personal skills to manage and interact with individuals at all levels. Able to interact effectively with other members of the Business users, Quality Assurance and other teams involved with the System Development Life cycle.

Educational Skills:

• Masters of Computer Applications

Certifications:

• IBM Certified Designer – Cognos 10 BI Reports
• IBM Certified Administrator – Cognos 10 BI
• Microsoft Certified Professional
  
  Technical Skill Set:

• BI Tools:

IBM Cognos BI Suite tools,(CRN,8,8.3,8.4,10.1.1), Cognos Impromptu 7.x/6.x, Power play 7.x/6.0, Cognos Planning TM1, Cognos Contributor, Access Manager, MS SSRS, SAP Business Objects, Microstrategy,SAS

• ETL Tools:

Informatica 7.1/8.x, Pentaho Data Integrator(3.2), MS SSIS, Abinitio

• Databases:

Oracle 8i/9i/10g, IBM DB2, MS SQL Server 2000/2005/2008,TeradataV2R13,MySQL

• GUI:

VB, VB.Net, Developer 2000, Crystal Reports.

• Web/App Servers:

IIS, Apache Tomcat

• Programming Languages:

SQL, T-SQL, PL/SQL, C, C++ ,C# and Java

• Web-Related Skills:

ASP.ASP.Net, HTML, XML.CSS, Java Script and VB script

• Operating System:

Windows 98/NT/XP/2000 Professional/2000 Server/2003 sever , MS-DOS, UNIX, LINUX, Sun Solaris

Professional Experience:

Confidential, Dec’2011 – till date Mansfield, MA Senior Cognos Lead Developer

Description:
Confidential, is $12 billion global healthcare products leader dedicated to innovation and long-term growth, Confidential, provides innovative medical solutions for better patient outcomes and delivers values through clinical leadership and excellence
Sourcing was one of business unit in Covidien in which the sourcing of the raw materials from the suppliers to manufacture the healthcare products was done
Roles and Responsibilities:

• Responsible for sourcing systems reporting from which business users will track the supplier performance and make decisions based on their performances
• Closely interacted with Business Users, Business Analyst, DBA’s , OLTP system designers in gathering requirements, Interpreting them and converting them to technical specifications
• Worked on different metrics like Spend, Net spends, Forecasting, Plan Actuals etc... in defining the supplier performances quarter to quarter and year to year
• Worked in complete BI life cycle project stating from designing the BI system, Modeling, Designing the ETL and constructing the workflows to load the data in Dataware House and reporting
• Responsible for Installation, configuration and administration of IBM Cognos 8.4/10.1.1
• Good understanding of the IBM Cognos Architecture which is useful in designing the optimum BI solution
• Provided the Architectural design for IBM Cognos 10.1.1 like identifying the number of dispatchers required, gateways, authentication security, firewall processing for external users access, content management, server configurations, load balancing the dispatchers and many more
• Upgraded all Dev./QA/Prod IBM Cognos 8.4 environments to IBM Cognos 10.1.1 with in record time of 1.5 months with all the up gradation issues resolved and a complete fresh installation on distributed environment
• Moved the User Authentication security from Series 7 to Active Directory in the process of up gradation
• Aggressive testing on all the packages and reports is done by building test case scenarios and followed them for a successful migration
• Modeled several tables in Oracle and SQL server using dimensional modeling and built star and snow flake schemas in order to get OLTP data
• Designed SSIS workflows to load the data weekly and monthly with several check points to load the clean data and also to implement Slowly Changing Dimensions
• Created event file watchers after the load to trigger a batch file to start cube loading in Cognos or report execution on the Cognos connection
• Created IBM Cognos Frame work models by importing multiple sources like relation, dimensional and even from stored procedure
• Created 4 layer models which has DB layer, Modeling layer, Business layer and presentation layer and also designed 5 layer models with dimension layer for designing star schemas which is more used when planned for DMR
• Implemented Data level, row level and package level security on the Frame Work model
• Rolled back the frame work models by generating and using the transaction history scripts
• Created many complex reports using report studio like bursting the reports to location and distribution using advanced techniques of Bursting, Using Conditional variables, conditional layouts, layout component reference objects, mast detail reports, drill through reports to same report and to different reports, drill up/ down reports using same query, unlocking objects, using java scripting
• Also supported business users with their day to day Ad-hoc requests by using SQL’s, Query studio and also proposing optimum solutions and also guiding them for self-care tracking reporting systems and also training them
• Worked on IBM Cognos 10.1.1 and created many reports using advanced techniques in 10 like Deck etc...
• Worked on Active reports in 10 and presented a POC to users and explained the benefits of Active report, Business Insight and Business Insight Advanced
• Created standard and interactive dashboards using regular report studio, Cognos portals and also Business Insight advanced and Go Dashboard 8.4
• Worked on Event studio to create event based reports and triggering them using manual created triggers
• Created several cubes using Transformed and also created reports using Analysis and power play transformer
• Created Windows batch/Power shell scripts to trigger the cube building process based on event
• Implemented cube security by creating custom views and implemented all security levels like Exclude, CLOAK, APEX etc.. in Series 7
• Implemented the cube security concept by creating data level security on the FM model through Active Directory and loaded the data along with the security in to cube to avoid the custom views

Environment: IBM Cognos 10.1.1, 8.4, 8.3 (Framework Manager, Report/Query Studio, Analysis Studio, Metric Studio, Event Studio, Power Play, Transformer), Active Directory, Access Manager ,Sun one LDAP, Composite Server, MS Visual Studio 2005/2008, Oracle10g,MS SQL Server 2005/2008/2008R2, ,Windows 2003, XP, UNIX Confidential, March’2008 – Nov’2011 El Segundo, CA Senior BI Consultant

Description:
Confidential, is a leading direct broadcast satellite service based in El Segundo, California, which transmits digital satellite television and audio to households in the United States. DirecTV US currently has 18 million subscribers and revenue of 4.71 billion
Roles and Responsibilities:

• Installed, Configured and Administrating IBM Cognos 8.3 in Distributed Environment , Upgraded from 8.3 to 8.4 and in process of upgrading to IBM Cognos 10.1
• Handling day to day Administration of Cognos which includes Security, Audit Logging, Tuning
• Gathered requirements from Business User’s and Converted them to Functional and Technical documents
• Created a Unified Design Template in IBM Cognos for Dashboard, Portal pages and Reports using Global variables, Classes, Render Variables and Layout Calculations
• Created an Enterprise BI landing page for Cognos Portal from where we can access different departmental reports and also access different Intranet sites, some other changes I have done in Cognos portal are changing the skins, inserting company logos and many more
• Implemented using Event studio for Advanced reporting like Triggering the reports based on sales fluctuations, Emailing all the reports as attachments through single email and also created and hosted Web service in IIS using ASP.net which was used in Event studio to FTP files by creating folders at the target locations
• Created multiple Interactive and Standard Dashboards using Business Insight, Active reports , DMR’s, Cubes and FM which were used by C-Level Executives and top level business users
• Performed Data Analysis, Data forecasting on Data and provided the necessary data to Advanced Business Analytics group to identify the forecasting which helped them in reducing the Churn of Customers
• Good knowledge of Integrating SAP BW with IBM Cognos
• Used Complex SQL, PL/SQL and scripting to create UMT tables, Aggregate tables and using them to create Trend reports, Pivot reports, List reports
• Worked on Framework manager to import metadata from multiple data sources and created Enterprise level packages ,Created different layers in the FM model and resolved bottle necks and published packages to Cognos connection
• Created reports with complex logic using conditional blocks, layout calculations, query calculations , conditional variables for conditional formatting
• Created advanced reports involved with crosstab spanning, cascading prompts, dynamic prompts, bursting the reports, dynamic drill through , Master-Detail reports, bookmarks, data loading through Cognos using stored procedure in Report studio and Analysis studio
• Worked onInformaticaPower Center- Source Analyzer, Data warehouse designer, Mapping Designer & Mapplet, Transformations, Work Flow Manager (Task Developer, Worklets, and Work Flow Designer) and Work Flow Monitor.
• Created mappings using the Transformations likeSource Qualifier, Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joinertransformations.

Environment: IBM Cognos 10 ,8.4, 8.3 (Framework Manager, Report/Query Studio, Analysis Studio, Metric Studio, Event Studio, Power Play, Transformer), Access Manager ,Sun one LDAP, Composite Server, Informatica 8,Pentaho ETL(3.2),Teradata, Oracle9i, IBMDB2, MySql, SAP BW,Windows 2003, XP, UNIX

Confidential, March’ 2007 – Feb’ 2008
Odessa/Dallas, TX
DWH Consultant/BI Developer
Description:
Confidential,is the provider of Health care services as well as a provider of Health related products to the consumers, pharmaceutical, medical providers and diagnostics markets. It has more than 200 Customers
They have been using IBM Cognos for Reporting and Microsoft products for their web development
Roles and Responsibilities:

• Business Requirements Gathering and helping the Business by providing them the data and reports by using Cognos and SQL
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter, XML Source Qualifier and Sequence Generator Transformations.
• Created Complex Mappings which involved slowly Changing Dimensions
• Was actively involved in creating several reports like trend reports, Crosstabs, Multidimensional reports
• Worked on Cognos 8 tools like Framework Manager, Report Studio, Analysis Studio, Query Studio and Cognos Connection.

Environment: Cognos8.3 (Framework Manager, Report/Query Studio), Informatica 7.1,Oracle9i, MS SQL Server 2005/2008, TOAD, Windows 2003 and NT Server

Confidential, Nov’ 2004 – Feb’ 2007
Dallas, USA and Hyderabad, India

• DWH/BI Developer
• Description:
• Confidential,is Medical Transcription Company based in Dallas and the work is outsourced to Hyderabad, Roles and Responsibilities:
• Managed Offshore team in India and successfully reached project target onsite
• Worked on framework manager to import metadata from multiple data sources (Oracle and SQL Server) to create Models for reports and published packages to Report Net server.
• Designed and developed complex Joins, filters, calculations, prompts and conditional variables in Packages in Framework Manager.
• Worked on creating list reports, cross-tab reports and chart reports using multiple queries in a single report and by using filters, calculations, conditional highlighting.
• Created drill through reports with different parameters and associated with the summary reports to get details.
• Developed several Transformations to load the data from flat files and multiple sources to tables
• Developed PL/SQL stored procedures for database updates and to create the necessary Indexes in the target tables.
• Created and scheduled Sessions, Jobs based on demand, run on time and run once using Workflow Manager.
• Involved in Fine-tuning SQL overrides and Look-up SQL overrides for Performance Enhancements.
• Experience in ETL design documentation, reviewing designs and mappings to ensure compliance to standards and processes.

Environment:
Cognos Report Net 1.1, Power play, Impromptu, Informatica Power Center 7.x/6.x,MS SQL Server 2000, Oracle 9i, Windows 2000, XP

Confidential, Dec’ 2003 – Oct’ 2004
Hyderabad, India

• Oracle Developer

Description:
Confidential, is Nizam Sugars Private Limited which was a government company converted to private limited
Company and the management has planned to upgrade to an ERP system from their existing application which was in FoxPro
Roles and Responsibilities:

• Involved in procuring the IT needs for the company in which I have involved from gathering the

Requirements to end user training

• Involved in designing the modules in ERP and contacting the software vendors for the software, systems procurement, installing and configuring network infrastructure
• Created several forms and reports Using Oracle Devloper2000
• Extensively involved in back end coding by writing several Stored Procedures, Triggers, Cursors ,Functions

And SQL statements for Data retrieval and Data loading into the database from the front end screens

• Transferred knowledge using a strategy document describing requirements and issues.
• Designed tables, indexes and constraints using SQL*Plus and loaded data into the database using SQL* Loader
• Created customized database with appropriate table spaces to increase the performance.
• Created SQL scripts to schedule the Backup jobs.
• Involved in testing the forms and reports developed by other users and comparing the samples by querying the databases
• Interacting with non-technical users to gather the functional requirements
• End user training for the non-technical users and explaining the functionality of the applications
• Factory visiting regularly and responsible for smooth functionality of the applications which may include testing the network infrastructure
• Involved in creating low level design and high level design documents
• Created external website and intranet sites using Java

Environment:
Developer 2000(Forms and Reports 6i), SQL* Forms, SQL * Report Writer, Oracle 8, Java, Windows, 2003, XP and FoxPro