Sr Business Analyst/ Web Developer

SUMMARY

• Over *+ Years of professional experience in Design, Analysis, Application Development, Data warehousing and Project Life Cycle.

• Strong hands-on experience in Development of SQL Stored procedure and performance tuning in complex data warehouse environments.

• Well-versed in developing reporting applications using Cognos Business Intelligence components like Framework Manager, Query Studio, Report Studio, Analysis Studio, Metrics Studio and Cognos Connection.

• Experience in analyzing the execution plans using the sql server profiler and tweaking the query to improve performance.

• Experience in building Meta data and packages in Cognos.

• 1 year of experience in building data warehouse using Informatica (Powercenter Designer, Workflow Manger, Repository Manager & Workflow Monitor)

• Knowledge on developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts.

• Expertise in understanding existing business processes, data analysis requirements, business systems analysis and design, converting requirements specifications into functional & Technical design documentation.

• Extensively worked on Cognos 8 Framework Manager – Creating Models in Framework Manager – Importing Meta Data from Different Sources, Dimension Hierarchy, Determinants, Star Schema Grouping, and Packages.

• Good experience on developing List, Sub and Cross-Tab reports, prompts, multiple queries and conditional blocks.

• Good understanding of Data Warehouse & Data Mart Architecture, data modeling and DMR modeling using Star Schema and Snow-Flake Schema Methodologies.

• Experienced with Multiple Relational Databases including Oracle and MS SQL Server.

• Experience with SQL Stored Procedures, Functions, Cursors and Triggers.

• Worked with testing team to develop test cases, scenarios and conditions.

• Highly motivated and hardworking individual with penchant for learning new technologies. Excellent communication, leadership, trouble-shooting and motivation skills. Ability to prioritize work based upon continuous new input and changing business needs. Proactive and preventive in problem solving, and ability to deliver high quality results with attention to details.

Technical Skills

BI Tools : Cognos 8.4/8.3/ 8.2 /8.1 (Framework Manager, Query Studio, Report Studio, Analysis Studio, Metrics Manager and Event Studio), Cognos ReportNet 1.1MR3, 1.1MR2(Framework Manager, Report Studio, Query Studio, Cognos Connection) Administration and Security, Cognos Impromptu (7.x and 6.x), Crystal reports 9.0.

Database : MS SQL Server 2000/2005/2008

ETL Tools : Informatica 8.6

Work Experience

Client: iSoft, MA November 2008-till date

Cognos Developer

Lorenzo is one of the world’s advanced software applications for the healthcare sector and is developing the biggest civilian project for the NHS trust, UK which will house data scaling in Terabytes and thousands of users connected concurrently. The products are used by more than 8,000 organizations in 27 countries for managing patient information and driving improvements in healthcare services. Lorenzo Clinicals provides comprehensive facilities to manage all the clinical aspects of Hospital and non-hospital care. It is a clinical information application that can automate care processes, support clinical decision-making and improve the quality of care. Enterprise Data Warehouse is built for data extract & reporting needs. Scheduling of reports, clinical reports are done in Cognos.

Role & Responsibilities:

• Involved in Requirement gathering from Business Users.

• Analyzed the requirements provided by the clients and Developed specification documents for reports as per client requirements

• Created the data sources in Cognos Connection.

• Developed FM Projects and Published Packages in Framework Manager – Installed Framework Manager, connected to different data sources, created database layer, physical layer and presentation layer, defining appropriate relationship between query subjects.

• Implemented Framework Manager Security for Data access, Object level access and Package access.

• Developed DMR Models against the relational sources, Building Regular Dimensions and measured Dimensions, Determinants and attributes for Multi- dimensional reports.

• Review the Technical Design and identify the potential performance bottlenecks at an earlier stage and suggest alternate solution.

• Review the data model and SQL stored procedure during development stage and suggest on performance enhancement.

• Ensure that Lorenzo Clinicals 3.0 product can handle 500 concurrent users with a sample database scaled to 300 GB. This involves Query optimization, Server settings tweaking, File striping across disks.

• Procedures taking over 30 seconds to complete have been brought down to 2 – 3 seconds scale by employing various tuning methodologies.

• Involved in large scale performance tuning exercise and have fixed numerous stored procedures by analyzing the Execution Plans, Statistics IO information, profiler traces etc. and considerably reduced the I/O, CPU cost. This helped in improving the scalability of the Lorenzo applications which will house data in hundred of terabytes.

• Monitor SQL server related counters during Load Runner Run and optimize server performance.

• Prepare Best Practices guidelines based on the experiences gained in Performance Engineering and publish in portal for the benefit of developers.

• Used various transformations like Lookup, Filter, and Expression.

• Experience in developing outbound data extracts for sending the inpatient service provided details to insurance company using informatica.

• Importing metadata using SQL Server database as source and creation of packages for report development in Patient and Managed care subject area.

• Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query reports, Burst Reports against database.

• Creating cross-tab reports and chart reports using multiple queries and drill down capabilities in a single report to meet the business needs.

