SUMMARY

• Over 7 years of experience in Software Administration Analysis, design, development, testing, documentation and implementation of client server applications
• Experience with Business Intelligence tools like Cognos 10.2/10.1/8,7, Report Net, Framework manager, Power Play, Power Play Transformer with Oracle,IBMDB2 and SQLSERVER Databases.
• Strong background in building Metadata models using Framework Manager and Dimensional Modeling.
• Extensively worked on developing various kinds of reports in Cognos 10.2/10.1/8 Report Studio, Analysis Studio and Query Studio.
• Involved in a data migration process between different versions of Cognos.
• Extensively worked on Power Play Transformer for building up of Multidimensional Cubes.
• Experienced in writing SQL scripts to automate process and optimize the data transfer.
• Experienced in developing Dashboards Reports in Cognos 10.2/10.1/8 based on OLAP Cubes designed on Cognos Transformer.
• Expertise in version upgrades and Migrating Impromptu Catalogs, Power Play Cubes, and Report Net reports into Cognos 10.1.1/8.
• Transforming their business needs into structured format by thorough documentation of the same to be understood by delivery team to perform necessary analysis.
• Possess extensive experience with Cognos Framework Manager including importing Metadata Source, Modeling and applying table level, and data level security.
• Experience in applying user level and functional level security on different groups in Cognos 8.2/8.4.1/10.1.1 and also worked on few features of SSO(single sign on)
• Setting up domain groups and assigning access rights to users and groups using the Cognos Server tools linked to standard LDAP.
• Developed and published PowerPlay Cubes and Packages on Cognos Connection and created multidimensional reports using Analysis Studio/Report Studio.
• Hands on experience in Installation, administration and upgrading versions of Cognos from 8.2 to 8.4 and from 8.4 to 10.1.1.
• End to end knowledge on Cognos Setup and Administration.
• Good Knowledge with Databases Oracle, DB2, Vectorwise and Other BI tools like SAP BI/BO and data visualization tools like Tableau, Japersoft, Spotfire and Qlikview.
• Extensive Tableau Experience in Enterprise Environment, in Tableau 6.0, 7.0, 8.0 and 8.1 as a Developer and Analyst
• Extensive Tableau Experience in Enterprise Environment and Tableau Administration.
• Experience includes technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Preparing Dashboards using calculations, parameters in Tableau.
• Creating Dashboard in QlikView from Database and QVD files, setting up incremental load, partial loads set analysis, writing load scripts, access point setup, managing user security and named user licenses.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Experienced in tuning Long running SQL queries for better performance.
• Extensive knowledge using SQL for back end optimizing and report development
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
• DevelopedUNIX shell scriptsto be used as pre-session and post session commands and knowledge in AWK Programming.
• Hands-on experience in handling Server Vulnerabilities, Application security, Project external audits and Risk Management.
• Design an appropriate model that best suits the current need and the possibilities to come.
• Lead and co-ordinate a team, working from varied geographies.
• Stand up to take responsibilities for any shortcomings from team or self.

TECHNICAL SKILLS

Business Intelligence Tool: Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos Connection), Framework Manager, Cognos Impromptu, PowerPlay Transformer Report Net 1.02/1.1, Impromptu Web Reports (IWR), Access Manager, PowerPlay Enterprise Server, Scheduler.

ETL Tool: Informatica Power Mart v6.1/5.0 & Power Center v6.1/5.0

Databases: MSSQL Server 6.5/7.0/2000 , Oracle 8i/9i/10g, MS Access, DB2

DB Tools: SQL*Plus, SQL*Loader, Toad

Languages: C++, C#, Java, Visual Basic 6.0, VC ++, SQL, PL/SQL, XML

Operating Systems: Windows /NT, UNIX (Solaris, Linux)

PROFESSIONAL EXPERIENCE

Confidential, Connecticut

Sr Cognos Developer

Responsibilities:

