Career Objective:

Seeking a challenging position with a progressive organization which will utilize my technical skills, experience, abilities and education providing me with an opportunity to learn for continuous professional growth achieving
the goals of the organization.

Summary:

• Six plus years of total experience in managing, architecture/design, modeling, development and testing of database/data warehouse applications.
• Five years of data warehousing experience using Cognos 10, 8.3, 7.3 versions ,Cognos ReportNet, Impromptu, Power Play, Transformer, Impromptu Web Reports (IWR), Upfront, Power Prompts, Visualizer, Cognos Query, Architect, Powerplay Enterprise Server, Cognos Decision Stream, Framework manager, Transformer, Report Studio, Analysis studio, Query Studio, Cognos EP.
• Extensive knowledge of Medical solutions, insurance claims, Hospital Software, and recruiting methodologies both at corporate level and Small industry level on Clinical and financial applications.
• Thorough understanding of System Development Life Cycle (SDLC) experience from requirement analysis through Design, Development and Deployment.
• Strong experience in installation, configuration, monitoring and management of Cognos (Cognos 8 and ReportNet) on Windows platform.
• Six plus years of Experience in Database coding using ETL tools, data mining techniques, installing, configuring, managing, monitoring and troubleshooting SQL Server 2000, 2005 and 2008, MY SQL and Oracle 10 series databases.
• Experience in upgrading Cognos environments, conversion of Crystal reports to Cognos reports.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Experience with T-SQL/PL/SQL scripts, complex join queries, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough understanding of indices and statistics.
• Extensive knowledge in SSAS, SSRS, SSIS, Tuning SQL queries, PL/SQL queries & improving the performance of the Database.
• Good Business and System analysis skills to understand the business requirements and transform them to database requirements to customize and develop new reporting applications using Report Studio, Analysis Studio and Query Studio.
• Expert in studying the system data flow and redesigning the database architecture by understanding the business requirements and then converting them to database definitions.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Experienced with Client Interaction, Providing Technical Support and Knowledge Transfers

Education:

• Masters in Computer Science

Technical Skills:

BI Tools:

Cognos ReportNet, Powerplay, Impromptu, Transformer , Upfront, Frame work Manager, Report Studio, Analysis Studio, Query Studio, Cognos EP, Data Manager, Crystal Reports, SSIS, and SSAS.

ETL Tools:

Cognos Decision Stream and Cognos Data manager.

Programming:

Visual Basic, Java, C, Pro*C, TSQL, PLSQL, and C++.

Internet Technologies:

HTML 4.0, VB.NET, JavaScript, and ASP.

Data Modeling:

Visio 2003, Erwin

Front End:

Developer 2000, Visual Interdev, and Visual Basic.

Healthcare Systems:

Siemens Soarian System, Webcare 3, Webcare 2, Care 5.

Databases:

SQL Server 98,2000, 2005 and 2008,Oracle 10 series, MS-Access, MY SQL

Operating Systems :

Windows 9x/Me/2000/XP/Vista and Windows 7, Macintosh, Fedora,

Experience:

Responsibilities

