SUMMARY:

• Over 15 years of experienced working as a BI Lead, Senior System Analysis, Senior Business Analyst, and Senior Consultant Application Developer, with extensive experience using MS SQL, Oracle, MS Report Writer, MS Visio both for data base flow charting and detailed system design.
• Acted as SME for Tableau at BJC.
• Extensive experience designing/implementing Data Warehouse technologies using the Kimball Life Cycle Method. ETL using MS SSIS, TALEND Studio and direct hands on coding. Creating complex STAR Schemas with Slow Changing Dimensions as well as Standard Dimensions.
• Has the proven ability to work closely with developers and business users, data warehouse, quality assurance departments and leading data modeling teams.
• Highly instrumental in development using MS BI Suite (SSIS, SSAS, SSRS), designing layouts, and working as a part of the development team from concept to implementation, been responsible for designing, writing and producing complex MS SQL, Oracle PL/SQL using stored procedures, triggers, and complex queries and views.
• Have created hundreds of dynamic and static reports using MS SSRS.
• Work at an expert level for ETL processes using MS SSIS and Talend Studio.
• Over 8 years of IT experience in System Analysis, Design, Development, Maintenance and Support using Oracle Database 8i/9i/10g/11g, SQL, PL/SQL, SQL * Loader, Query Optimization, Performance Tuning, and Trouble Shooting.
• Expertise in writing Database Stored Procedures, Functions, Packages, Triggers, Cursors, Exception Handlers, Dynamic Cursor programs, Native Dynamic SQL and Data Collections using SQL & Oracle PL/SQL.
• Good working experience with the usage of Collections, Bulk Insert, Global temp table, Nested tables, External tables, Advanced queuing, Materialized Views, Inline Views, Analytical functions and REF cursors.
• Executing, monitoring various UNIX ksh scripts, escalating and bug fixing the related issues as required, providing solutions, implementing code logic as per functional, adhoc requirements.
• Expertise in implementing Data modeling, Erwin, Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling and Oracle Designer.
• Expertise in designing, developing Extraction, Transformation, and Load (ETL) scripts utilizing SQL, PL/SQL utilities and provide solutions to critical issues enhancing performance and productivity to the project.
• Extensive experience in integration of data from heterogeneous sources (ERP, RDBMS, Flat Files and Web Applications).
• Extensively worked on Data Migration using Flat files and Data Mapping through SQL* Loader Imp/Exp utilities, UTL - File Package on Oracle 9i and 10g Databases.
• Experience in Performance tuning, Application tuning and Query Optimization using Hints, Explain plan, TKPROF.
• Understanding of ERP Systems (SAP, Oracle Applications) and worked with Manufacturing, Sales and Distribution, Inventory (Material Movement), AR and AP modules’ Rapid Mart Customization / Development.
• Expert level understanding of Oracle database capabilities and DW best practices including appropriate use of indexing, material views, partitioning, snapshot capture and referential integrity.
• Expertise in implementation of Data Warehousing and Decision Support systems in UNIX/Windows environments.
• Hands on experience with tools like SQL Navigator, Toad, Sql*Plus, Export and Import Utilities along with Oracle Enterprise Manager (OEM).
• Expertise in writing Wrapper/Scheduler jobs and hands on experience in Autosys Tool.
• Also worked on MS SQL Server, Access Databases and developed T-SQL, SQL, Stored Procedures, Cursors, Triggers, Views, Indexes and Constraints, Query Optimizer.
• Proficient in working and conceptual knowledge of Oracle Forms 6i/10g, Reports 6i.
• Expertise in writing Crystal Reports and SQL Server Reporting Services.
• Commercial experience in Data Modeling using design tools like ERWIN and MS VISIO, created ER Diagrams, Data Flow Diagrams using Design tools.
• Hands-on experience with source control tools like Visual Source Safe (VSS).
• Major strengths are familiarity with multiple software systems, tools and the ability to learn quickly new technologies and adapt to new environments.
• Excellent interpersonal and communication skills, self-motivated and good team player.
• Worked through all phases of System Development Life Cycle (SDLC): requirements gathering, analysis, design, development, testing, UAT, production and post-production support

TECHNICAL SKILLS:

• MS SharePoint
• Teradata systems
• QFM systems
• MS Report Writer
• MS Access
• MS SQL
• Oracle PL/SQL
• IBM DB2
• MS T-SQL
• MS Report Writer
• MS Visio
• AIX UNIXRed Hat UNIX
• PERL
• UNIX Scripting
• MS SSIS
• MS SSAS
• MS SSRS

