Navleen K. Goraya

**** **** **** ** ***********, VA 220120 C: 404-***-**** ac17qq@r.postjobfree.com:ac17qq@r.postjobfree.com

mailto:ac17qq@r.postjobfree.com

Education & Training

Guru Nanak Dev University, Amritsar, INDIA

Bachelor of Computer Applications

LEARNING TREE, Reston VA

PL/SQL

Arrow Enterprise Computing Solutions, Centennial, CO

IBM Cognos Transformer: Design OLAP Models (V10.1), IBM Cognos Framework Manager: Design Metadata Models (V10.2)

The Festus Group, Houston, TX

Report Studio: Author Professional Reports Fundamentals (V10.2.2)

Report Studio: Author Professional Reports Advanced (V10.2.2)

SKILLS

BI Tools: Cognos 10 BI tools (Report Studio, Analysis Studio, Query Studio, Cognos

Connection, Workspace Advanced Studio, PowerPlay Transformer & FrameWork Manager) • PowerPivot for Microsoft Excel • Familiar to Power Pivot (Excel 2010) • SQL Server Management Studio (SSMS) • SQL ( T/SQL, PL/SQL), ETL programming Data Warehousing experience • Embedded SQL • ODBC • SharePoint • Toad • SQL Server Analysis Services (SSAS)• BIDS • MS Visual Studio • Trilogie

ETL Tool: Trilogie • SQL Server Integration Services (SSIS) • Data Manager (IBM) • Data Transformation Services (DTS)

Team Player, Strong verbal and written communication skills.

Professional Experience:

BI COGNOS Developer

Motivated and ambitious BI Developer with excellent analytical skills and advanced experience using IBM COGNOS, SQL Server 2008 R2, Oracle and Trilogie environments. Capable of leading and working with a team as well as individually. A quick learner who can absorb new ideas and can communicate clearly and effectively.

Skills include:

●5 + years of working experience in Cognos BI tools using Cognos Framework Manager, Report studio, Query studio, Analysis studio, PowerPlay Transformer.

●8+ years of extensive experience in Data enhancements by creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and SQL queries.

●Expertise in Cognos 8.3 and Cognos 10.2.1 and Cognos 10.2.2. BI Suite (framework Manager, Cognos connection, Report Studio, Analysis Studio, Event Studio and Query Studio).

●Strong experience in creating and publishing packages in Framework Manager.

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

●Expertise in Framework Manager Modeling (Physical Layer, Business Layer, Packages), Security, Packages and Complex Report building with Report Studio.

●Strong complex reporting skills – complex Drill-Through, Discontinuous Cross-Tabs, Summary Reports, Burst Reports.

●Very strong T-SQL / troubleshooting skills.

●Strong SQL Server Database development experience with concepts including Stored Procedures, Triggers and Functions.

●With SSIS, worked on multiple sources and destinations like SQL Server, MS Access, SharePoint 2010 lists, Excel 2008/10, Oracle 10g and text files

●Experience in Extraction, Transforming and Loading (ETL) data flows using SSIS and Cognos Data Manager; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities. Also worked on Excel 2010, Power Pivot for providing ad-hoc reporting for the clients

●Has the ability to work in a fast paced environment, good team player and can work independently.

●Strong experience in client interaction and understanding business application, business data flow and data relations from them.

●Involved in a data migration process between different versions of Cognos

●Experience in supporting Very Large databases (VLDB) more than 2TB and troubleshooting the problems.

●Expertise in Microsoft Word, Excel, PowerPoint, Outlook, Access, and Adobe Acrobat.

●Extensive experience of assisting in the development and upgrading of database systems and analytical techniques.

●Conducting internal meetings and providing status reports to the Manager, tracking project SLAs and helping new team members for on-boarding by conducting knowledge transition sessions.

Experience

Ferguson Enterprises

Lead Cognos BI Developer

3/2012 - Present

This company is a diverse wholesale distributor company with operations spanning multiple business groups. The primary objective of the position is to ensure that the informational needs of the business users are being met by the BI System.

Responsibilities:

●Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Drill-Down and Drill-Through Reports.

●Provided training to power users in Analysis Studio and Report Studio.

Worked on performance tuning of existing reports and dashboards.

●Generated Complex reports in Cognos 10.1 report studio including Drill Down reports from DMR modeled Frame work model.

●Created list reports & cross tab reports using Cognos 10.1

●Manually modified the SQL in Report Studio to tune and/or to write complicated reports. Used union/Join objects in Report Studio

●Experience in developing Framework Manager Models and analyzed those models in analysis studio.

●Gathered and analyzed business requirements from users and business community.

●Analyzing existing transactional database schemas to support the users reporting needs and requirements.

●Wrote SQL scripts and developed audit reports to compare warehouse data with the staging and source data.

●Administered Cognos BI Server Environment. Managed Package Migrations and Deployments from one Environment to another. Used some advanced features like Conditional Formatting in Report Studio in generating multipage Reports.

●Responsible for architecting and maintaining 2005 and 2008 SQL Server Analysis Services data cubes.