• Responsible for requirements gathering, data mapping, designing, developing and maintenance of enterprise applications for the company
• Led companywide BI Strategy for CDI Corporation. Leading a team of 4 Report developers and 1 DBA/ ETL developer.
• Mentored and trained developers and business users in Cognos Reporting methodologies and in best data warehousing practices.
• Reported directly toDirector-BI, Director-IT and VP Strategy to deliver and formulate reporting strategies for different level of Data Users from uppermanagement to business users and customers.
• Involved in developing reports for wider audience ranging from CFO, CEO, VP, Payroll administrators and recruiters.
• Developed Dashboard, score card applications, financial and Work flow functional reports using Cognos report studio and Analysis Studio.
• Developed FM model packages for Query Studio Adhoc reporting.
• Used advanced MDX functions, graphs for complex financial reporting.
• Developed Complex ETL code through Data manager to design BI related Cubes for data analysis at corporate level.
• Comprehensive analysis of the financial data and resolving variances found in the reports compared against source databases.
• Coordinating with Database team in setting up the required Materialized views, Aggregated and De-Normalized tables for the Reporting and Analysis needs.
• Logging Support cases with Cognos and follow-ups.
• Created Cognos training, setup documents and trained business users.
• Tested the Report/Cube Performances, Security, Batch Process, Report schedules in Cognos 8.3 environment.
• Gathered business requirements from the power users and designed the Reports based on requirements.
• Mentored and trained developers / power users to achieve time-critical BI deliverables.
• Used advanced DMR techniques to enable Drill-up and Drill-Down ability on all reporting attributes.
• Created Database Objects including Views and Stored Procs for Data Transformation to and Querying the Reporting Database using T-SQL
• Scheduled reports, maintained public and individual folders, user groups and roles using Cognos Connection in Report Studio.
• Generated and maintained the Data Dictionary/ Report Definitions
• Performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Upgraded Cognos 7.3 environment to Cognos 8.3 environment and responsible for applying up to date Cognos service packs.
• Setting Data and Object security, giving access permission to objects and Packages. Created folders, Embedded and Standalone filters, prompts and complex calculations in Framework Manager.
• Converted Crystal reports to Cognos 8.3 reports.
• Tuned Reports and Metadata Models for Efficient and faster reporting
• Designed and developed Cognos EP models and Cubes.
• Used MS Project for resource planning and status reporting.
• Created drill through and linked reports from Measures to Organization based child based on the organization or Link on the measure.
• Extensively worked on the Conditional Formatting of the reports using the Render and Conditional Variables.
• Provided functionality and gap analyses for the legacy and new Reporting environments.
• Maintained requirement Traceability Matrix throughout the project.
• Used advanced DMR techniques to enable drill-up and drill-down ability on all reporting attributes.
• Fine tuned the scope based business user feedback
• Formulated ETL processes to Extract Data from Operations DB to the Reporting DWH.
• Coded and implemented PL/SQL packages to perform application security and batch job scheduling.
• Came up with standards for naming conventions of cognos folders, reports, packages, cubes, transformer models etc.
• Tracking all reporting defects in Mercury Quality center along with their resolution are delivered in time based on the priority.

Confidential,Pennsylvania, USA. September 2007 – October 2008

Responsibilities

• Provided technical leadership to design and optimize database structures, Business Processes and ETL, Report development for a proper resource utilization and end user experience.
• Interacted with the users for understanding and gathering business requirements.
• Involved in the analysis, design, develop, testing, deployment and user training of analytical &transactional reporting system.
• Creation of daily, weekly, monthly and yearly reports for submission to Insurance companies, state departments and counties.
• Analyzing EDI billing files thorough Claredi.
• Generating EDI files with the help of WebCare medical software for submission of insurance claims.
• Interacting with the End users at hospitals on a regular basis for resolving issues pertaining to the reports
• Design and Developed the Framework Manager models and Published into server.
• Setting Data and Object security, giving access permission to objects and Packages.
• Created folders, Embedded and Standalone filters, prompts and complex calculations in Framework Manager.
• Created User Groups, Roles in Cognos Connection to implement the Security Filters in Framework Manager Model.
• Created Dashboard reports and score card applications for business users and internal reporting.
• Gained extensive knowledge on complete medical software implementation on both clinical and financial modules.
• Creating new databases, restoring databases, backing up of databases.
• Involved in setting up the Security to Cognos FM packages, Folders and Reports in Cognos Connection by granting up Read, Write, Execute and Traverse Permissions based on user requirements.
• Formulated and designed Packages and Reports per business requirements.
• Data–Mapping / functionality analysis to determine the scope and migration of Reports.
• Configure, support, and maintain SQL Reporting / Cognos ReportNet servers.
• Provide training and technical assistance to junior associates.
• Created Tabbed / Hide-Show reports based on HTML Tags using Jscript coding.
• Created drill through and linked reports from Measures to Organization based child based on the organization or Link on the measure.
• Extensively worked on the Conditional Formatting of the reports using the Render and Conditional Variables.
• Involved in the Cognos 8.3 Administration like Creating Datasource Connections, Publishing Powerplay cubes to the server as a Package and Publishing FM Packages and Assigning the security for Business User Community and also Deployment of Packages and reports from Development to Production Servers
• Customized Cognos Connection portal as per company requirements.
• Created Training documents and involved in training the Power Business Users.
• Collected Business Requirements from the Power Users for BI Reporting Design.
• Worked on Data conversion activities and all levels of testing
• Designed Reporting Datawarehouse based on User Requirements
• Formulated ETL processes to Extract Data from Operations DB to the Reporting DWH.
• Created Database Objects - Views and Stored Procedures using SQL coding

