Professional Summary:

Have 13 years of industry experience working as a Lead Business Analyst/ Business Intelligence Consultant/Administrator performing roles from reporting solution feasibility analysis, customer interview and intelligence gathering, resource and time estimation, environment setup and configuration, server management and troubleshooting, lead and mentor development team, prepare deliverables, coordinate integration testing efforts and troubleshooting and finally UAT and user training. I come from sound technical background of B.E. Electronics from India with MBA MIS from one of the universities in New York State.

Confidential

Cognos Administrator/Developer

• Implemented end to end IBM Cognos 10.1 BI Suite in a multi-server environment.
• Established clear base of operation of new report content creation at Development servers and deployment to Production servers.
• Configured user access profile and established user authentication and content security.
• Interviewed users for intelligence gathering and reporting requirements documentation.
• Worked with ETL developers to extract needed data from OLTP, load to enterprise data warehouse staging areas, and finally transform to multi dimensional data marts held together with conformed dimensions.
• Used Framework Manager to create reporting packages.
• Created DMR cubes for analysis via slicing and dicing data.
• Created several complex graphical dashboard reports
• Monitor Cognos servers, monitor job performance, troubleshoot server operational issues
• Provide training to new business users and mentoring to junior analysts.
• Implemented Data Governance, data file format constrains.

Confidential

Reporting Developer/ System Analyst

• Identify needed talent from available offshore resource pool.
• Perform feasibility analysis of the proposed solution.
• Work with Project Manager on MS Project in estimating work load per sprint and resource hours on Gantt charts.
• Create Business Requirement Document BRD and approve it with business users.
• Discuss data necessities with DBAs and perform Source to Target Mapping
• Identify shortcomings and road blocks, work with stakeholders in obtaining clearance and clarifications as and when required.
• Enforce Data Governance within the team.
• Develop needed reporting solution, coordinate testing and finally train users on new platform.

Skills Used: Cognos 8.X/10.2 BI Suite, Framework Manager 10.2, Cognos Mobile, Windows 7/2003/2008, DataStage 8.4, Transformer 8.4, Netezza 4.0 Data warehouse appliance, Oracle 10g/11i, SQL Server 2012, Aginity Workbench, ESRI Maps 5.0, iOS 7.1, Toad 11.6, MS SharePoint, JavaScript, PL/SQL, T-SQL, IIS Gateway, HP Quality Center

Confidential

Lead Dashboard BI Developer

• Primary responsibility to interview business users and collect solution requirements
• Create Business Requirement Document template and document these requirements
• Worked with data modelers in customizing data mart to reporting requirements. Identified business categories and created dimensions to represent them on our data warehouse.
• Created Dashboard components like 3D Bar charts, Pie charts, Show/Hide Accordians, colorful Palettes, Conditional formatting, heavy Java Scripting, creating Global Report Templates and Palettes etc to enhance user viewing experience
• Worked with Cognos Admin to create work plan to convert existing Impromptu 7.4 reports catalogs into Cognos 10.1 Reports and metadata model.

Confidential

Lead BI Developer and FM Modeler

• Pulled needed tables and fields to Microsoft SQL Server 2008 DWH
• Created SSIS package and pull in Framework Manager to creating a reporting layer.
• Prepared a SSRS PoC report in Business Intelligence Development Studio that showed the needed fields and prompts to imitate one of the existing legacy XLS report.
• Prepared wide range of reports including List Reports, Crosstabs, Dashboards, Graphs with multiple joins, Cascaded Prompts, Conditional Prompts, Drill through

Confidential

Senior Cognos BI Author

• Interacted with high level architects, Functional/Business Leads in understanding the purpose of a report and performed Source to Target mapping.
• Created my own PL/SQL queries in form of Materialized View, Views, Stored Procedures on front end utilities like TOAD and SQL Plus.
• Worked with ETL team on INFORMATICA to prepare data marts that address the reporting needs of particular reporting subsystem. Created Star schema architecture consisting of Fact and Dimensional Models
• Created DMR models to address analytical summary of business processes across different dimensions.
• Created complicated reports including charts, list reports, crosstabs reports, multiple join queries, cascade prompts, conditional filters, Master-Detail relationship using Report Studio and ad hoc reports using Query Studio.
• Performed Cognos Administration tasks of preparing packages and moving them across to production servers via FTP and deploy those packages in a weekly fashion

Confidential

Cognos Solution Provider

• Regularly attended meetings and took minutes of the meetings and documented them.
• Discussed feasibility analysis for proposed solution with BI team
• Migrated data from silo Source of Records to Data warehouse
• Created packages on Framework Manager
• Created charts, lists and crosstabs, using Report Studio and ad hoc reports using Query Studio. Introduced Java Script customizations to the report elements.
• Designed many Multidimensional MOLAP cubes on Transformer each precalculating summaries for a business unit and design multiple startup PowerPlay.