SUMMARY

• Looking for a challenging opportunity as Senior Data and Reporting Systems Analyst in DW/BI with around 15 years of IT Experience, 12 Years of DW/BI and Data Analyst in DW/BI reporting and 9 years of Business Systems Analyst experience with wide variety of Business Industry, BI tools and application software experience.
• Four Incentive Compensation Implementation Experience Including 2 Callidus True Comp and 2 Siebel ICM implementation for AOL, Verizon Information Services, World Savings Bank and Kraft foods.
• Sound Knowledge and Experience in Understanding the Business partner needs and transforming Business Needs in to Reporting Needs. Using ETL, BI Tools and Applications.
• With Strong Background in Data warehouse, Data Analysis, Data Cleansing, ETL development using SSIS, BI tools, Testing, Document Management tools.
• Willing to Learn and Adapt latest tools and Technologies in the current changing Market.
• Extensive background in development on multiple databases. T - SQL (9 years SQL Server, 5 years Oracle PL/SQL, 2 Years in IBM DB2,2 years of Teradata and 2 years of Sybase, 1 year of MySQL and BIG DATA)
• Strong at various Database Join types, SQL Grouping, Use of built-in functions/User defined functions. Modifying/Analyzing existing complex code. Understanding Entity-Relationship and coding using ER diagram. Strong in Figuring out logic from existing code and schemas. (code debug skill).
• Strong data knowledge, assess business needs, elicit and define requirements, develop SQL programming to pull data from multiple systems, and produce data sets, reports and Tableau dashboards.
• Strong Self-starter, flexible, detail oriented, strong communicator, a team-player and able to effectively handle multiple and changing projects/priorities.
• Strong critical thinking and analysis skills, collaboration, meeting facilitation, verbal and written communications, and interpersonal interactions (e.g., partnering, conflict management, consulting, influencing).
• Independent self-starter and able to work collaboratively in a cross-functional team environment.
• Continuous improvement on efficiency, collaboration, and candor, openness, and results oriented
• Strong Knowledge in Gathering requirements from business stakeholders and create new reports. Helping business users to extract transactional data from applications and convert the data to meaningful information USING ETL Tools and BI reporting tools.
• Vast experience in Primary area of expertise and interest in commercial development for the Web development, GUI, Client/Server, RDBMS under Windows NT utilizing strong coding and debugging skills, familiar with OOD/OOP. Strong in BI Reports requirements gathering, SSD, TRD, TSD, Unit Testing and Deployment document creation.
• Strong Experience in extracting data from application tables, developing report prototypes, modifying standard reports, producing/running ad-hoc reports, and automating reports. Strong knowledge working in both OLTP and OLAP data warehouse reporting.
• Skills and Extensive Knowledge on Business Intelligence Reports Development Using Actuate Enterprise Reports, Actuate / BI - XML publisher Developer/Business Objects / Discoverer / Crystal Reports/ Web Focus around 14 years of IT experience including 10 years in DW BI Reports Development which Includes analysis, design, development, testing and technical support of Siebel Analytics (OBIEE), Siebel ICM, Callidus True comp, Siebel CRM, PeopleSoft CRM, Configuration, Actuate erdPro and Actuate eSpreadsheet report (Version 3.0/4.0/5.0/6.0/7.0/8.0/9.0 ).
• Composed in a professional manner and Performed well under pressure.
• Wrote Complex queries in SQL Server to get data from different applications databases.
• Experience in object-oriented design and analysis.

TECHNICAL SKILLS

Application: EPIC CLARITY, IBM TRIRIGA, Siebel CRM 6.3/7.0/7.04/7.5.2/7.5.3/7.8.2/8.0 , Callidus True comp 3.7/4.2, Vantive (People soft CRM), Customized web applications and Siebel ICM 7.8.2

RDBMS: TeraData (NCR), Oracle 10g,9.0, 8.1.6/8.0/7. x, and SQL Server 2005/2000/7.0/6.5

Reporting: Tableau, QlikView, Actuate Developer workbench/ Erdpro designer 3.0/4.2/5.0/6.0/7.0/8.00/9.00 , Actuate eSpreadSheet, Oracle BI publisher with OBIEE, Actuate Admin Desktop, Actuate management Console, Actuate Active Portal, Crystal reports 5.0/8.5/9.0/2008 and Business Objects 5.1