Responsibilities

• Led BI Strategy for the whole company from training of power users to collaborating with business leaders for optimal methodology development for data- capture and Reporting.
• Work with Business Units to define Business strategy and create a centralized reporting capability for users to perform analytical, and ad-hoc reporting for business applications and provide accurate information available to Decision Makers.
• Modeling and comparing databases and their versions using ERWIN.
• Creating, restoring and taking backups of hospital databases.
• Comparing two databases and preparing reports about the differences using the Data base compare tool designed using VB
• Creating various data models for different versions of Soarian software and interacting with Soarian customers on support issues.
• Tuned Reports and Metadata Models for Efficient and faster reporting
• Formulated and designed Packages and Reports per business requirements.
• Developed / tested Oracle PL/SQL procedures, functions, triggers for Oracle 9i / 10g.
• Data – Mapping & functionality analyses to evaluate the scope and migration of Reports.
• Configured and supported SQL Reporting, Cognos servers, and online BI applications.
• Worked with both 3rd level and 2nd level support teams for support issues on Soarian product.
• Unit testing, Functional testing and integration testing for various database upgrades for hospitals from SQL server 2000 to SQL server 2005.
• Used SSIS, SSRS and SSAS modules from SQL server 2005 to analyzing, estimating, migrating and reporting business needs of Soarian medical software for hospitals.
• Developed various complex and customized (Inserting tables and Blocks) reports using prompts like value prompt, Tree prompt, date prompt, type in, cascading prompt, Select & Search Prompt and using conditional formatting as well.
• Assisted in design, development and tuning for Reports and dashboards.
• Provide training and technical assistance to junior associates.
• Customized Cognos Connection portals as per the country of business usage.
• Created Training documents/ trained Report Authors and Power Business Users.
• Creating the database, tables, tablespaces, and data objects.
• Unix Shell scripting in csh, ksh for automating startup/shutdown of databases
• Database Sizing, Tablespace Management, and Security Administration for SQL server databases.

Research and Teaching assistant
Responsibilities:

• Maintenance of the students grading database.
• Adding new reporting features to the “Blackboard” interface.
• Worked on Unmanned Air vehicle research involving development of device drivers for Unmanned Air vehicles (UAV)
• Development of online course contents for users.
• Maintenance of Database security and user administration.
• Taking backup and restoring various databases along with scheduling jobs on servers.
• Grading and Conducting help sessions for the Analog Circuits lab.
• Research activities on courses, organizing and collecting feedback opinions from students.

Responsibilities:

• Installed Cognos Impromptu, Power Play, and Impromptu Web Reports.
• Participated in the development of an enterprise warehouse giving mainstream users the ability to access, analyze and share information in the client’s database.
• Catalog creation and modification Creation of users and changing their profile.
• Created standard filters, calculations, prompts, and conditions in catalog.
• Formulation of joins strategy and adding columns in catalog after they are added in already existing tables.
• Product wise Profitability Analysis, Cash flow Analysis, Outstanding Analysis, Inventory turnover analysis, Profit & Loss Statement Analysis and Variance Reports.
• Interacted with Management to identify key Dimensions and Measures for business performance.
• Designed and created logical Data warehouse models to support strategic decisions.
• Used Informatica and Erwin.
• Created multiple dimensions, Alternate drill through and creating special categories in Transformer.
• Created a multiple layer report providing a comprehensive and detail report with drill through facility to the PowerPlay.