SUMMARY:

• Extensive experience in Designing, Developing, Implementing and Testing of Business Intelligence Applications
• Strong experience in Cognos 10.1, 10.2, 10.2.2, Cognos Analytics (v11.0.6), Infosphere Datastage V8.7, 9.1, 9.1.2, 11.3 &11.5, Business Objects 6.5/ XI R1/ R2/3.1 and Confidential Report 8.5, 9.0/ X1/ 2008
• Experience in analyzing, planning, designing, testing and Development of BI applications
• Seasoned developer in Buisness Objects/ Confidential Reports/Cognos/Datastage. Highly experienced in Production support role with daily hands on support of production activities including system enhancements, break - fix, requirement gathering and end user support.
• Strong understanding of SQL/PLSQL, Table Joins, conditions, creating DB Functions & Triggers
• Strong on Linux systems and shell scripting.
• Experience in leading a team of developers/offshore, managing their work loads, and coaching them on their work loads and coaching them on their work
• Good understanding of database client/ server configuration on Oracle/DB2
• Very strong in Client/ Server Architecture, Relational Databases (RDBMS), Data Modeling and Design and built the Data warehouse, Data marts using Star Schema for faster and effective querying for the Metadata Management solutions.
• Experienced at Data Architecture, Business and Data Analysis.
• Extensive experience in enhancing the performance/ Tuning of BI Solutions.
• Confidential Suite Wide Administrator. Manage Virtual Supply Management,Contract Management,Sourcing, Supplier Life Cycle Management
• Expert in creating and Managing Contract/Sourcing Templates as per business requirement.
• Expert in Bulk Load Utility to do Bulk Upload. Batch upload & Batch Upload Definition.
• Manage a& Create user/groups in VSM. Granting Permission/Security.
• Create Sourcing Events, offline bidding, managing Template.
• Experience in using Remedy tool for ticketing from SalesForce.com
• Trained users on Confidential Application.
• Expert in Clause Language using ECM Authoring tool.
• Lead, Participated in UAT testing with Business Users as well working in the Product Support.
• Experience in multiple business domains (Health Care, Pharmaceutical, Banking, Contract Management)
• Experience in coaching training & educating power users in the use of business intelligence tools.
• Broad range of mature competencies - creativity, strategy thinking, initiative, team player, coach, organizational sensitivity and resilience.

SKILLS:

RDBMS/ Data Warehousing Tools: Oracle, Toad, SQL Navigator, SQL DeveloperBusiness Objects,6.5XI/XIR2/3.1 Web Intelligence,Designer,Infoview,Desktop Intelligence, Confidential reports9,XI R2, Confidential 2008,TrackWise, Clear Case, Documentum,Translation Manager,Import Wizard,XLIFF,AccurevConfidential Infosohere Datastage Cognos Framework Manager, Report Studio,Query Studio, Event Studio Active Reports, Workspace & Workspace Advanced, Cognos Analytics

Languages/ Tools: PL/SQL, SQL, Functions, Triggers

Operating Systems: Windows 95/ 98/ NT/ 2000/ XP, Windows 2008/2012/Linux

EXPERIENCE:

Confidential

Administrator/Developer

Responsibilities:

• Create and Manage users/groups in Confidential Virtual Supply Master(VSM)
• Gathered requirement and worked closely with users.
• Configured Webservices in VSM
• Worked on Integertation of Confidential products with IIB middleware with Sterling Order management & Websphere Commerce
• Create Batch Upload/Definition to upload users/groups/Suppliers
• Create Suppliers in VSM and Master the suppliers
• Create Contract/Clause Templates in Contract Management as per business requirement.
• Worked on Data Transport utillty to migrate contents from Test to QA to Production
• Worked on Bulk Load Utility to upload BTVs/Contracts/Supplier
• Created Permission/user group permission using Security Manager
• Upload Lines/Catalog into Contracts.
• Create Custom BTV’s in the system to be used in the Contract language.
• Worked with user on how to use Third Party E-signatures(DocuSign). Configure in the Confidential Application
• Created Approval Groups/Rules while presenting/Executing Contracts
• Proficient in ECM authoring tool for using MS Word used in the clause language.
• Worked on Integeration of Confidential with other Confidential technologies( Confidential Websphere Commerce/Sterling Order Management.
• Create Registration/Assessment/Performance Scorecard Templates in Supplier Lifecycle Management(SLM). Helped end users to onboard Suppliers in SLM via Invited/Self Registration.
• Create and Manage Sourcing Templates for RFP/RFI
• Help users/supplier to do offline bidding. Import/Export of RFx Events
• Create Questions/Questionairre for an RFx Templates.
• Installed/Upgraded & Apply patches Confidential Infosphere Datastage (ETL) and Cognos Anaytics.
• Installed DB2 Client and configured on Linux servers.
• Configured MS access DB connection with third party tools with Confidential infosphere Datastage.
• Installed & Maintained Congos Server on linux with Confidential HTTP Server.
• Configured the Cognos Landing Page using HTML& JavaScript.
• Configured Audit database for reporting
• Created Custom Themes/Extension/Views
• Configured custom roles/capabilities within cognos for security
• Hands on experience with Content Manager utilities to trouble shoot/query Content Manager
• Installed DB2 client and cataloged different DB for Source and Target connection
• Create Cognos Report based on User Requirement.
• Proficient in Linux, created cron jobs to sftp files to other servers
• Train power users in Confidential Application and Cognos Reporting.
• Created Cognos Dashboards/Reports for business
• Implement Cognos security at the user groups and folder level.
• Modify Cognos Framework Model for new changes.
• Wrote SQL queries in SQL tool(SQL Developer) to troubleshoot data quality issues
• Expert in Troubleshooting Skills.

Confidential

Software Advisory Engineer

Responsibilities:

• Developed Complex List Reports, Active Reports, Cross tab Reports, Chart Reports, Confidential -Through, Master-Detail Reports using Framework Model and Complex SQL
• Developed Dashboards to present critical company data in a single report for E360.
• Manually modified the SQL in ReportStudio to tune and/or to write complicated reports. Used union/Join objects in ReportStudio
• Developed Framework Manager Models on Oracle and DB2 for Contract Management Reporting
• Developed FM model for report studio developers
• Created CPF (Project files) and Published projects from the FM Models
• Created Query subjects, query items, Filters, Namespaces
• Handled Complex Queries as separate Query Subjects
• Closely Involved in Requirement gathering and Analysis with the Product Management.
• Used some advanced features like Conditional Formatting/Multilanguage in Report Studio
• Hands on experience on Using Globlization Tool to translate reports and Model in different Languages
• Installed and Maintained Confidential Cognos Business Intelligence Server ( 10.1/10.2/10.2.1/10.2.2/ Cognos 11) on Windows and Linux
• Did upgrade of the Servers and migrated reports/Content Store. Apply Fix Packs
• Hands on Experiencce in Confidential Cognos Support Ticketing System
• Extensive experience in Security Administration based along with Custom Java Authentication Provider(CJAP)
• Implemented Security for Data access, Object level access and Package access in the Framework
• Used Cognos Adminstration extensively for organizing, security, scheduling and distributing reports

ETL EXPERIENCE

• Analyzed, designed, developed, implemented and maintained Parallel jobs using Confidential info sphere Data stage based on best practices
• Involved in design, source to target mappings using DataStage Designer.
• Involved in design of dimensional data model for Data warehose used for Reporting
• Experienced in developing parallel jobs using various Development/debug stages (Peek stage, Row generator stage, Column generator stage) and processing stages (Aggregator, Change Capture, Transformer, Filter, Sort & Merge, Join,Funnel, Remove Duplicate Stage, Flat File stage, DataSet stage, LookUp File Stage, Sequential file stage.)
• Deployed different partitioning methods like Hash by column, Round Robin, Entire, Modulus, and Range for performance boost
• Controlled jobs execution using sequencer, used notification activity to send email alerts.
• Used the ETL Data Stage Director to schedule and running the jobs, testing and debugging its components & monitoring performance statistics
• Scheduled ETL jobs using Windows Task Scheduler and Cron tab for Linux
• Worked on DataStage Designer,Administrator Client, Web Console and Director.
• Use DataStage and QualityStage Operations Database (DSODB) to monitor Jobs, CPU & Resource Usage
• Installed/Upgrade Confidential Infosphere Datastage V 8.7, 9.1, 9.1.2, 11.3 and 11.5. Applied Fix packs
• Worked with the team to design a Job which Java Integration Stage to publish the Cognos Framework Model dynamically onto the Congos Server
• Windows Performance Tuning and applied MKS Patch

Environment: BI Congos 10.1/10.2/10.2.1/10.2.2/ Cognos Analytics(V11), Confidential Infosphere Datastage 8.7,9.1,9.1.2,11.3 &11.5

ConfidentiaL, Burlington, MA

Business Objects Administrator/Developer

Responsibilities:

• Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Directly coordinating with user to gather the new requirements
• Installed BOXI Enterprise 3.1 sp3
• Created User and Group through Confidential .
• Working with Business Analysts, Security Team and SAP OEM team
• Designed the Universe for Confidential Contract Management
• Provided the security access management by creating users/groups and folders.
• Creation of universe connections
• Building the new universes as per the user requirements by identifying the required tables from Data mart and by defining the universe connections.
• Created BIAR file for exporting the objects to be used in different environment.
• Troubleshooted Translation Issues for various languages.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Used Derived tables to create the universe for best performance, and use context and alias tables to solve the loops in Universe
• Training end users how to create Adhoc reports.
• Installed fix patches for BOXI3.1
• Creating universe and report user documentation guide for the end users reference.

Environment: Business Object 3.1, Designer, Info view TOAD, Confidential, Oracle 10g, Confidential Reports 20008,Translation Manager, SQL Developer, Import Wizard, Accurev, XLIFF

Confidential

Business Objects Developer

Responsibilities:

• Modifying the Existing Universes by adding new objects,changing joins,modifying the contexts,optimizing the universe.
• Creating new and modifiying reports.
• Unit Testing the reports by using Toad.
• Interacting with the Business Analyst to get the requirement.
• Helping end users to develop adhoc reports.

Environment: Business Object XIR2, Designer, Info view TOAD, Confidential, Oracle 10g,Oracle ERP.

Confidential, Tampa, FL

Application Programmer Lead

Responsibilities:

• Automated distribution and scheduling of BO report to public folder in different format by using BO SDK and command line program
• Worked on various reports Cross Tab Reports and Parameterized Reports
• Interacted with Operational Users, to gather requirements and delegate to offshore
• Developed Design document based on report requirement.
• Worked on and monthly and Quarterly Rolling trend reports

Environment: Business Object XIR2, Designer, Info view TOAD, Sybase IQ, Confidential, Query builder, Eclipse, Virtual Ticket MQC, BO SDK

Confidential

Analyst

Responsibilities:

• Performed a detailed evaluation and assessment of the Confidential - Reporting system
• Identified items such as defects, missing data and universe design issues.
• Provided a set of recommendations that will individually address some of the project issues allowing for the Lilly to choose from this set of recommendations for a Phase 1 delivery plan.
• Fixed the defects by fixing the views in Database and making changes to the universe design as a part of Phase 2.
• Wrote an SQL to show data missing the database which was lost during the archiving program
• Performed system testing. Made recommendation to the client for future changes to their existing system.

Environment: Business Object 6.5, Designer, Desktop Intelligence, Info view TOAD, SharePoint, Confidential

Confidential

Business Object Developer/ Program Analyst

Responsibilities:

• Developed different kinds of reports related to Complaint, Investigation Audit, Event and Review Management using Confidential XI. Created technical design documentation of the report
• Created source code for Reports based on requirements documentation provided by Eli-Lilly & Company.
• Complete and provide verification of unit testing by running SQL Query.
• Correct defects found as a result of source code not performing the intended functionality
• Extensively worked on Parent/ Child relationship using Subreport. Also developed Cross Tab reports.
• Extensively worked on section level suppression logic based on conditions.
• Developed Single record and Multi record for Trackwise application by creating groups, sorting complex formulas, parameters and using flex fields.
• Extensively developed reports eliminating views because of maintenance issues
• Helped to modify Sales and Distribution Universe.
• Developed new WEBI reports for CIRE(Complaints Integrated Reporting Environment.),using custom built variables, parameters, conditional objects and calculation contexts, charts and crosstab
• Developed cross tab report in Confidential . Converted PL/SQL Queries into WEBI report.
• Help QA tester to test the reports and universe.

Environment: Business ObjectsXIR2, Confidential Xi, TOAD, SQL Navigator, SQL Developer, Track wise, Clear Case, Documentum

Confidential, Philadelphia, PA

Business Objects Developer/ Report Analyst

Responsibilities:

• Created Complex Universe in BOXiR2 involving 1250 objects for creating WEBI reports for Hospital Billing, Physician Billing, Registration and Admission Discharge and Transfer.
• Created Complex Confidential 9 and Confidential Xi reports based on EPIC Clarity Database for physician billing hospital billing, service provider
• Created different complex formula for calculations, groupings, sorting and alerter for Confidential reports
• Scheduled Reports in WEBI
• Created different Groups for giving object level and row level security using Confidential and Designer.
• Created security table for giving security to the user and update the table using ETL.
• Build security matrix as per business requirement
• Migrated Confidential clarity reports to BO
• Created different type cross tab reports and templates.
• Done integrated testing of reports
• Actively resolved issues with end-user
• Resolved complex problems dealing with loops, fan traps and chasm traps
• Created complex measures objects as required by end-users.

Environment: Business Objects XiR2, Web Intelligence, Designer, Confidential 9, Confidential Xi, Central Management Console ( Confidential ), TOAD, CVS