Tracking Systems: Vantive 8.0, Projecttraq, Perforce, Tortoise SVN, Visual Source Safe, Mercury Quality center and Clear case

Document Systems: MS-Share point and Wiki

Web Development: Active Server Pages (ASP.net, ASP 3.0/2.0), Visual Interdev 6.0, Java Script, and VB script, VBA Script, HTML, DHTML, Front Page and XML

Programming/RAD: BIRT, Eclipse IDE Java, Vantive 8.0, Visual Basic 6.0/5.0/4.0, T-SQL, TOAD, Teradata SQL Assistant, PL/SQL and Oracle SQl developer

Operating Systems: Windows XP/ 2003/2000/98/95 , Windows NT, UNIX and MS-DOS

Web Servers: Apache Tomcat and IIS webserver

QA: Mercury Quality center, Clear Case, Siebel e Biz, Serena Dimensions, Perforce, Visual Source Safe, Tortoise SVN

PROFESSIONAL EXPERIENCE

Confidential, CA

Sr. DATA and DW BI Reporting Analyst

Responsibilities:

• Supporting Kaiser Epic System’s suite of Healthcare products as part of Northern California Compliance (NCAL and SCAL), Privacy & Security Office and CERNER Lab System Pilot Project.
• Worked with Cloud Infrastructure Team to setup the SQL server Database 2014 and SQL server Reporting Server with help of SQL server DBS team following Kaisers Policies, Security guidelines and procedures.
• Created Requirement Gathering Documents, Functional Specifications, Technical data mapping, Data Analysis and Different Use case scenarios of validating the data.
• Did lot of data cleansing in Excel, MS Access, SQL server SSIS and Teradata SQL.
• Completed CERNER Lab System - System Activity Review (SAR) Pilot project with Two Use case scenarios of Proactive reporting for Employees who is accessing Same Household member information and Accessing Same Department Employee information of Patient Electronic Medical records in the LAB system.
• In-depth knowledge of the Clarity data model related to Access Log, Employee, Employee address, Member Address, Patient, Member and Encounter related data.
• Worked On Large volume of Teradata Audit Log data, Resolved Complex SQL issues and Given better solutions or the current EPIC Health Connect System Activity review implemented in 6 different regions and Northern California different medical centers.
• Build Pilot reports in Crystal report 2013 and SSRS for CERNER LAB system SAMEHH and SAMEDEPT Use cases.
• Wrote Lot of complex SQL queries in Teradata and SQL server. Migrated large volume data from flat files, Excel, Access and Teradata into SQL server Using SQL server SSIS and Talend SSIS tool.
• Worked on Different Schemas for different types of datasets, given solutions for performance improvements in SQL.
• Ran Monthly NON Kaiser Employee Crystal Reports in BO Info view and On demand manually. Exported the results in Excel and PDF for business users.
• Completed a Fast paced, Dynamic, High Demanding, Challenging, Complex Privacy and Compliance, Confidential, PHI Data on Privacy Violation System Activity Review Project for Existing EPIC HEALTH CONNECT System and CERNER LAB Pilot Project.
• Optimized complex SQL queries, generated data extracts from various sources, Excel reports and Tableau dashboards.
• Automate processes using standard Windows/SQL Server tools, Using SQL server Agent Services.

Confidential, San Francisco, CA

Senior DATA and DW BI Reporting Analyst/SQL DBA

Responsibilities:

• Worked in the Fun, High Demanding and Challenging GREO-IM core team Build and Maintained Full Data Warehouse Database Development of GREO database.
• Transformed Large volume (160 million rows from the Key table) and Quality of Data (Removing Unwanted Characters, Data formatting, Data type issues, Aggregation of data for Different dimensions, Demographic GIS Geocoding data) from different Data sources (Excel, Flat Files, Access, Oracle and other sources) in to Meaningful information to Business Partners to access the Information from the apps built on ESRI ArcGIS Mapping Application, MS Access Store Profile Application, BI tools (Tableau, BIRT) and Custom Web Applications Built on LAMP (Linux, Apache, MySQL, Python) Stack on Amazon Web Services (AWS).
• Migrated MS Access ETL data warehouse in-house applications in to SQL server 2008 R2 Using SSIS.
• Created and Maintained All the database Objects including the Tables, Views, functions, Stored Procedures and wrote Complex Queries for OLTP and OLAP type of data.
• Extracted data from Micro Strategy (EDW -BI) - Traffic on Stores and AUR for Store Profile Report and Applications.
• Extracted Data from IBM Tririga GREO applications weekly. Around 35 to 50 Tables migrated for different tools and applications.
• Used MS SQL Server SSIS extensively Migrated data IBM Tririga data from Oracle, Point of Sale data for Analytics Project, Contribution Ranking Report (Financial data including IRR, IPV), Open Stores report with all financial Information and Lease Action Pipeline reports -Giving Detail Information about each and every store Opened globally with Store Status, Lease type, Store Open date, current Capital Projects and Non capital projects type and Different status information.
• Developed and Build Effective solutions to cleanse the data, Migrated the data for Automation Using SQL server Agent, extensively worked for data Integrity and data Quality.
• Imported, cleansed, transformed, validated or modeled data with the purpose of understanding or making conclusions from the data for decision-making purposes for business Partners.
• Performed data forensics to validate current business rules and investigated potential data integrity issues.
• Resolved technical and functional issues working independently, as part of a team, and with RE field and RE finance Business partners:
• Worked on Excel and MS Access for Data cleansing for Small amount of data. For Large Volume of data used SQL queries and SSIS.
• Build SQL Server 2008 R2 Real Estate Operations Data warehouse from the scratch Using SQL Server Integration Services.
• Automated Daily, weekly, Monthly, Quarterly and Yearly Data Load in to the Data warehouse.
• Data Analytics and Visualization Project, Loaded Yearly POS data in to the Data warehouse. Used SSRS, BIRT, Tableau for Business User Reporting.
• IBM Tririga Real Estate Operations Application Backend Data analysis and Wrote Complex SQL queries to extract the data for reporting needs.
• Strong Knowledge in ArcGIS Mapping applications, Geocoding Needs, Proximity, Trade Area, Capture Rate, Demographic and Data Transformations need for mapping applications.
• Designed and maintained data architecture that accommodates changing business priorities and technological changes. Wrote building data abstraction layers. Stored procedures, triggers and SQL
• Worked with CSSC Team for Collaborative effort to Build a SSIS solutions, Shared the Knowledge and Trained the Team to Save lot of time, money and Energy on resources.

Confidential, Moline, IL

Senior DATA and DW BI Reporting Analyst

Responsibilities:

• Strong Knowledge in Facets Data Model including subject areas like Claims, Billing, Provider, Enrollment, Capitation, Utilization Management, Accounting/Finance and Commissions. Commercial and Community and state Line of business.
• Responsible for interacting with different business Owner to understand their current Crystal reports 6.0 to CR2008 under BO info view environment and future reporting requirements in BO Xi, performed a Confidential analysis, executed Report Migration activities, and supported both Customer Acceptance Testing and Moved to Production deployment.
• Also responsible for ensuring that each Account's reporting solution is migrated successfully from the legacy architecture VB 6.0 to BO Infoview environment with all authentication set-ups.
• MS Access Reports Migration, Facets Crystal Reports upgrade and Business Objects work order request.
• Strong Health care background with latest Health reform compliance and policy related implementation ICD-10, DMRA (Data Warehouse and Reporting Analytics) and Hippa 5010.
• BI Tool Upgrade: Converting Crystal reports 6.5 to Crystal Reports 2008 using Sybase 15.0 as backend database with ODBC connectivity. Save time, money and with all latest features in the CR 2008 for the business users. Use this Crystal reports 2008 (OLTP Reporting tool) as main reporting application for different business entities.
• Worked with diverse team members and from the day one proved as a value added team member by giving best solutions to the team for the successful of this project in the whole conversion and upgrade project from start to end.
• MS Access Report Data mapping: From: Created a Major MS Access Reporting application data mapping document that includes “Auto adjudication Process, Adjudication turnaround Reporting, NHP, Clinical Edits, Pended Claims Summary, NPI and Interest Reporting.

Confidential, Pittsburgh, PA

Sr. DATA and DW BI Reporting Analyst

Responsibilities:

• Performance Improvement for a set of reports which is a representative combination of simple, medium & complex reports.
• Performance improvement in individual long running queries for ‘ad hoc’ execution.
• Validate the scalability with the increase in the data volume and concurrent users.
• Worked closely with team members and client related to database management, database performance tuning, scope definition, business requirements, functional Specifications, architecture, change Management, Impact Analysis, Confidential Analysis, Testing-QA and Launch effort for go-live tasks
• Dealt with Data Quality and Data Governance issues.
• Worked extensively on Business Intelligence tools both relational and dimensional data modeling
• Managed 5-member team for client’s DW POC deliverables.
• Converted DB2 SQL query syntax into Oracle 11g and Teradata.
• Worked with Teradata and Oracle team for SQL conversion and 800 Test Instances creation.
• Fixed syntax issues and validated the bench mark Queries for Benchmark testing, Load testing and mixed load testing.