●Responsible for developing and maintaining SQL Server databases for both transactional and reporting purposes.

●Monitoring production processes i.e. SSIS packages and SQL server jobs to ensure timely and error-free operations.

●Strong understanding of relational database concepts - data modeling (dimensional/snowflake), SQL, query optimization, data warehouse architecture.

●Extracted data from Oracle and migrated into SQL Server 2008 R2 using SSIS.

●Design, develop, and maintain Oracle aggregates and reporting structures. Maintain and analyze users, schemas, and grants permissions to maintain security of the applications.

●Ensuring the data quality of the data warehouse with thorough testing and research.

●Build Cognos Data Manager Job streams.

●Assist in development of Cognos systems and processes to provide advanced reporting to business users Test and tune applications and objects to provide optimum performance.

Northside Hospital, GA

SQL Server Developer

8/2009 – 3/2012

The Northside Hospital System comprises three not-for-profit, full-service community hospitals. With more than 2,500 physicians (the largest medical staff in the Southeast) and over 7,000 employees, Northside Hospital manages more than 700,000 patient visits annually.

Responsibilities:

●Obtained data from various sources and utilized computer applications for the assessments.

●Handled the reports and delivered presentations for the management.

●Worked with respective departments to obtain medical record documentation for coding.

●Assisted the HIS Coding Reimbursement/Coordinator in monitoring data for coding compliance.

●Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Hands on experience in trouble shooting database issues.

●Routine Developer/DBA jobs like user permissions, Backups, Restore, and Update statistics, database integrity check and Backup operations.

●Scheduled and maintained routine jobs, tasks, and alerts using SQL Server Agent.

●Implemented automated jobs for Database Backup on a weekly and monthly basis, based on the volatile nature of database tables and indexes.

●Created ad-hoc reports using SQL server Reporting Services (SSRS).

●As part of a team, established security policy using windows domain accounts and implemented a security strategy to protect against threats and attacks.

●Possess excellent communication and interpersonal skills.

● Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.

Amerigroup, Arlington, VA

BI Developer

4/2008 – 7/2009

Amerigroup deals with Medicaid transactions from various hospitals. Medicaid bills are processed according to the HIPPA rules. It processes the various types of transactions related to claims and payments, which are mainly involved in recognizing how the claims should get paid. This project is mainly related to Medicaid claims processing.

Responsibilities:

●Designing, developing and implementing new functionality.

●Analyzed the impact on the reports due to the changes in the Source systems.

●Modified the Framework Manger Models to incorporate the new data elements.

●Designed and developed the reports as per the requirements in Cognos 8.2.

●Developed PowerPlay Cubes for better analysis of the data.

●Published the Cubes to Cognos 8 Analysis Studio using Framework Manager.

●Modified existing reports to incorporate the changes in the Source System.

●Prepared Test cases for report validation.

●Involved in Unit and Integration testing.

●Ensured that the uses of data through reports and queries are accurate. Supported business and system re-engineering and architecture development to define future data needs.

●Served as an organizational consultant on matters relating to databases by providing expertise to assist users in meeting their needs.

●Maintaining the database consistency with DBCC at regular intervals

●Involved in Source Data Analysis, and designing mappings for data extraction from various Databases and Files.

●Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

MD Datacor, Alpharetta, GA

SQL Server Database Administrator

3/2005 – 3/2008

Enhance database performance, perform restores, implement recovery procedures, handled performance tuning and conduct regular system backups. Ensure technical and functional designs meet business requirements.

Responsibilities:

●Handled the database capacity issues, Merge replication and other distributed data issues.

●Helped implementing the database designs, data access, and table maintenance, also developing and validating the database implementation plan.

●Supported the data import/export into the databases and maintained the physical organization/relationships of database objects.

●Implemented database maintenance plan to ensure data integrity. Ensured that the application and any enhancements, interacts efficiently with the database.

●Created SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules, Defaults, user defined data types and functions.

●Developing logical and complex store procedures with low cost effective for business, maintaining and monitoring servers.

●Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

●Used native tools like DATA BASE TUNING ADVISOR, PROFILER, PERFORMANCE MONITOR and ACTIVITY MONITOR for performance tuning.

CERIDIAN, Arlington, VA

Data Analyst

5/2004 – 2/2005

Ceridian is a leading global business services company that helps organizations control costs, save time, optimize their workforce, grow revenue and minimize financial risk.

Responsibilities:

●Analyzed and tracked key financial metrics and operational procedures to foster process improvement.

●Worked in conjunction with the Business Intelligence reporting and Data Warehouse team to develop and implement end-to-end Business Intelligence solutions.

●Understanding business requirements and developing technical design for an entire Data Warehouse/DataMart application to be run in production.

●Guide and direct work to global teams on multiple projects.

●Focused on mining large databases, analyzing complex financial information and interpreting financial and operational data, drawing correlations and making recommendations regarding projects and future business opportunities to the senior leadership team.

●Worked on call 24/7 Support on weekly basis.

*P.S. References are available on request.

Contact this candidate