• Designed & developed multiple reports using various templates like list reports, cross-tab reports and chart reports.

• Developed Dash Board reports, Scorecards, Visual Layouts, Master detail Drill through reports, Drill up and Drill down reports, multiple prompt reports and cascading prompts in Report Studio.

• Implemented different functionalities using report filters, sorting, multiple queries and conditional blocks.

• Created conditional variables to change the graph headers and list column headers based on the user parameter selection.

• Developed security for reports, bursting the report s through cognos connection.

• Interacting with the End users on a regular basis for resolving issues pertaining to the reports.

• Testing reports using review checklists for Quality Assurance before delivering to the end users.

Environment: Cognos 8.1 (Framework Manager, Report Studio, Query Studio, Analysis Studio), Cognos 8.1, SQL server 2005.

Client: Pinnacle USA, Memphis, TN January 2007-November 2008

Team Lead-Database

Pinnacle Airlines was recognized in 2004 as the fastest growing regional airline in the world.Aviation Solution is a Complete ERP Business Package for Aviation Business. Pinnacle Airlines is using Aviation solution for Material management for their procurement and inventory activities. Pinnacle is an air ambulance service provider with 95 aircrafts. Aviation solution tracks the goods receipt, material request and stock management activities for their aircrafts. Purchase order, Inventory management are well maintained in this solution.

Role & Responsibilities:

• Technical Review of the data model and development of SQL stored procedure and performance tuning.

• Involved in large scale performance tuning exercise and have fixed numerous stored procedures by analyzing the Execution Plans, Statistics IO information, profiler traces etc. and considerably reduced the I/O, CPU cost. This helped in improving the scalability of the Ramco ERP applications.

• Monitor SQL server related counters during Load Runner Run and optimize server performance.

• Provided functional training in material management for entry level engineers.

• Involved in the preparation of System Design & Technical Design document for Data Warehouse.

• Used various transformations like Lookup, Filter, router and Expression in Data warehouse built for Aviation application which is the source for Cognos reports.

• Involved in the preparation of System Design, Technical Design document for Cognos report development

• Importing metadata using SQL Server database as source and creation of packages for Pinnacle specific List reports development in Aircraft maintenance, Visit Package, Inventory management, Purchases, Hangar/Component Work Order and Technical Log subject areas.

Environment: SQL server 2005, SQL SERVER 2008 Performance Tuning,optimization,SQL SERVER profiler.

Safe Air, New Zealand August 2006-January 2007

System Analyst

Safe Air is an aviation maintenance, repair, overhaul (MRO), design and manufacturing business with capability for engines, airframes and components. Airframe capability includes Boeing 737, Lockheed C-130 and P-3 Orion plus helicopters. Engine capability includes Rolls Royce T56 and Pratt & Whitney J52. Components include comprehensive propeller repair and overhaul. Safe Air is based in Blenheim, New Zealand and our subsidiary Safe Air Australia, is based in Melbourne. Safe Air is using Aviation solution for Material management for their procurement and inventory activities. The Aviation solution tracks the goods receipt, material request and stock management activities for their aircrafts.

Quick Technical Log is a log for recording the Technical Log with Discrepancy, Component Replacement, Work Information and Material Request .The Material Request helps in recording the part required for the service of aircraft and on generate material request an issue of material in fresh status is created. Shortclose MR is also available.

Role & Responsibilities:

• Development of SQL stored procedure and testing.

• Involved in Load testing using Load Runner and identifying the set of transactions which needs performance improvement and tweaking the stored procedure for performance improvement.

• Involved in the preparation of System Design, Technical Design document for Cognos Reportnet report development.

• Importing metadata using SQL Server database as source and creation of packages for Safe Air specific List/Cross tab reports in Inventory management and Purchases subject areas.

Environment: SQL server 2005, SQL SERVER 2008 Performance Tuning,optimization,SQL SERVER profiler, SQL stored procedures, cursors, triggers, Crystal Reports .

Client: TVS Group, India July 2003-August 2006

System Analyst, Database

Cross selling is giving up loans for the top customers who have successfully completed their previous loans. These are privileged customers who are grouped as AAA, a +, A.

Role & Responsibilities:

• Preparation of functional specification and & technical specification document required for application & reports.

• Development of stored procedure and performance tuning.

• Preparing Logical Design Diagram and Detailed Design Diagram

• Involved in the development of Front end.

• Designing reports as per the requirements.

• Code Writing in SQL SERVER 7.0, Visual Basic 6.0 Involved in Scenario testing for various Purchase and Inventory Sytems.Writing Test Cases for Product Validation Group.

Environment: SQL server 2005 SQL stored procedures, cursors, triggers, VB6.0

Education/Certification

• B.E (Information Technology) from Bharathidasan University, India.

• M.B.A (HR) From IGNOU, New Delhi.

Personal Details

Email : tjx3vj@r.postjobfree.com

Contact: 518-***-****

Contact this candidate