• Worked with Business users to gather Business strategy and created a centralized reporting capability for users to perform analytical and ad-hoc reporting for business applications.
• Developed Business Requirement Documents based on Client’s Requirements.
• Developed and managed dimensionally Modeled Relational model (DMR) using Framework Manager.
• Defined the keys, Joins, cardinalities and global filters in Framework Manager.
• Used package level security and folder level security.
• Developed Burst reports, Drill through, Master Detail, List, Chart, cross tab and complex reports in Report Studio based on the business requirements involved Multiple Prompts in Report Studio.
• Migration of reports from Cognos 7 to Cognos 10.1
• Created query studio reports using Custom Grouping option.
• Applied conditional formatting for hiding the data, and highlighting the data.
• Coordinated with offshore team for Migrations.
• Performed administration task for user permissions & scheduling the reports.
• Utilized the burst capability in Cognos to distribute the reports to end user.
• Used Event Studio to trigger the jobs.
• Use the advance functionality of Analysis Studio such as drill up and drill down, rank, slicers etc.
• Created Technical Specification documents for QA team to understand more about reports which was helpful for their testing.
• Interacted with QA team for Unit Testing, System Testing and Performance Testing.
• Coordinated with functional users for User Acceptance Testing prior to releasing system changes in production.
• Create dashboards, KPI’s, FM Models, Transformer Cubes, SQL, TM1 cubes.
• Perform software integration and testing, and develop enhancements and modifications.

Environment: Cognos 8 & 10 BI, Cognos Connection, Cognos office Connection, Report Studio, Query Studio, Analysis studio, Metric studio, Frame Work Manager,DB2,SQL,XML and Windows NT/4.0.

Confidential, Massachusetts

Tableau Developer

Responsibilities:

• Involved in the installation and configuration of Cognos 10.1.1
• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Blended data from multiple databases into one report by selecting primary key’s from each database for data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktop by connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh onTableauServer for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7 & 8.1,TableauServer, MS Office Suite, Oracle SQL Server R2, MS Excel

Confidential, Eagan, Minnesota

BI Consultant (Business Objects & QlikView)

Responsibilities:

• Involved in POC and RFP for new Projects in QlikView and Business Objects; resource loading, allocation and utilization.
• Training and re-tooling resources on QlikView and getting the allocated on different QlikView development projects.
• Involved in evaluating SAP BI 4 and QlikView 11.2.
• Mentoring BO Developers to analyze and document technical specs for new requirements Involved in POCs for new projects and training users on new tools like WebI Rich Client, Report Conversion tool,Query As a Web Services (QAAWS), CR 2008 and Live Office.
• Conducted several BO and QlikView Classroom and Virtual Trainings

Confidential

Cognos Consultant

Responsibilities:

• capacity planning reports for Existing VNX and the old clariion arrays.
• Installed and configuredCognos 7.1 and Cognos 7.3 in Dev Environment.
• Created different types of reports likeList, Cross-tab, Chart, Drill-ThruandMaster-Detail Reports.
• Created multipleDashboard reportsfor multiple packages.
• Developed Prompt Pages, Cascaded input Prompts to display only the selected entries in the report and also worked on the customization ofprompt parameters.
• Involved in extensive use ofconditional formattingwhile developing reports inReport Studio.
• MigratedReports from Cognos 7.1 to 7.3
• Initiated training for the users to do ad-hoc reporting usingQuery Studio.
• Extensive experience on StructuringMetadata and Cognos Modelsusing Framework Manager.
• Provided support for slowly changing dimensions in data marts
• Implemented data profiling and quality check inData Manager
• Designed and Prepared a Training Material for the Users.
• Closely Involved inRequirement gatheringandAnalysiswith the customers.
• Created List Reports, Cross tab Reports and Control Charts
• Implemented Security for Data access, Object level access and Package access
• Used Cognos Connection extensively for organizing, security, scheduling and distributing reports
• Extensive experience inSecurity Administrationbased along with LDAP.
• Formalized the reporting process by creating thetechnical specificationand requirementspecification.

Environment: Oracle 10g, SQL Server 2005, ROLAP, Cognos 7.1/3 (Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection)