SUMMARY:

• Around 10 plus years of experience in Software Architect, Administration, Development participating in planning, analysis, design, review and programming in various projects. which includes Eight years of experience in BI Tool Cognos 10x( V 8.1.1,8..2,8.3,8.4) /ReportNet 1.1/ EP Series 7.x including Framework Manager, Report Studio, Query Studio, Event Studio, Impromptu Administrator & Impromptu Web Reports (IWR), Analysis tools such as, Analysis Studio, Power play Transformer, Power Play Enterprise Server, Cognos Query, Cognos Script, Power Prompts, Access manager.
• Around three years of experience in upgrading to Cognos 8 BI.
• 3+ Years of experience in Development & Administration of Tableau Desktop & Server 8.x/7.x and creating actionable and interactive reports/dashboards and maintain distributed server environment.
• Experience in Tableau Server Installation, Configuration, Maintenance, Security, Creating users, groups, projects, assigning access levels. Production support for monitoring server health.
• Experience in using Tabadmin/Tabcmd commands to perform maintenance tasks i.e. taking server backups, to set/restore processes settings and change server configurations settings etc.
• Experience in configuration of background jobs, scheduling of the extract refresh and Subscription jobs, Troubleshooting failed refresh activity, monitoring dashboards performance on tableau server.
• Experience in creating different visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Heat maps and Highlight tables.
• Involved in Trouble Shooting, Performance tuning of reports and resolving issues within Tableau Desktop/Server Reports.
• Involved in setting - up Tableau Server platform in clustered environment and performing content upgrades.
• Established Best Practices for Enterprise Tableau Environment and application intake and development processes.
• Experience in monitoring critical performance parameters of tableau server.
• Created action Filters, Parameters and Calculated fields, Sets, Groups etc., for preparing dashboards and worksheets in Tableau.
• Expertise in full life cycle and Methodology including Administration, designing, development and deployment of Data Warehousing and Business Intelligence applications using Cognos Suite 7/ 8/10
• Experience with new functionalities of Cognos 10, like active reports, Business Insights and Business Insights Advanced.
• Extensively worked with mobile technologies using both Cognos Web and IBM Cognos Native application for iPad and iPhone. Also worked on developing Cognos reports for Blackberry.
• Good experience with Designing of Cognos System Architecture.
• Worked extensively in analyzing enterprise data and designing logical models for optimal performance in reporting
• Good knowledge and experience in working with Business Objects reporting tool.
• Extensive experience on Dashboards for different corporate data application like Retail, and finance
• Strong experience in creating Ad hoc queries and customized reports using Query Studio, Report Studio, Event Studio containing functionality such as conditional formatting, prompts, bursting and drill-through.
• Strong experience in client interaction and understanding business application, business data flow and data relations from them.
• Experience in administering security by defining roles and groups, monitoring/modify scheduled reports/jobs using Schedule management tool
• Knowledge in performance tuning and troubleshooting complex reports
• Extensive experience in client interaction and understanding business applications
• Team Player as well able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.
• Good analytical and communication skills, ability to work independently and a good team player. Highly adaptable, versatile and responsible

TECHNICAL SKILLS:

Operating Systems: Windows 95/98/NT/2000, UNIX

Languages: SQL, PL/SQL, HTML, DHTML, PL/SQL Tool Kit

Databases: Oracle 8i/9i, SQL server2000, MS access, Teradata

Web Technologies: HTML, XML, JavaScript, IIS 4.0, VB Script

ETL Tools: Erwin 3.5/4.0, SQL* Plus, SQL* Loader Informatica, Power Center 6.x/5.x/4.5, Data Stage 6.0, SQL Server - DTS

BI Tools: Report Net 1.1,Cognos Business Intelligence Series7x/8x/10x| Framework Manager, Power Play Series 7, Tableau ServerAdministration, Tableau Desktop (7.x to 8.x)

PROFESSIONAL EXPERIENCE:

Confidential

SR Cognos Developer/Modeler/ Tableau Admin/Developer

Responsibilities:

• Created metadata model and packages by using Framework Manager and published those packages into Cognos Connection
• Interacted with customer to get various business needs, resolve issues and develop appropriate solutions.
• Optimized package and applied right joins.
• Created List, Cross Tab, Chart Reports using Report studio for end users analysis.
• Created cascading prompts and worked with various prompt controls such as Value Prompt, Tree Prompt, Date and Time Prompt
• Worked with the join functionality to create various reports.
• Generated reports for comparative analysis
• Migrated code between Dev, Test Environments
• Involved in System Integration Testing (SIT) and Parallel Testing.
• Built audit reports for Operational Systems
• Created Dashboardsfor a better understanding of the business performance metrics
• Resolved user issues every day users to get different kind of reports issue.
• Involved in Tableau Server Installation and Configuration, creating users, groups, and projects and assigning access levels.
• Used Tabcmd and Tabadmin commands to publish workbooks and perform administrative tasks
• Worked on Tableau Dashboards in Tableau 8.1 and Demonstrated knowledge in dealing with various functionalities like context filters, global filters, guided navigation, customization, conditional formatting of reports to satisfy the end users.
• Developed dashboards, reports as per the requirements with appropriate interactivity between reports.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards.
• Develop, organize, manage and maintain graph, table, slide and document templates that will allow for efficient creation of reports.
• Created and assisted users in Tableau dashboard development.
• Extensively worked on creating calculated fields and Analysis depending on the user requirements.
• Used Tableau Desktop for blending different data sources and creating different interactive views and dashboards.
• Involved in troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports

Environment: Cognos10x (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos connection),Cognos 10x Scheduler, Business Insights, Oracle10g, Sql Developer, Windows XP. Tableau Server 7x, Tableau Desktop 7xOptum Government Solutions Inc., Indianapolis, Indiana

Confidential

SR Cognos Developer/Modeler/ Tableau Admin/Developer

Responsibilities:

• FSSA Project was implemented using Waterfall methodology.
• Worked on Informatica Metadata Manager and used Lineage Function for documenting the Business Rules.
• Involved in Designing and creating various Subject areas like Provider, Recipient, Claims and Financial for State and Federal reporting inFramework Manager 10.2
• Involved in JAD sessions including documenting rational process to gather and define requirements.
• Extensive experience on documenting business needs and developing design documents with help from various technical teams.
• Structured Metadata and Cognos Models using Framework Manager.
• Involved in creating complex Report Studio reports with Provider & Claims subject area.
• Created different types of reports like List, Cross-tab, Chart, Drill-Thru and Master-Detail Reports
• Involved in Install, configure, upgrade and patching services on BI environments
• Involved in installing & Configuring Microsoft IIS Web server.
• Proficient Knowledge in authentication methods like LDAP and single sign on tools
• Provide 24x7 on-call support and draft required documentation for incident responses and service request submissions.
• Managed the Security and Health of the BI environment
• Created Analysis Studio Reports for data analysis and trending
• Involved in System Integration Testing (SIT) and Parallel Testing.
• Created report Specifications documents for the GSD & DSD.
• Formalized the reporting process by creating the technical specification and requirement specification document.
• Involved in Data profiling of Teradata with the ETL team to assist them to check the Data Quality.
• Interacted with the business users and assist/train them to use query Studio to develop ad - hoc reports.
• Provided day-to-day support for all COGNOSReport studioandQuery studioReports Using Numara BMC Foot Print 11.5
• Created Dashboardsfor a better understanding of the business performance metrics.
• Gathered healthcare trend analysis requirements for Cognos solution.
• Customized Cognos Portal according to the User Specification.
• Communicated report development progress and issues to management and team members using Agile Methodology.
• Designed and Prepared a Material for the Users.
• Involved in users to the new data warehouse environment
• Developed and published reports and dashboards using Tableau Desktop/server.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Involved in Installation and configuration of Tableau Software. Have also configured distributed installation of Worker Servers for production environment.
• Created Users, groups and Domains from Active directory and created different License level for each User on Tableau Servers.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Configured tableau server for subscriptions enabling business to receive dashboards periodically.
• Collected data on various process measurements and formatted into graphs using Tableau software.
• Developed Dashboard reports to display all the information related to environment using Summary reports.
• Redistributed tableau server processes (based on tableau’s recommended configuration) in a distributed environment to improve server’s performance.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: Cognos10.1/10.2 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos connection), Tableau 8.1,Cognos 10.2 Scheduler, Teradata14, Teradata Profiler,BMC Footprint, Informatica metadata manager, Sql Server 2008, Windows XP.

Confidential, Columbia, MD

Sr. Cognos Developer/Modeler

Responsibilities:

• Involved in Gathering business requirements for Cognos Reports for 5 MSIS data marts.
• Involved in creating Cognos Report Studio reports including Cognos administration for MSIS application on Cognos 10.1.1.
• Developed FM Model for MSIS application for Report development.
• Build models with Model Query Subjects, Query Items and Namespaces from scratch as well as from imported metadata to create Database layer and Business View Layer.
• Involved in doing cognos cube refresh through mdl scripts on UNIX environment.
• Responsible for creating ad - hoc reports using Query Studio for MSIS application
• Created complex reports for State Summary, Inpatient and Clinical data marts.
• Involved in setting up authentication (MS Active Directory) and authorization on cognos environment for External and Internal Users.
• Used Informatica 9.1 for ETL Process for State Summary (SS) and Annual Penson Summary (APS) data in MSIS data marts.
• Responsible for writing UNIX scripts to call informatica mappings for ETL Load process.
• Responsible to drop unused old data marts and integrated required facts and dimensions on new data marts.
• Development of application to send the mart data back to mainframe for audit purpose.
• Responsible for creating manuals and business users.

Environment: Cognos8.4/10 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos connection),Cognos 8.4 Scheduler, Business Insights, Oracle10g, Toad 9.1,Windows XP.

Confidential, Ft. Washington, PA

Sr.Cognos Developer

Responsibilities:

• Convert Existing Keystone Cognos8.4 Package to python Cognos 8.4 Package.
• Created a new archive Cognos 8.4 package.
• Resolved performance issues on consumer reports
• Migrated cognos 8.4 reports and packages to Cognos10.1
• Used Business Insights and Business Insights Advanced to arrange individual reports into dashboards.
• Created cubes in Transformer using Framework Manager IQD's, packages and report studio reports as a source
• Involved in troubleshooting of data issues in Fulfillment and contacts cube.
• Involved in rewriting report specification documents.
• Trained internal business users on using reports.

Environment: Cognos8.4/10 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos connection),Cognos 8.4 Scheduler, Business Insights, Oracle10g, Toad 9.1,Windows XP.

Confidential, Baltimore, MD

Sr. Cognos Developer/Modeler

Responsibilities:

• Extensively Used Report Studio to develop the Cognos Reports.
• Created joins and Relationships between dimensions and Facts. Resolved Ambiguous relationships to reduce Data Redundancy.
• Build models with Model Query Subjects, Query Items and Namespaces from scratch as well as from imported metadata to create Database layer and Business View Layer.
• Work Closely with Business Analyst and QA Teams for requirements and testing.
• Developed Material for Report Users.

Environment: Cognos8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos connection),Cognos 8.4 Scheduler, Oracle10g, Windows XP.

Confidential, Reston, VA

Sr. lead Cognos Developer/Modeler

Responsibilities:

• SDM1 Retirement project involved identifying the high priority reports that were run from the Crystal reports portal, understand the requirements and convert these reports to Cognos platform.
• Worked on understanding the business requirements and in some cases identified issues with the old reports while analyzing the SQLs or writing new ones.
• Build models with Model Query Subjects, Query Items and Namespaces from scratch as well as from imported metadata to create Database layer and Business View Layer.
• Created joins and Relationships between dimensions and Facts. Resolved Ambiguous relationships to reduce Data Redundancy.
• Build star schema grouping based on reporting requirements and subject areas.
• Build Subject area Packages and Published Packages to the Report Server using Framework Manager.
• Updated model with updates in data warehouse model.
• Tested relationships and join cardinality of the model using frame work manager and query studio.
• Documented Functional and detail design of model with subject areas.
• Developed complex reports using report studio
• Used Manually Modified SQL in Report Studio to write complicated reports. Used subsets to write union, intersection and joins in Report Studio.
• Involved in performance tuning of the reports
• Created and maintained Cognos jobs
• Actively understood the data flows in business process
• Worked with DBA of the team to help with the performance tuning. In some cases identified materialized views that helped running the reports much faster.
• Worked with UAT team on all report issues.
• Worked with Shared services and CM team in deploying the reports to higher environments.
• Worked with closely QA team bug fixes.
• Performed Cognos user
• Delivered the project successfully and as a result, the Confidential can now retire the SDM1 database and all the associated reporting products based on this system. By doing this, the organization will save by not supporting two similar systems and also because it helps the users move to a single enterprise platform from both data and BI perspectives.

Confidential

Sr. Cognos 8.4 BI Reporting /Modeler

Responsibilities:

• Confidential is one of the most challenging projects ever undertaken by the Confidential as a BI tool would be rolled out to an unprecedented 180,000 users approximately.
• Identified the capabilities, challenges and limitations of the Cognos platform in support of the project.
• Developed complex reports using report studio and ad hoc reports using query studio.
• Used Manually Modified SQL in Report Studio to write complicated reports. Used subsets to write union, intersection and joins in Report Studio.
• Created list reports, cross tab reports and chart reports with Drill through and Master-Detail using Report Studio.
• Developed Prompt Page Reports using Conditional blocks and Conditional Variables for developing the User Prompted Report.
• Built and maintained Cognos reporting security
• Worked through the integration challenges between the WRA, EPL and BIX.
• Developed Framework manger Model and provide the best model/solutions for the report generation.
• Documented Functional and detail design of model with subject areas
• Interacted with the Business users and documented their requirements, Business Analysis and Reporting needs. Understood data and business logic underlying the requirement.
• Interacted with the Management and Business User for gathering information and ongoing requirement changes for creating Model and Reports.
• Lead the Cognos Administration activities in the lower environments, which involved setting report level/portal level security, configuration changes, working with the CM on deployments.
• Worked with IBM Cognos Support to resolve report and server related issues.
• Involved in Performance and query tuning on long running queries.
• Worked on Unit Testing, Integration Testing and Performance Testing of reports
• Worked with RA/DBA on architecture /design of new reporting tables for OSR
• Once operational, the OSR system will be a big win for the Confidential, data Services and the AP program. This will be our first roll out of BI functionality to external users and by far the largest Cognos implementation to date.

Environment: Cognos8.4 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Event Studio, Cognos connection),Cognos 8.4 Scheduler, MS SQL 2005, Oracle10g, Windows XP