Confidential, Bethesda, MD

Sr. DW BI Reporting and Reporting Analyst

Responsibilities:

• Fixed existing report defects and modified existing report designs
• Worked on the Proposal templates and fixed simple to complex defect.
• Worked closely with technical architect, Project manager for project deliverables.
• Given best solutions and best practices related to Siebel Actuate report development. Siebel CRM 7.8.2, Actuate 8, IBM DB2, Oracle BI publisher, Oracle 10g, Oracle SQL Developer and Siebel Hospitality Management

Confidential, Durham, NC

Senior Business Systems Analyst (DW/BI)

Responsibilities:

• Developed and Build the “Original Application” Actuate report in BCBSNC Siebel CRM Environment.
• During the Defect Phase, all the defects assigned by Tech lead completed on time in Mercury Quality Center.
• Evaluated the Oracle SQL developer Query tool as per the Manager advice.
• Wrote data Analysis queries on Siebel data model for data validation and report bug Fixings.
• Also supported some of the reports Developed Using Callidus TrueComp for their Producer Assisted application.

Confidential, Santa Clara, CA

Senior Business Systems Analyst (Siebel DW/Actuate Reporting)

Responsibilities:

• Involved in Design, Development, Analyze, Build and Test Phase for the Actuate Quote Reports Creation.
• Provided the ability to generate reports for Accounts, Opportunities, Quotes, Orders and Agreement for the new Siebel 8.0 upgrade Project.
• Created Technical Specification document.Used BI publisher Extensively to Build Quotes and Order Siebel Analytics Template Reports.
• Involved in design of Data mapping, data model, Reports POC and design, development of BI publisher Reports.
• Trained Team mates on BI Publisher.
• Worked on Proposal Templates Extensively from the creation and Integration with document server
• Used Actuate Reports to Add Quote Line Items in the Quote PO and Quote Proposal template.

Confidential, College park, Maryland.

BI Reporting and Data Systems Analyst

Responsibilities:

• Involved in Design, Development, Analyze, Build and Test Phase for the Holding Management Systems Actuate Reports
• Data migration from SQL server to Siebel Oracle Database using SQL data loader.
• Wrote complex queries and loop procedure for data analysis, data quality and data validation.
• Used SQL Server DTS for Migrate data from SQL to ORACLE.

Confidential, Sunnyvale, CA

Data and Reporting Systems Analyst

Responsibilities:

• Involved in Design, Development, Analyze, Build and Test Phase for On Demand and batch Actuate Reports Creation using Backend Oracle Database.
• Analyzing the requirements with Business Analysts and Reporting Team Lead.
• Participated in client meetings to extract and document functional & system requirements. Attending meetings in relation to Production/ UAT status checks.
• Converted and re-designed existing Discoverer Reports into Actuate Enterprise Reporting. Converted and re-designed existing Excel reports into erdpro.
• Created AD-HOC reports using eSpreadsheet Designer. Designed Libraries and Report Templates which is used by other reports.
• Created new reports, Master Detail Reports and Parameterized Reports using Sequential, Conditional, Group and Parallel Reports sections.
• Extensively worked on Page Level Security, Data filter, Combined Data Stream, Memory Filter, Data Sorter, Actuate Foundation Classes (AFC) and other objects.
• Created users, roles and given privileges and maintaining the report executables using Actuate Management Console.
• Involved in Actuate iServer System Monitoring & Management, granting permissions, Access Permissions depending on the User-id.
• Created related joins, namespaces, query subjects, filters and calculated fields.
• Created/Modified Oracle PL/SQL Complex Stored procedures in implementing business rules.
• Worked extensively on eSpreadsheet for report design.
• Used eSpreadsheet Java Callback class, Macro, Multiple work sheet creation, Pivot Reports, Parameter Reports, Calculated fileds, Multiple Data set reports and Dynamic report
• Involved in the upgrade from Actuate 8 to Actuate 9.
• Developed Dashboard reports using data mart. Used Browser Scripting controls for User to pass parameters.