SUMMARY:

• Over 17 years experience in software industry having worked for Fortune 500 and Multinational companies which includes Confidential, Confidential, Confidential, Confidential Inc, Confidential, and Confidential . Experienced in implementing large - scale applications with leading technologies in Data warehousing and Business Intelligence. Strong knowledge in reporting tools like Cognos 10, Cognos 8, Cognos Connection, Report Studio, Query Studio, Analysis Studio, Event Studio, ReportNet, Framework Manager, Impromptu, Impromptu Web reports (IWR), PowerPlay, Transformer, Access Manager, Upfront, Business Objects.
• Experience working with ETL tools like Informatica Power Center and Data Modeling tools like ERWIN (Star and Snowflake Schema), Power Designer 9.0. Involved in complete software development life cycle (SDLC). Experience working with Argus Suite for Global Safety Compliance System (GSCS) and Global Safety Signal Detection & Alerts System (GSDA). Excellent interpersonal and communication skills along with exceptional teamwork experience gained in multicultural organizations. Member of Project Management Institute (PMI) and an active member of the discussion group at www.ITtoolbox.com .

TECHNICAL SKILLS:

Operating System/Methodologies & Technologies/Mainframe: Windows (Vista/XP/NT/2000) Object Oriented Programming Techniques AS400 TSO Unix (Sun Solaris / AIX) Client Server Technology CLICS CICS Red Hat Linux MS - DOS Multithreading, Multitasking

Data Modeling ToolsProgramming Languages: PMI PMBOK Suntone Power Designer 9.0 Cognos Framework Manager C, C++, VC++ SQL,PL\ SQL Rational RUP ISO 9000 6 Sigma Erwin 4.1 Cognos Architect Cobol, CICS Perl

OOAD Tools/ETL Tools: Java JSP, J2EE Rational Rose WSAD Informatica PowerCenter 7.1 Unix Shell Scripting Front Page Ultra Edit Oracle Warehouse Builder

Application Servers/Network: Cognos Decision Stream 6.5 \ Data Manager IIS JRun VPN(Virtual Private Network)

ORDBMS / Database Tool: IBM WebSphere 4.0 Microsoft Active Directory Server TCP/IP SSO MSSQL Server Oracle 9i \ 10g BEA Weblogic 5.1 iPlanet Troubleshooting/ Configuration Sybase Toad Microsoft Access Cognos Enterprise Server Firewall Setup DB2 UDB 6 .1 Carisma

Web Technologies/OLAP Tools/Reporting Tools: HTML DHTML XML Cognos PowerPlay Transformer OLAP Modeling Transformer Unix Cognos 10 / Cognos10.2.2 Cognos 8.1/8.2/8.4 Report Studio Query Studio Analysis Studio Java Script ASP PowerPlay Enterprise Server Administration Putty Event Studio Cognos Connection Visual Basic 6.0 Groupware Access Manager Administration Humming Bird Impromptu Advanced Report Building Sametime MS Project Upfront Administration Impromptu Web reports (IWR) Adobe Suites Lotus Notes Business Objects 6.0 PowerPlay Data Exploration for Client Impromptu Administration Visio Outlook Informix (ROLAP) Crystal Reports PowerPlay Report Building 7.0 Impromptu report Builder 7.0 Cognos NoticeCast Crystal Enterprise 8.0 Cognos Visualizer Cognos ReportNet ITIL Tools Collaboration, Document Management Project Management Test Management Tool Customer Relationship Management Service Desk Microsoft SharePoint EDM Teams (Enterprise Data Management) Plan View Confidential ALM (Application Lifecycle Management) Siebel ISM ServiceNow Microsoft Project CRM

PROFESSIONAL EXPERIENCE:

Confidential

Lead Business Systems Administrator

Responsibilities:

• Analyzed business processes ensuring best practices were captured and implemented consistently.
• Provide outputs from global safety database in support of audits and inspection.
• Development and maintenance of technical solutions to support safety database and data extraction.
• Defined data requirements and report layouts for the business to review. Created testing plans and scripts based on requirements.
• Use Cognos suite of products for Data Analysis of the Serious Adverse Events (SAE) using Argus Insight Standard Reports and Custom Designed Reports.
• Authored various types of reports in Report Studio using dimensional and relational data sources.
• Created Ad-hoc reports using Query Studio.
• Developed custom reports to analyze financial, operating, and billing processes.
• Build business dashboards to conduct trend analysis on retail metrics.
• Gather and understand business requirements and translate into IT solutions with the use of Cognos.
• Worked closely with the project management team to analyze and consolidate request requirements to improve the decision planning process and meeting project deadlines.
• Applied technical skills using Oracle PL/SQL in data collection, data analysis and reporting to procure data from database structures to report and provide solutions to client requests in a timely manner.
• Created and delivered presentations to various business teams regarding the current status and key decisions regarding their business issues.
• Worked on performance tuning of existing reports and dashboards.
• Facilitated the transition to IT-supported Business Intelligence Data Mart.
• Facilitated Cognos 10.2.1 to 10.2.2 upgrade. Was involved in installation, configuration, migration and testing of all objects in multiple environments.
• Supported rapid turnaround for ad-hoc analysis, developed use cases, researched and resolved issues.
• Performed Cognos administrative tasks including security, user accounts, software installations and deployments.
• Developed numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.
• Managed Level 1 support for day to day operations and issue of Enterprise Data Warehouse.
• Established an audit reporting system for the internal team to monitor, analyze performance and usage of different reports and other objects.
• Worked with power users and IT teams to understand business logic behind each report, and identified all end users.
• Collaborated on a compatibility assessments to conclude level of effort required in software/application migration.
• Used Confidential ALM Test managementtoolto manage requirements, test cases, test plan, defects and reports and create Test scripts.
• Managed Service Request, Incidents and Changes using ISM ServiceNow.
• Involved in unit testing and UAT Support.
• Facilitated design and Implementation of metadata models in Cognos Framework Manager.
• Trained various business unit teams on the effective use of processes, tools, and resources.
• Created effective materials, conducted one-on-one, live group, and WebEx .
• Implemented report bursting to distribute reports effectively.
• Used Cognos Event Studio to manage report runs and notifications.
• Configuration and maintenance of user access, Regulatory Reporting Matrix, study, product and license, code lists and narrative/cover letter templates, end of study unblinding, Perceptive Alerts, creation of queries and scheduling of Insight reports.
• Responsible for generating multiple types of safety data extracts and reports. These include a number of different periodic safety reports, aggregate reports submitted to agencies worldwide and outputs for data monitoring committees, clinical study reports, therapeutic area safety teams, and investigator brochures.
• Documented all the procedures and test cases validation.
• Collaborate and manage documents on SharePoint. Managed SCP (Safety Compliance Platform) portal creating and updating pages timely.
• Create, maintain and share documents using Enterprise Data Management (EDM Team) tool. Involved in creating, importing, editing, distributing, reviewing, versioning, securing documents associated with specific Workgroup's.

Confidential

Cognos Lead

Responsibilities:

• Onsite-offshore coordination, Project Management, Client management.
• Developing Cognos Web Dashboard reports and Excel macros to support sales reporting and its business units like Corporate Accounts (CA),Oncology Business Unit (OBU),Inflammation Business Unit (IBU),Nephrology Business Unit (NBU),Bone Health Business Unit(BHBU).
• Involved in KTLO (Keeping The Lights On) support and Analysis of Source to Target mapping to resolve Severity1 and Severity2 Tickets and meet the SLA.
• Responsible for SQL/Data analysis and bug fixing.
• Leading Semester development activities. Creating Project Plan and resource management to deliver the Service Request on time.
• Performing Code Review and UAT on Cognos and VBA development.
• Coordinate and participate in the QA process, User Acceptance Testing, delivery of version upgrades and the implementation of new modules.
• System support and issue resolution - Provide escalation support, analyze issues, determine root cause, and provide solutions to resolve. Provide support and assistance to other IT team members.
• Experience using tools like ISM (Incident Management, Problem Management, Change Management), LMS, SharePoint etc
• Proactively consult, collaborate and communicate with clients to analyze functional and technical opportunities and challenges.
• Document and Design Business Requirement and System Specification.
• Work with clients to anticipate and minimize the impact of change on individuals and departments.
• Participate in creating architecture diagrams and system context diagrams that can be understood and used by business users and ITteam members.
• Business process models, use cases, use case diagrams, scenarios, business rules, reports design, and user interface visualizations.

Confidential

IT Business Analyst

Responsibilities:

• Responsible for development of Cognos reports for Governance and Change Management using Cognos 8, Report Studio, and Query Studio.
• Responsible for gathering report requirements, creating functional specifications and report rationalization.
• Worked as a Project Manager for Cognos Server Upgrade Project. Which involved scoping the project, resource planning, coordination with  Designing AID (Application Interface Diagram) and TAD (Technical Architecture Diagram) to set up new servers for Cognos development and production environment and upgrading to Cognos 8.2 and later on to Cognos 8.3
• Managed the Data Source (CA - Service Desk) upgrade project. I was responsible to ensure smooth transition of Cognos reports, Cognos framework manager models and security objects to the new version of Service Desk (a CA tool which was the Data Source).
• Developed List and Crosstab Reports for core and non-core production activity in different time zones.
• Prepared user manual for Confidential Self-service portal to access IT Ops and Analytics reporting.
• Build Data Models and Packages using Cognos Framework Manager for service desk, scorecard reporting etc.
• Used Oracle DDL to define database structure or schema.
• Used Oracle DML for managing data within schema objects.
• Created calculated columns for Open Date, Close Date, and Resolve Date in different time zones and to display time in specific format.
• Developed report studio report to track the health of the application and impact of Releases on Operational Systems.
• Developed complex Report Studio reports to monitor the 'State Of Production' of Open, Closed and Still Open Problems, Incidents and Request.
• Created crosstab reports, line charts and graphs of Deferred Defects after a Release.
• Developed reports using Conditional Layouts and condition expression like String Variable and Boolean Variable.
• Developed reports for Service desk to identify the root cause for Incident Management and Problem Management. Created reports using Sections for each Root Cause.
• Developed Detail and Summary reports based on management hierarchy with Drill Down and Drill Through capability.
• Developed Cognos reports using Combination Chart and Gauge (To demonstrate Top 5 SLA’s).
• Developed prompted reports using different prompts like Value Prompt, Date and Time prompt etc.
• Created queries in report studio using Join and Union.
• Developed Report Views to organize reports in Cognos connection and to distribute reports based on security.
• Developed reports using Master Detail Relationship.
• Wrote complex Queries and Case statements to design Report Studio reports.
• Developed Executive Dashboard for Self-service reporting using Cognos portal and Cognos Portlet (Cognos Viewer).
• Created Monthly and Weekly IT Ops Business Review Slides using Cognos Office Connection.
• Used Access Manager and Cognos Connection to setup security for domestic and international customers. Setup Groups and Roles in Cognos Connection.
• Schedule Management - Schedule daily, weekly and monthly reports in different formats and output version.
• Developed complex cross tab and list reports for Scheduled and Unscheduled Outages, Weekly Core, Non-Core Applications.
• Managed Incidents, Requests and Problems using ITIL tool like CA’s Service Desk.
• Used CRM software to easily manage customers and contacts.

Confidential

Cognos Developer\Administrator

Responsibilities:

