SUMMARY:

• Over 7 year of experience in IT includes extensive Functional and Technical experience in Business Intelligence (BI) product development and Reports Generation.
• Expert in Business Intelligence Applications using Cognos Tools such as Cognos BI (8.3 to 10.2.2)
• Star Schema and Snowflake Schema used in relational, dimensional modeling.
• Generated different kinds of reports list, crosstab, graph, map and created templates.
• Experience developing Active reports, complex reports using drill - through reports, prompts, dashboards, master-detail, burst-reports, dynamic filtering in Cognos..
• Involved in full life cycle of Data warehouse Projects major deals with forecasting, demand, primary and secondary sales analysis, HR Payroll analysis, and cost variance analysis.
• Experienced in creating Multidimensional Cubes by using Power play Transformer.
• Extensively used Framework Manager for model design and Using Analysis Studio, Query Studio, Report Studio for ad-hoc, can and advanced report authoring.
• Involved in designing of Relational and Dimensional Model in FM using different databases for creating Models, Packages, calculations, and publishing packages.
• Experience in Cognos Administration, Security, roles and groups for authentication, Content Administration and Deployment.
• Developed Active reports for IPAD, iPhones as well as Blackberries using the Cognos Mobil application.
• Extensively used RDBMS like Oracle, SQL Server and DB2 for developing different applications.
• Experience working in the functional domains of Insurance, Health Care, Education, Finance and Mortgage.
• Have good understanding of Tableau architecture, design, development and end user experience.
• Extensive experience in Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Bullets, Heat maps and Highlight tables
• Translate business requirements into technical specifications.
• Mentored and trained users in the successful execution of the project.
• Self-motivated and possess excellent critical thinking ability, good interpersonal and communication skills, team-oriented.
• Ability to work under stringent deadlines with teams as well as independent.

TECHNICAL SKILLS:

BI Tools: IBM COGNOS Version 8.4 to 10.2.2:, Active report, Cognos Work Space, Cognos Work Spaceadvance, Framework Manager, Report Studio, Metric Studio, Event Studio, Query studio, Analysis Studio, COGNOS connection, Cognos Mobil, COGNOS Power Play Transformer, Enterprise server, Upfront, OLAP cubes, STAR SCHEMAS and SNOW-FLAKE SCHEMAS, Cognos Mobil, Rave

Tableau: Tableau Desktop, Tableau Server and Tableau Reader 8.x/9.x.

Operating Systems: Windows 95/98, Windows NT 4.0, Windows 2000/XP, Windows 7 professional

Databases: DB2, Oracle 10g/9i, SQL Server 2000/2003/2008 R2, Access DB

Big Data: Hadoop, HIVE, Impala, HDFS

Languages: SQL, T-SQL, HTML, XML, XHTML, JAVA

Software Packages: MS-Office 2007,2010 Microsoft Word, Excel and Power Point, JIRA, SharePoint, MS Visual Studio, Rapid SQL, SQL workbench

ETL Informatica: Power Center 9.1

PROFESSIONAL EXPERIENCE:

Confidential, Worth, TX

BI Developer

Responsibilities:

• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery.
• Connected Tableau server to publish dashboard to a central location for portal integration.
• Connected Tableau server with share-point portal and setup auto refresh feature.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Created visualization for logistics calculation and department spend analysis.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Analyzed the source data and handled efficiently by modifying the data types.
• Used excel sheet, flat files, CSV files to generated Tableau adhoc reports.
• Created folders, filters, prompts, and complex business calculations in Framework Manager Model.
• Expertise in developing Standard Reports, List Reports, Cross-tab Reports, Charts,
• Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Created Ad-hoc reports in Query Studio for users.
• Developed dashboards reports for Complaints and Replacements for Policies on daily basis.
• Developed Cognos transformer models using Cognos Powerplay Transformer.
• Developed Analysis studio Reports and cubes using Analysis Studio.
• Developed Standard templates in Report Studio for developing reports.

Environment: Cognos 10.2.2, Framework Manager, Cognos Connection, Report Studio, Business insight/ Advance, Pivot table, DB2, Window 7, Tabluea Desktop, Tableau Public.

Confidential, Irving, TX

