SUMMARY

• Managed multiple BI life - cycle projects ranging in budget from $6-$33M.
• Excellent project leading and senior management interfacing skills.
• Managed and lead both on and off-shore teams in production support setting.
• Well versed with complete Data warehousing & BI life cycle development process
• Requirement gathering and business user coordination skills.
• Experienced in Cognos version upgrades and BI Solutions migrations.
• Business & Data analysis experience in multiple industrial domains.
• Ability to TEMPeffectively translate business needs into BI solutions.
• Understanding of Federal and State laws and compliance requirements.
• Hands on experience with Cognos solution development lifecycle.
• Efficient in complex cubes (OLAP data source) development.
• Efficient in developing reports using OLAP Multi-Dimensional cubes including drill through functionality, manual levels and categories.
• Excellent noledge and understanding in MS SQL Server, MS Access and Oracle.
• Lead & Delivered multi-terabyte data warehouse projects.
• Visionary in assuring data quality and optimum DW/BI solutions.
• Lead & Delivered large scale BI implementations in a SOA.
• Administered teh Cognos server & Lead a team of Developers.
• Troubleshooting issues with teh patches and upgrades.
• Trained end users in Query Studio for Ad-hoc report development.
• Administered Data Security for Data warehouse & BI environments.
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies such as Big Data, predictive analytics and Data appliances.
• Self-starter with acnoledged team leading skills.
• Visionary in implementing scalable & optimum BI architectures.

TECHNICAL SKILLS