PROFESSIONAL EXPERIENCE:

Data Warehouse Architect Designer

Confidential - St. Louis, MO

Responsibilities:

• Responsible for the overall design and implementation of the Data Warehouse
• Instrumental in the redesign of data from de-normalized to industry standards
• Extensive application design using SSIS, SSAS, MDX and SSRS
• Member of the Architecture design team
• Design/Implemented complex Queries for data analysis against complex business rules
• Partnered with the DBA’s to design the future data warehouse infrastructure

Senior BI Application Designer

Confidential - St. Louis, MO

Responsibilities:

• Responsibilities include designing complex applications
• Meet with internal customers to design business solutions
• Design and implant several Data Marts
• Instrumental in building/implementing the Oracle Data Warehouse
• Design the backend ELT system for moving disparate data to Warehouse
• Architect and design several business intelligence solutions
• Prototype the selection of our new ETL system
• Design online system from legacy batch systems
• Create Methods which enable Senior Management to have Score Cards
• Create Dashboard systems for near real time monitoring of business

Senior Data Architect/Business Analysis

Confidential - St. Louis, MO

Responsibilities:

• Assessed Business and User Requirements
• Was lead person on Warehouse design
• Responsible for architectural design and strategies
• Created Conceptual and Physical designs
• Designed complex reports from Data Warehouse using MS/SSRS/SSIS
• Was team lead for Data Warehousing and Business Intelligence (BI)
• Met with Stake Holders and help created Business Use Cases
• Used MDX for creating data cubes.

Senior Business Data Analysis/Application Developer

Confidential - St. Louis, MO

Responsibilities:

• Captured and converted Legacy data to MS SQL Data Warehousing format
• Performed data analysis of huge data store for thousands of Patient records
• Acted as SME for Tableau
• Designed complex SQL queries in MS, Oracle, Access and Excel
• Performed computer programming using a variety of mainframe and PC base languages required by customer
• Designed and developed rules, programming, key reports, dashboards and scorecards for performance measures and claims tracking
• Designed and organized reports for management, directors and other customers
• Performed analysis on patient level detail and summary data and identifies trends
• Used MDX for building data cubes for reporting and documentation

Environment: Used BI Suites - SSIS/SSRS/SSAS extensively.

Senior Business Analysis/Application Developer

Confidential - St. Louis, MO

Responsibilities:

• Responsible for gathering customer requirements
• Designed and implemented USE Cases for functional description
• Responsible for developing the System Design Scope
• Created UML Use Case Diagrams
• Created and developed complex SQL to meet business needs
• Worked on information gathering with the project managers, to determine customer and client requirements
• Designed flow charts and business rules which helped communicate requirements clearly for each client specific needs
• Developed, Unit Tested, and delivered complex MS SQL coding
• Developed complex applications specific to the needs of our customers
• Responsible for Storage Procedures, Triggers, Transactions, User Functions and Database Analysis which enabled the creation of complex reports
• Handled Visio Flow charting for preliminary discussion with the clients
• Documented business requirements, used for functional specifications
• Designed complex SQL queries to meet the client’s demands

Environment: MS T-SQL, MS SharePoint, MS Report Writer

Senior Business Analysis-Project Manager

Confidential - St. Louis, MO

Responsibilities:

• Functioned as a Project Management, Client Liaison, System Design, Application Development & Support person to fit the needs of the business
• Facilitated extensive sessions with the client/end users to scope project needs
• Defined business rules and business requirements
• Developed Business Solutions with the creation of a Business Data Mart
• Extracted Data from the Warehouse and deployed using MS Excel Pivot tables, and Cubes
• Wrote complex SQL queries against a large data warehouse
• Created several complex reports per user input
• Designed and implemented USE Cases for functional description
• Responsible for developing the System Design Scope for several large complex projects
• Created UML Use Case Diagrams using MS Visio for client review
• Provided Dash Boards for report and data summarization
• Led the project team and coordinated input from the stake holders
• Responsible for MS SharePoint Collaboration Tools Training the Data Warehouse Group

Environment: Oracle PL/SQL, MS T-SQL, MS SharePoint

Senior Business Analysis

Confidential - St. Louis, MO

Responsibilities:

• Designed system processes to meet internal client requirements
• Developed Business Solutions using MS Excel, MS Project Manager, Oracle PL/SQL and IBM DB2
• Extracted Data from the Warehouse and deployed using MS Excel, Grid computing, Oracle SQL and DB2
• Wrote complex SQL queries against a large data warehouse
• Ensured that existing database assets were being leveraged
• Used MDX for building data cubes for reporting and documentation
• Created extensive SQL scripts used for data validation and testing
• Responsible for maintaining the overall vision for data strategy within my assigned group
• Determined the best method to quickly Data mine the tables for business usage
• Team responsibility was to move the design throughout the SDLC development process
• Met with all the stake holders and insure agreements and sign off
• Determined the most efficient process for creating a new business application

