SUMMARY

• 8 years of experience in developing BI Solutions using SQL Server, Oracle, IBM Cognos applications using Cognos 8.x, 10.x, ReportNet, Framework Manager, Impromptu, PowerPlay, Impromptu Web Reports (IWR), PowerPlay Enterprise Server (PPES), Transformer.
• Installed and configured tools related to Cognos in various organizations depending on the requirement
• Interacted wif end - users to gather requirements for reporting.
• Created prompts, cascading prompts, filters for summary and detail, conditional blocks, master -detail sections, drill through, page set, render variables and conditional strings.
• Createdmultidimensional cubeson transformer and developed Power Play reports to be published in report net server.
• Strong experience in Dimensional Modeling using Star Schema, identifying facts and Dimensions, Physical and logical data modeling using ER-Modeling.
• Expert level wif developing OLAP models, using Powerplay Transformer.
• Strong skills developing DMR models in Framework Manager and dimensional reports in Report Studio
• Worked on Oracle Database tuning using the various tools in Oracle’s performance tuning toolkit (Explain Plan, SQL Trace, DBMS PROFILER and 10053 trace file outputs).
• Experience in E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Experience working wif Oracle 11g/10g/9i/8i, SQL server databases on UNIX, Linux and Windows enterprise platforms.
• Experience maintaining PL/SQL store procedures and triggers to enable BI tools and applications.
• Experience wif Agile and Waterfall Environment.
• Strong noledge & experience in all phases of Software Development Life Cycle (SDLC) such as Developing, Testing, Migrating, Administrating, Security management and production support.
• Excellent analytical, problem solving, communication skills, wif ability to interact wif individuals at all levels wif exceptional skills in forming and facilitating teams.
• Hands-on noledge of Oracle Utilities such as SQL Loader, export/import, and tools such as SQL developer and Toad for Oracle
• Extensive noledge and experience on process analysis and optimization of reports

TECHNICAL SKILLS

BI tools: Cognos 10.2.10.1, Cognos 8/8.3 BI (Framework Manager, Metrics Manager, Report Studio, Query Studio, Analysis Studio, Metrics Studio, Event Studio), ReportNet 1.0/1.1, Cognos 7.3/7.1/7.0 (Impromptu, PowerPlay, Transformer, Architect, Access Manager, IWR, PPES, Visualizer, Scheduler, Power Prompts), Hyperion (formerly Brio) Intelligence 6.x.

Databases: SQL Server 2012, Oracle 9i/8i/7.x, SQL Server 7.0, Teradata, MS Access XP/03

Directory servers: Sun One 5.2, Netscape Directory Server 6.2

Programming skills: COBOL, C, SQL, J2EE

Scripting languages: Perl, Python, Ruby

Microsoft tools: MS Project, MS Excel, MS Word, MS Visio, MS PowerPoint

Operating systems: Windows NT/2000/XP, HP-UX 11.0, Red hat Linux 9.0

Data Modeling Tools: Toad, Erwin, Opnet Modeler, Oracle SQLPlus, Quest Toad

PROFESSIONAL EXPERIENCE

Confidential, MA

Cognos Developer (IBM Cognos, SQL Server)

Responsibilities:

• Participated in all the cycles of the management of the project in order to make sure dat the team reaches the project deadlines.
• Developed and Published Packages in Framework Manager- Connecting and testing the data source, created database layer, physical and presentation layers, defining appropriate relationships between query subjects.
• Wrote stored procedures in SQL Server Management Studio and imported them to the Cognos Framework Manager for creating reports wif complex calculations.
• Converted the historical reports based on Stored Procedures to dat of Model based reports in Cognos.
• Created reports like list, cross tab, drill-through reports, cascading reports and involved in performance tuning of these reports using Cognos Report Studio.
• Worked on SQL Script for performance tuning and testing the authenticity of the reports at the server level.
• Used Cognos Workspace Advanced for previewing the data for creating TEMPeffective reports.
• Made complex calculations to create turnaround times, appeal status, claims, audits, admission and readmission rates wif precise conditions etc. given by the Business analyst.

Environment: Report Studio 11.0 Framework Manager 11.0, Analysis Studio 11.0,IBM Cognos Business Insight, IBM Cognos Configuration, IBM Cognos Lifecycle Manager, SQL, PL/SQL, Team Foundation Server, Service now.