Lead BI Consultant & Hadoop integration with BI Tools

Responsibilities:

• Developed Prototype dashboard, list/Cross tab reports using the Hadoop data as a source.
• Working with Hive and Impala for Hadoop data validation.
• Gathering the Information for Framework Modeling.
• Cognos Configuration and Cognos Administration to set up a fully functional instance of the Cognos BI platform
• Migrating bulk reports (1400) from the existing Cognos environment to STE Cognos environment.
• Develop, deploy, and communicate on-going monitoring of relevant business metrics, across financial and non-financial areas.
• Provide user security based on the role and group defined in LDAP.
• Creating Master dashboard, monitor and optimize the result set based on the users Migration.
• Working as BI lead with on-site and off -shore teams to handle all the BI reporting platforms.
• Involved in creating dashboards by extracting data from different sources
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Report Studio, Business insight/ Advance, SQL server SSRS, SSIS, DB2, Hadoop, Platfora, Pivot table, Tableau Desktop, Tableau Server

Confidential, Plano, TX

Cognos Developer & FM Modeler 10.2.1 & Jr. Hadoop consultant

Responsibilities:

• Analyze reporting requirement.
• Develop views to get the desired output as business needed.
• Worked on framework modeling and reporting.
• Worked in Report studio 10.2.1, Query Studio and Workspace advance.
• Developing Cube from SSRS to Cognos power-play transformer.
• Publishing the Cognos cubes and tunning the metadata.
• Clubbing a group of SSRS packages into one or two Framwork Model and create different packages.
• Working closely with the COE team for the debugging and resolving the issue in Framework Manager.
• Create a complete set of documents and publish for review along with the migration request
• Ability to deploy Hadoop cluster, add and remove nodes, keep track of jobs, monitor critical parts of the cluster, configure name-node high availability, schedule and configure.
• Experience in Hadoop Administration - installation, upgrade, maintenance, patching and configuration
• Performance tuning of Hadoop clusters and Hadoop MapReduce routines
• Screen Hadoop cluster job performances and capacity planning
• Monitor Hadoop cluster connectivity
• Working with data delivery teams to set up new Hadoop users. This job includes setting up Linux users and testing HDFS, Hive, Pig and MapReduce access for the new users.
• Cluster maintenance as well as creation and removal of nodes

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Report Studio, SQL server SSRS, SSIS, DB2, Cogons Power-play Cubes, Hadoop, MapReduce, Hive, Pig, HDFS

Confidential, Calverton, MD

Cognos Developer 10.2.1

Responsibilities:

• Interacting with the End users on a regular basis for resolving issues pertaining to the reports
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Developed Ad-Hoc reports using Query Studio.
• Developed Variables for Complex Formatting Reports.
• Developed cascading prompts in Report Studio to help users refine their search.
• Involved in Admin Tasks Like Maintaining Portal, Assigning Securities, Scheduling Reports.
• Involved in the development team to USL ( Universal Semantic Layer) development and for design and connectivity with FM.
• Testing the Report that is to be set to the client by following the guidelines
• Responsible in the setup of Cognos Security. Setup of User Groups, Roles, Etc
• Created reports using different prompts like value, date and time and text box prompt to add interactivity for the user

Confidential

Cognos Developer 10.1.1

Responsibilities:

• Day to day support of the Cognos applications which includes data updates.
• Creating data modeling solutions to support HIX analytic requirements.
• Building dashboard-style reports combining lists, cross-tab, and chart displays to give executives an “at-a-glance” look at the results of the company.
• Be a part of the team to Installing/configuring IBM Cognos products; using Cognos Configuration and Cognos Administration to set up a fully functional instance of the Cognos BI platform.
• Change the Cognos log files to set the UI as per the UX 2014 standard.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Multiple-levels of Drill through Reports and Master Detail Reports Using Report Studio.
• Developed Ad-Hoc reports using Query Studio and business insight advance
• Pull the data from DB2 and create Model in the Framework Manager according to the MD HIX the State and the Federal requirements.
• Involved in defining mappings to build the Framework Manager Model and Package with customized Query subjects and Query items and published package from Framework Manager to Cognos Connection
• Scheduled reports, maintained public and individual folders, user groups and roles using the Cognos Connection
• Developed the connectivity from USL (Universal Segmantic Layer) with Framework manager.
• Involved into a move to Deployment to UAT and Production
• Involved in the analysis, design, development, testing, deployment and user training of analytical & transactional reporting system.
• Creating a design document and upload the final version in Sharepoint (Local, State) with tracking all the development tasks using JIRA.
• Be a part of the team to work in ETL tool (Informatica)
• Working with ETL developers team to filter the data from source to target tables
• Working with Internal Stakeholders to gather and document business analytics requirements, including: Data, Layout and delivery requirements.
• Developing rapid-prototype or proof-of-concept reporting by using Excel as a data source and demonstrating those solutions to the State PMO’s.
• Support the full report development life cycle, including: data, layout, and delivery requirements.
• Developed Medicaid, Medicare and CHIP user report.
• Creating data modeling solutions to support HIX analytic requirements.
• Documenting the design of reports and tracing the design solution to the initial requirement
• Facilitate Technical exchanges between IT groups to ensure delivery of high quality work products
• Give presentations and knowledge shares with Federal User’s, Case workers, LHD and LDSS
• Capture the HIX design of reports and define the Cognos design solution to the initial requirement
• Monitored and managed project deliverables, artifacts, deadlines, tasks, responsibilities and development teams

Environment: Cognos 10.2.1, Framework Manager, Cognos Connection, Report Studio, Query Studio, Analysis studio, Window7, Sharepoint, JIRA, DB2

Confidential, Nottingham, MD

Cognos Developer 10.1.1

• Used some advanced features like Conditional Formatting in Report Studio in generating multi page Reports.
• Developed detailed and summary reports using Report Studio
• Moving Reports & Packages from Development to Production
• Created different Standard reports using prompts, filters, query calculations and conditional Formatting of measures using variables in Report Studio, in Cognos 10.1.1
• Create ad-Hoc and mapping reports for end users using Business insight and Business insight Advance
• Administered tasks such as Deployment, set Cognos security using (Active Directory) and report.
• Scheduling support to the users
• Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used Union/Join objects in Report Studio
• Production Support which involves solving End - user problems
• Developed complex reports using drill-through options and Master-detail relationships in Report Studio.
• Created list reports, cross tab reports, chart reports using cascading prompts, date prompts, complex prompt pages
• Improve the report performance and troubleshooting the issues within the report queries and FM Model
• Developed and Published Packages in Framework Manager
• Connecting and testing the data source, created Database layer, Relationship layer and Presentation layer, defining the appropriate relationship between query subjects.
• Developing rapid-prototype or proof-of-concept reporting solutions and demonstrating those solutions to customers

Environment: Cognos 10.1.1, 10.2, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Active report, Business Insight, Business Insight Advance, SQL,XML and Windows XP

Confidential, Leesburg, VA

Jr.Cognos Developer, 8.4 to 10.1.1

Responsibilities:

• Extensively worked with List Reports and various formats of report generation, e.g., PDF, Xml etc.
• Developed Active reports for IPAD, iPhones as well as Blackberries using the Cognos Mobil application
• Scheduling the reports and performed Report bursting
• Support the full report development life cycle, SDLC, moved to Deployment to UAT and Production.
• Building dashboard-style reports by business insight combining lists, cross-tabular, and chart displays to give executives an "at-a-glance" Look at the results of the company.
• Implemented best practices in the model by creating three layered architecture.
• Extensively involved in designing Metadata Model uses Framework Manger.
• Working on Framework security by using the Object, Row, Data level securities
• Installing/configuring IBM Cognos products; using Cognos Configuration and Cognos Administration to set up a fully functional instance of the Cognos BI platform
• Be a part of a conversion from Cognos v8.4.1 to v10 and then v10 to v10.1.1
• Troubleshoot report development issues by querying the report source data directly using Enterprise database tools.
• Be a part to interact with Business users and Source system data owners to gather the requirements.
• Facilitate Technical exchanges between IT groups to ensure delivery of high quality work products.

Environment: Cognos 10.1.1, Cognos Connection, Report Studio, Query Studio, Analysis studio, Frame Work Manager, Active report, Business Insight, Business Insight Advance, SQL,XML and Windows XP