BI & Reporting Tools: Cognos 10/ 8 (8.2/8.3/8.4) Suite (Report Studio, Analysis Studio, Query

ETL Tools: Informatica Power Center 5.1.1/7.1.1, Power Mart 5.0/6.0IBM Data Manager, Talend Open Studio / Profiler.

MDM Tools: IBM InfoSphere MDM, Talend MDM.

Operating Systems: Windows NT, Windows 95/98/2000/XP, Windows 2000 Advanced

RDBMS: Oracle 10g/11g, MS SQL Server 2000/2005, MySQL, IBM DB2, Teradata.

Databases: Vertica, ParAccel, NoSQL (MongoDB).

Languages: Java, C, C++, SQL, PL/SQL, PHP.

Graphic Designing: Photoshop CS, Flash MX, Corel Draw, Fireworks.

Web-based languages: HTML, CSS, DHTML, JavaScript, VB Script, ASP.

Development: Dreamweaver, Visual InterDev, MS Visual Studio 2003, JBuilder.

Desktop Software: MS Project, MS Office, MS Visio, ER Studio, Toad, PL/SQL Developer MS Outlook, Lotus Notes.

Authentication Sources: Active Directory, LDAP, IBM WAS and SAP BW 3.5, Access Manager.

ERP/CRM/FP: Cognos TM1, SAP, Microsoft Dynamics, JDEdwards.

Portal Sources: Cognos, IBM Websphere, SAP EP, MS Sharepoint

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

Sr Managing Consultant

Responsibilities:

• Created a three tier approach to problem resolution by creating a priority of issues and their resolution.
• Analyzed teh architecture, made recommendation, provided justification and helped in implementing and optimizing teh IT Processes.
• Designed a strategy and delivered teh BI road map to CIO & IT Board (VPs).
• Coordinated with teh business users, understood their concerns and eventually explained them teh process of issue resolution eventually.
• Highlighted teh strengths and weaknesses of teh development team and mobilized teh team to address teh issues in teh shortest possible time.
• Designed teh problem/issue/incident resolution matrix and got it approved by teh management.
• Completed teh massive 2013 Re-Organization initiative of teh bank by leading teh development team, which impacted all teh existing transactional and operation data-marts, more than 1100 reports, 32 cubes and 22 applications.
• Completed Project on Time and within budget.
• Automated teh cube build process.
• Enhanced teh existing cubes for build time and added dimensions.
• Actively contributed to teh IT policy.
• Implemented & Configured Cognos 10 in a distributed Sandbox environment.
• Configured TM1 9.5 with teh Cognos 10 for data collaboration, Utilizing multiple datasources including individual module based data (such as T&E, BW) and unification of BI administration.
• Upgraded teh existing Cognos cubes from cognos 8 to Cognos 10.
• Planned & Lead teh TM1 Cube development project for Resource Management department.
• Establish TEMPeffective collaboration among onsite and offshore teams located in different geographic locations in varying timezones.
• Involved in independent analysis of Cloud using BI and Data warehouse as a prototype.
• Presented teh Proof of Concepts in context of accommodating 18000 users through BI platform utilizing Cognos 10.
• Created prototype of Dashboards using Cognos 10 Business Insight.
• Created a POC for utilizing columnar database and created a BI Cloud.
• Laid teh foundations toward a high performing BI environment by creating a POC using 1.2TB of data to be teh stored in a columnar database (Vertica), integrated using ETL (talend) and used IBM Cognos as teh BI tool.

Environment: Cognos 10/ 8.4, Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer, TM1 9.5, Oracle 10g2, Sybase, Informatica, Java Apps, AIX 6.1, SunOne Directory server, Access manager 7.4, Citrix, Talend, Vertica and Win Server 2008.

Confidential, RI

Sr Manager/ BI Architect

Responsibilities:

• Coordinated with functional departments like Infrastructure, QA, DBAs and PMOs and discussed/recommended teh organizational policies.
• Designed teh process flow for teh project and got it approved by IT management.
• Structured teh reporting requirements and consolidated teh reporting needs against OLTP and OLAP (TM1 Cubes, MSAS) sources.
• Implemented and documented teh Cognos 8.4 environment to accommodate teh intended 470 user load and scalability of solutions.
• Understood teh heterogeneous data sources and mapped them to teh sources data marts intended in teh ETL process.
• Designed Star schemas and dimensional models for Warehouse Management system and Labor management systems for UNFI’s 12 national warehouses..
• Analyzed and mapped teh existing Excel/Access reports for development in Cognos.
• Used teh bottom-up approach of analyzing teh Dash boarding and batch reporting requirements to has teh models and cubes created to directly address teh needs.
• Created teh technical documents, documented teh process and suggestions for future development.
• Integrated security for environmental access and created executives, managerial and business specific portals.
• Managed teh creation of executive dashboard for teh executive portal by verifying teh Models, OLAP data sources, incorporating teh maximum functionality for interactivity and at last accuracy and precision in dashboard contents (QA).
• Created teh testing manuals for QA team and templates for report and cube validations.
• Verified and created teh mdls for olap cubes, using packages and CSVs.
• Completed teh implementation and analysis phases on time and within budget.

Environment: Cognos 8.4, Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer, Oracle 11g, TM1, IBM HTTP server, AIX 6.1, Active Directory, IBM P750, Manhattan Associates Supply Chain Intelligence, IBM Data Manager (ETL), IBM DB2 9, JDEdwards.

Confidential, MA

Manager BI / Cognos Lead Architect

Responsibilities:

• Interviewed teh managerial layers for both strategic and tactical requirement gatherings.
• Created teh work breakdown for teh project and got it approved by client analysts.
• Created a framework for critical reporting needs.
• Deployed and supported teh latest Cognos BI environment for reporting by leading a team of ETL and Cognos developers.
• Explored teh business specific data-marts and mapped teh needs.
• Designed Star schemas and dimensional models for all different business functions.
• Modeled dimensional data marts.
• Made 19models for OLAP cube development.
• Analyzed and consolidated teh existing Excel reports for development in Cognos.
• Used teh bottom-up approach of analyzing teh Dash boarding and batch reporting requirements to has teh models and cubes created to directly address teh needs.
• Customized teh reports in as per teh present format in excel.
• Created teh technical documents, documented teh process and suggestions for future development.
• Created executives, managerial and business specific portals.
• Managed teh creation of executive dashboard for teh executive portal by verifying teh Models, OLAP data sources, incorporating teh maximum functionality for interactivity and at last accuracy and precision in dashboard contents (QA).
• Created teh training and testing manuals.
• Delivered teh training to users as a technology transfer initiative.
• Completed teh implementation and development phases on time and within budget.

Environment: Cognos 8.3, Report Studio, Query Studio, Analysis Studio, Framework Manager, Transformer, Oracle 10g, MS SQL 2005, Windows server 2003 EE.

Confidential, FL

Cognos Analyst/ Senior Consultant

Responsibilities:

• Explored teh data available through heterogeneous sources.
• Conducted interviews with key stake holders by department level.
• Gatheird requirements and determined teh KPIs.
• Understood teh immediate and Ad-hoc needs for reporting.
• Prepared an outline with recommendations for company’s BI standards.
• Helped in bringing teh in-house Cognos resource for teh company to start working on my advised solutions.
• Created a workflow for different means of extracting teh data by working in collaboration with teh DBA and ETL personnel.
• Gave complete solution recommendations and presented a few for feedback.
• Handed over my suggestions for documenting teh process and overlooked teh work in progress.
• Suggested teh training plan for business users.

Environment: Cognos 8.2, Report Studio, Query Studio, Framework Manager, Transformer, Oracle Financial, Cognos EP, UNIX.

Confidential, IL

Cognos 8 Team Lead

Responsibilities:

• Analyzed Business System requirements and prepared teh documentation for teh Project Plan and teh Scope of teh Project.
• Installed and Configured Cognos Series 8 Products, Framework Manager, Cognos connection portal, Report Studio, Query studio, C8 server, Content store Analysis Studio.
• Configured data sources utilizing existing SQL Server data sources and SAP BW.
• Developed 4 Models and 15 Packages using Framework Manager and published to Report Studio.
• Prepared SAP metadata and created 6 packages by preparing teh remote cues, characteristics, dimensions, key figures, attributes and sap variables for strategic dashboards and reports.
• Involved in testing and exploring tools using Query Studio and Report Studio.
• Created new jobs using Cognos Connection. Scheduled various reports using Schedule Management used in Cognos Connection.
• Integrated teh existing security with Cognos 8 Security.
• Configuring with LDAP Server for enterprise authentication.
• Bursting Reports using Report Studio.
• Provided on call and customer support.
• Created various reports using Report Studio, Query Studio.
• Transformed teh existing universes into Framework Manager Models and published those packages onto Cognos connection.
• Reported and resolved Cognos software bugs.
• Created various IQD package in Framework Manager and from dis IQD teh solution for PowerPlay transformer to create various models and cubes.
• Involved in Migrating & consolidating existing reports in Cognos canned reports.
• Built multi-dimensional Models and power cubes.
• Generated PowerPlay reports and published them on Cognos connection.
• As per teh Business requirements, customized data by adding calculations, summaries, prompts, filters.
• Provided Cognos training to user community for Ad-Hoc Reporting using Query Studio and gave presentations for demonstration of Report Studio tools.

Environment:Cognos 8.2, Report Studio, Query Studio, Framework Manager, Map Manager, SQL Server 2005, Windows Server 2003, IIS 6.0, Business Objects 5x, Dashboard

Confidential, FL

Cognos Consultant/Instructor

Responsibilities:

• Prepared teh training demos and curriculum.
• Explained Server administration and Reporting tools.
• Highlighted teh key aspects of Administrators & Authors affecting teh BI Workflow.
• Handled Installation options and configuration issues in different environments.
• Explained teh Reporting and performance issues.
• Discussed Server performance tuning and troubleshooting issues.
• Examined teh security options such as authentication and encryption services, when publishing teh reports to Cognos connection.
• Assigned multiple scenarios to give a better understanding of Report and Event studio.
• Extraction of metadata from multiple sources & creating business views.
• Adding members, access permissions and deployment.
• Creating dashboards & Bursting Reports.

Environment:Cognos 8.2, Report Studio, Query Studio, Framework Manager, Map

Confidential, IL

Cognos 8 Developer

Responsibilities:

• Understood Business System requirements and translated those requirements into technical specification for solutions development.
• Configured Cognos Series 8 Products, Framework Manager, Cognos connection portal, Report Studio, Query studio, C8 server, Content store Analysis Studio.
• Developed Models and Packages using Framework Manager and published to Report Studio.
• Involved in testing and exploring tools using Query Studio and Report Studio.
• Created new jobs using Cognos Connection. Scheduled various reports using Schedule Management used in Cognos Connection.
• Integrated teh existing security with Cognos 8 Security.
• Configuring with active directory for enterprise authentication.
• Bursted Reports using Report Studio.
• Provided customer support and user orientation.
• Created various reports using Report Studio, Query Studio.
• Reported and resolved Cognos software bugs.
• Created various IQD package in Framework Manager and from these IQDs teh solution for PowerPlay transformer to create various models and cubes.
• Involved in Migrating catalogs into report net using migration utility.
• Built multi-dimensional Models and power cubes.
• Generated PowerPlay reports and published them on Cognos connection.
• As per teh business requirements customized data by adding calculations, summaries, prompts and filters.
• Provided Cognos training to user community for Ad-Hoc Reporting using Query Studio and gave presentations for demonstration of Report Studio tools.

Environment:Cognos 8.2, Report Studio, Query Studio, Framework Manager, Map Manager, SQL Server 2000, Windows Server 2003, IIS 5.0.

Confidential, AL

Cognos Developer

Responsibilities:

• Gatheird and analyzed user requirements
• Designed Models using Framework Manager, which facilitates reporting requirements based on customer.
• Coordinated with ETL developer to suggest table modifications for better use in reporting.
• Created reports using Cognos ReportNet.
• Deployed reports and packages to different environments.
• Published packages using Framework Manager to teh Cognos Connection Portal.
• Created stored procedures for prompts and to calculate aggregate values for reports
• Remained up-to-date with teh client requirements.
• Presentation to potential clients about company's progress.
• Designed and developed marketing, financial and operational models.
• Created user documentation manuals and training material.

Environment: Upfront, ReportNet, Transformer, Oracle 8i.

Confidential, AL

Web Graphics Editor

Responsibilities:

• Responsible for creating demos in client approval process.
• Created prototypes.
• Created graphic themes for multiple clients.
• Lead and supported web development team.
• Served as POC for animation jobs utilizing Flash 4.0
• Used MySql as a database for creating advanced action scripts.
• Creating teh electronic layout in Adobe PageMaker.
• Over looking difficulties in adding or removing teh contents in teh edited version.
• Created and maintained teh graphic layout of teh news paper.
• Helped manage teh website and its contents.
• Served as teh HTML & Script Coder for teh website
• Automated teh process flow by creating templates for teh columns
• News reports & advertisements.