Environment: Oracle PL/SQL, IBM DB2

Business Analysis/Application Developer

Confidential - St. Louis, MO

Responsibilities:

• Development of work flow processes used as specification for functional design
• Completed complex Application Development in the Investment Brokerage component of the business
• Responsible for creating functional software specification needed to meet the needs of the investment brokers
• Team responsibility to move the design throughout the development process
• Met with all the stake holders and insure agreements and sign off
• Determined the most efficient process for creating a new business application
• Designed several complex systems used for tracking broker/trader activities
• Documented several large SAR's (system recovery procedures) for the banking and investment divisions
• Collaborated with various groups for any conflict resolutions to move project forward
• Created custom programs which interfaced with the main trading and investment vendor supplies package

Environment: MS T-SQL, MS Excel, MS Access

Senior Business Analysis

Confidential - St. Louis, MO

Responsibilities:

• Data Warehouse Department Specialist
• Designed complex SQL queries using Oracle and Netezza applications
• Worked closely with developers and requesters identifying data and functional requirements in the design of new/enhanced systems
• Ensured development objectives were accomplished, completed user testing, and member notification is prepared in a timely fashion
• Consulted with Business Owners and Stake on projects
• Developed and participated in the review of business and functional requirements and determine primary functions that the project is to provide
• Responsible for timely and accurate communication with project staff throughout the life cycle of the project
• Ensured knowledge transfer of vendor technology to Confidential staff
• Documented and coordinated changes and enhancements of products and services
• Prepared and/or presented documentation of business/technical presentations. Provided technical support for the member(s) to ensure adherence to requirements
• Evaluated business requests to determine feasibility, work with Software Engineers to define alternatives and recommend optimal solutions
• Prepared overall project plan, incorporating costs and tasks from the various components, ensuring a successful and timely project implementation
• Ensured methodology compliance, document problem areas and coordinate resolutions, reporting to management as necessary
• Investigated/researched Confidential industry business/technical process and recommended changes and improvements
• Coordinated and assist in implementation of new or revised rules and policies. Coordinated and documented project/release level user acceptance testing
• Provided business knowledge and technical support for business requirements development
• Responsible for Quality Control System Testing and Data Analysis results for large projects

Environment: Oracle PL/SQL, UNIX, Netezza, DATA Warehousing (Oracle), MS Project Planner

Senior Business Analysis/ Data Analyst

Confidential - St. Louis, MO

Responsibilities:

• Created system applications which solve production performance measurements for the reporting of Advocate score cards by using web base technology
• Responsible for leading the team in Data Modeling for the initial set up of Call Center Data Needs
• Designed and implemented a database auditing system used to complete Prior Authorization field audits with MS Access form design
• Used Data from the Data Warehouse, to create methods for the Prior Authorization research team to run ad hoc reports on demand using a desired date range, extracting data with Teradata SQL, MS SQL, and MS Access
• Determined by using detailed data analysis from historical information how production and patient efficiencies can be improved
• Streamlined and automated the process of reporting department performance week to week using advance MS SQL and Oracle programs
• Completed and designed complex Excel and VBA coding
• Analyzed large volumes of data using complex SQL Queries such as Inner, Left, Right and outer joins along with complicated sub queries and cross tab queries
• Responsible for department weekly and monthly performance reports. Used MS SharePoint Administrator for the department
• Created MS SharePoint Documents as examples for team members and other departments
• Responsible for the conception, design and implementation of an internet based tickler system for Resource Management
• Implemented complex systems using programming and coding in MS Excel VBA
• Wrote the process and method for internet deployment utilizing using MS/ASP and MS/VB scripting
• Automated the system to extract data from EWFM and do live updates and reports on national departmental performance using call center metrics
• Responsible for gathering data from internal business groups and systems and assisting with the resolution of issues as well as running reports for analysis
• Created MS Access system with MS SQL backend that is being used to centralize employee performance scoring and measurements
• Saved the Member Choice Center enormous expense by creating an electronic system which replaced the need to send faxes using paper
• Designed an efficient method which allowed searching for Doctor Information using type ahead lookup technology thereby reducing data entry errors up to 95%

Environment: MS TSQL, MS Access, MS Excel, Netezza, MS SharePoint