• Central Point of Contact for Cognos Issues. Supporting international as well as domestic customer base.
• Worked as part of a team to support data and reporting needs following business users' requirements, performance and key business indicators.
• Developed Executive Dashboard and Sales Dashboard using CRN.
• Supported different Cognos reporting applications like Project Accounting, Accounts Receivable, Sales, Finance etc
• Business Analysis of daily, weekly and monthly forecast planning for Sales & Marketing, Inventory, Warehouse Management, Market Demand & Availability etc
• Involved in daily scrum meetings for Project management and timely deliverables.
• Designed Framework Manager Models and Packages.
• Administration activities using Cognos Connection for deployment of packages, user security, setting up user groups, schedule management etc.
• Developed user validation reports using Query Studio & Report Studio, Powerplay client, Upfront.
• Bursting reports, event handling, scheduling jobs using CRN.
• Developed Power cubes based on daily\weekly forecast requirement.
• Created Dashboards using Report Studio.
• Used Informatica Power Center to create source flat files for transformer cubes.
• Wrote UNIX shell scripts to build, copy, publish power cubes.
• Worked with Putty client program SSH, Telnet, FTP
• Used Humming Bird Network Connectivity to communicate with UNIX environment.
• Scheduling jobs using UC4
• Tracking user request using System Request Tracking.
• Setting up user class security using Access manager.
• Efficiently interacting with user community to support & development of Cognos Objects.
• Created tables and wrote stored procedures using Oracle DDL and DML

Confidential

Cognos Developer\BA

Responsibilities:

• Extensively worked on understanding the business requirements and designing applications to meet the end user requirements.
• Involved in HR Business analysis. Creating daily\weekly\monthly cubes based on Payroll analysis, Employee Absenteeism, Turnover etc
• Experience working with System Development Life Cycle (SDLC).
• Involved in design, development and maintenance of catalogs, created Impromptu reports, templates, hot files, PDF files, snapshots, drill through, IQDs using Impromptu Administrator.
• Created standard, Cross-tab reports and Free-style reports using Impromptu.
• Created different types of Prompts as per specification.
• Created different joins and views according to specification.
• Created reports using Cognos ReportNet.
• Designed Transformer model, created PowerCube’s, Dimensions, Levels, Measures, Categories, User Classes using PowerPlay Transformer.
• Created Reports using PowerPlay and published to Upfront.
• Created user profiles to control user access, mapping these user classes to the user profiles in Impromptu Web Reports (IWR) Administration.
• Responsible for performance tuning
• Designed and Developed the HTML pages for a user to view data based on Multiple Selection using Impromptu Power Prompts
• Used Access manager administration to setup and maintain, in one central location, secure user access to data such as reports and queries that are created in other cognos applications.
• Worked with Configuration Manager to specify a runtime authentication source (Runtime security).
• Involved in Installation of Cognos tools, configuring access manager, creating .csa and .lae files.
• Provided Basic Signon and Operating System Signon based Authentication to users.
• Used PowerPlay Enterprise - Server Administration to Manage the OLAP environment, deploy cubes and reports for the enterprise, control drill through access, printing and publish settings. Monitor and optimize server performance.
• Worked with Cognos Server Administration to install, upgrade, manage and maintain Cognos components across the organization.
• Experience setting up domain groups and assigning access rights to userids and groups using LDAP software like iPlanet, Microsoft Active Directory, Netscape Directory Server.
• Wrote scripts in Cognos Script Editor to run as un-attended automated process or to run interactively, the scripts are used to.…………….
• Update the Transformer Model with UserClasses from Access Manager.
• Back-up the Transformer Model.
• Update the Target Dimension to use UserClass Custom Views equal to each UserClass.
• Back-up the PowerCubes.
• Update the PowerCube with UserClasses from the Transformer Model
• Generate the PowerCubes.
• Export Impromptu Report result sets as CSV\PDF\Excel\ASCII files.
• Worked with Cognos Scheduler to execute automated task locally and on server, on a set date and time or recurring intervals.
• Also used Transformer Unix to handle large Data Sources, for easier integration of cube builds and Data Warehouse updates, to get increased Performance, for scheduled cube creation, for faster processing and for Production support.
• Involved in documentation of SOP’s (Standard Operating Procedures) and user .