Confidential, Atlanta, GA

Sr BI Developer (IBM Cognos and MSBI)

Responsibilities:

• Designed SQL scripts for design and development of dashboards.
• Worked on Created complex SQL and T-SQL for reporting needs, I then used the SQL and also Stored procedures in Framework Manager for reporting needs.
• Developed Framework Manager Models by both writing SQL and also by importing metadata from database.
• Developed Cognos reports, FM Models, Transformer Cubes and Dashboards using various studios, Framework Manager, transformer and also implemented security.
• Used Conditional formatting, Conditional blocking, render variables, style variables, and dynamic columns.
• Used DMR Models to design reports in report studio.
• As part of the report testing, used SQL Server 2012 to write SQL test cases and then validate data in report vs the SQL test case as part of validation.
• Developed Dashboards using workspace and workspace advanced using version 10.2 and also developed Active reports.
• Assure all programs are documented using standardized documentation procedures; build and maintain data dictionary

Environment: Report Studio 8.4/10.1, Framework Manager 8.4/10.1, Analysis Studio 8.4/10.1, Powerplay Transformer 7.4/10.1, Access Manager Administration 7.4,IBM Cognos Business Insight Advanced, IBM Cognos Configuration, IBM Cognos Lifecycle Manager, TOAD for Oracle 8.6, IIS 7.0. Oracle 11g, SQL, PL/SQL 11.1

Confidential, Nashville, TN

Cognos Developer

Responsibilities:

• Developed and Deployed Cognos reports, packages and other Cognos objects from Dev to QA and then from QA to production environments.
• Involved inadministrationof Cognos Reports and models by applying the security settings at the data and user level using the Cognos portal.
• Worked as a business analyst to gather requirements from various users and converted them to technical requirements to develop reports.
• Developed Cognos Reports using Report Studio, Query Studio and analysis Studio.
• Used Html Items from tool box and embedded Java scripts to achieve advanced functionality in Cognos prompts and calendar prompts
• Used Business Insight and Advanced Business Insight for creating dynamic dashboards in Cognos 10
• Used Advanced features of Cognos 10 like Enhanced Search, Collaboration, Offline Capability for creating Active Reports, etc.
• Used Java scripts to embed inside report as HTML items to achieve different functionality in Cognos reports.
• Implemented data level, object level and package level security in framework manager to achieve highly complex security standards.
• Attended Cognos 10 workshops and training on upgrade from Cognos 8 to Cognos 10.
• Was partly involved in building the data warehouse using PL/SQL packages and stored procedures.
• Created and performed testing strategy and test plans for any changes/upgrade to Cognos Reports.
• Implemented role based security to allow users to view reports and data based on their login.

Environment: COGNOS REPORT NET Framework Manager1.1, Report Studio1.1, COGNOS Connection1.1, COGNOS Configuration 1.1, Cognos 8.4 Suite, Oracle 10g, SAPBW, SQL, PLSQL, AQT, Powerplay Transformer 7.1/7.3, Quest Central, Powerplay Enterprise Server Administration, Eclipse IDE.

Confidential

SQL Analyst

Responsibilities:

• Work wif business users and development leads to analyze, understand and document existing systems and Data.
• Prepare MDR documents and Database Design documents and review it wif the Architecture team.
• Develop and modified PL/SQL objects such as Packages, Procedures, functions, triggers to retrieve data from the new centralized ODS.
• Create external tables based on flat files and use them to load data into the final target tables.
• Create and modify UNIX shell scripts (and SQL Loader control files) dat load data from other systems into Chase schemas, for operational reporting.
• Performance tuning procedures/Queries (taking more than expected times) using Oracle DBMS PROFILER, SQL Trace and DBMS XPLAN.
• Develop UNIX shell scripts (ksh) to implement event wait-like functionality to wait on load status table entries instead of an event wait file. (for Informatica - based workflows)
• Made use of PL/SQL functions such as Bulk Collect and SQL constructs such as append hints, parallel loads to implement faster loads to meet data load SLAs in place.
• Troubleshoot and fix any production support issues.
• Tune long running jobs using job run logs and historical times.

Environment: Oracle 9i, Java (JSPs), UNIX, Citrix, PL/SQL