Summary:

• Around 9 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 8 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.
• Experience in installing/upgrading the Cognos servers from Version 6.0 to EP series version 7.0 MR1, MR2 and Cognos 8.X, in Unix, Solaris and windows environments,
• Extensively used Report Studio, Query Studio, Event Studio, Analysis Studio for Report design in Cognos BI version 8.x
• Above 3 years of experience inCOGNOS Tools using like IMPROMPTU 7.0/7.1, POWERPLAY TRANSFORMER 7.0/7.1/7.3, IWR 7.0/7.1/7.3 and VISUALIZER 7.0/7.1/7.3
• 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, education 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
• Experience in creating technical documents for end users
• Knowledge on Extraction Transformation and Loading ETL using Informatica 8.X , Datastage 8.X
• 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

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 Series 7x/8x, Framework Manager, Power Play Series 7,Tableau Server Administration, Tableau Desktop 7.x to 8.x

EXPERIENCE

Confidential

SR Cognos Developer

• 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 Dashboards for 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 10xScheduler, Business Insights ,Oracle10g, Sql Developer, Windows XP,Tableau Server 7x, Tableau Desktop 7x.

Confidential

SR Cognos Developer/Modeler/Tableau Admin/Developer

• FSSA Project was implemented using Waterfall methodology.
• Worked on Informatica Metadata Manager and used Lineage Functionfor documenting the Business Rules.
• Involved in Designing and creating various Subject areas like Provider, Recipient, Claims and Financial for State and Federal reporting in Framework Manager 10.2
• Involved in JAD sessions including documentingrational 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 ConfiguringMicrosoft 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.
• Provided day-to-day support for all COGNOS Report studio and Query studio Reports Using Numara BMC Foot Print 11.5
• Interacted with the business users and assist/train them to use query Studio to develop ad hoc reports.
• Created Dashboards for 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 Training Material for the Users.
• Involved in training 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.2Scheduler ,Teradata14, Teradata Profiler,BMC Footprint, Informatica metadata manager ,Sql Server 2008 , Windows XP.

Confidential

Sr. Cognos Developer/Modeler

• 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 training manuals and training 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

Sr.Cognos Developer

• 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.