Confidential

Data Warehouse Architect

Responsibilities:

• Involved in the data modeling, starting from gathering the user/ business requirements to designing the data mart, basically Star Schema, with the team of five and under the Data Architect expert.
• Major contribution in the data modeling is to gather information in the development server databases indexes and stored procedures helpful in the data modeling for faster query access.
• Involved in Star Schema design in Erwin 4.1 using logical and physical model type.
• Proficient in Informatica Power Center 6.1, Oracle 9i, PL/SQL.
• Extensively worked on Informatica Tools, Source Analyzer, Warehouse designer,
• Created Informatica mappings with PL/SQL procedures/functions to build business rules to load data. Also tuned for better performance.
• Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units in tables.
• Developed Mapplets using corresponding Source, Targets and Transformations.
• Extensively involved in creating Database triggers, Stored Procedures using PL/SQL.
• Worked on Data Extraction, Data Transformation, Data Loading, Data conversions and Data Analysis.
• Testing applications and Running Batches created in Informatica server manager through job scheduler (Autosys) and also from Informatica server manager.
• Schedule, Run Extraction, Load process and monitor sessions by using Informatica Server manager.
• Responsible for the Designing the universe by creating the Business Objects data model selecting/joining tables, indicating cardinalities, creating aliases to resolve the loops, subdividing into contexts and creating the objects which are grouped into classes.
• Created the reports (Master/Detail, Crosstab, Chart templates and out line reports) in Business objects and Web Intelligence using the universes as the main data provider.
• Used Crystal Enterprise, a Web-based system for reporting, analysis and information delivery.
• Automated report distribution and scheduled reports to run regularly using Crystal Enterprise.
• Created the dimensions & cubes using PowerPlay Transformer.
• Generating various reports using Cognos Impromptu Web Reports (IWR) like Sub Reports, Drill through reports, Cross Tab Reports and implement time Scheduling to reports by Congos Scheduler 6.0.
• There were two kinds of data loading processes (Daily and Weekly) depending on the frequency of source data.
• Extensively used ETL and Informatica to load data from MS SQL Server, MS Access, Excel spreadsheet, ASCII files, DB2, Sybase into the target Oracle 9i database.
• Extracted and transferred Source Data from MS SQL Server into Oracle
• Supported the process steps under development, test and production environment.

Confidential

Systems Analyst

Responsibilities:

• Troubleshoot/ Configure the Network, Internet, Network Printer, and ISDN Modem (Netlinker)
• Technical Support, Managing Customer Care & Way2Talk Modules (Net Telephony).
• Report preparation & Management Presentations.
• Perform operational tasks, password & user setup, viruses & intrusion detection, scripting, etc.
• Troubleshoot network security issues, Firewall installation and administration.
• Incident response planning. Implement disaster recovery plans.
• Troubleshoot/ Configuring Active Directory, DHCP, DNS, LDAP, RAS VPN, IIS, Exchange Mail Platforms etc.
• Understanding and troubleshooting Broadband issues.
• Checking the latency of the sites by tracing.

Confidential

Trainee Analyst

Responsibilities:

• Involved in the following projects as a part of the and professional practice (PP).
• Functional testing of Care Plan and Nursing notes for Accura Technologies using Java (Swing), SQL Server 7.0, win2K.
• Online Web Shoppe for CMC using Visual Basic front end and SQL 7.0 as backend.
• Inventory Control System for the client Family World using C++ front end and Sybase 11.0 backend with DB- libraries.
• Worked on Web Development programming with tools such as Cold Fusion and Java Script.