SUMMARY

• 9+ years of experience in Full - Lifecycle software development and Data Warehousing lifecycle
• Over 5 Years’ expertise in successful execution of Enterprise BI Management
• Proficient with AGILE development methodologies and delivered solutions through continuous development & deployment process
• Expertise in managing Project activities, building strong relations with Business stakeholders, risk and change control management and people management both Direct reports as wells as Project Manager coordinating across multiple teams
• Led projects of medium to high technical complexity projects and responsible for directing and managing the work of team members/consultants
• Worked as Liaison between Business and IT, translating Business requirements and coordinating with Application/BI development teams
• Responsible for establishing Enterprise Business Intelligence Roadmap & IT Governance
• Knowledge in variety of industries including Manufacturing, Health Care, Insurance, Sales and
• Successfully driven Data Acquisition, Integration & Analysis projects
• Expertise in improving Business Process Analysis & Automation using variety of Dashboard/Data discovery tools, QlikView, Qlik Sense, DOMO managing KPI Metrics
• Responsible for managing ETL, Dashboard & Reporting Framework teams
• Proficient in Team Development, & Leadership
• Excellent knowledge and understanding in Teradata, MS SQL Server, MS Access, Oracle and Progress
• Excellent Communication, Collaboration and written skills
• Flexible and versatile to adapt to new environment with a strong desire to keep pace with latest technologies

TECHNICAL SKILLS

Reporting Tools: Tableau, Qlik View, Qlik Sense, DOMO, SSRS, Cognos 10.2 Business Suite, Business Objects, Crystal Reporting, SAP BW

Databases: Teradata Client 14.10, 13.10(Teradata Administrator, Teradata SQL Assistant, Fast Load, Multi load, Teradata Parallel Transporter, Bteq), MS SQL Server, Oracle 10g, Progress, MS Access

ETL Tool: SSIS, Oracle ODI, WhereScape RED, Teradata OLEDB, QAD Data Transformer, Talend

Applications: MS Project, Adobe Marketing and Cloud Analytics, SharePoint, MS Excel, MS Visio, Macromedia Dreamweaver

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Business Intelligence Program Manager

Responsibilities:

• Managed requirements gathering, Design, Development, testing and Documentation
• Managed team of 4 to build Enterprise Data warehouse data models needed to proactively analyze and translate data into meaningful business insights
• Collaborated with business partners to understand objectives, identify opportunities, and prioritize tasks to deliver maximum business impact and reported into Business reviews
• Worked with ecommerce team using Web Analytics application and delivered KPIs
• Headed Parts integration Project, worked with cross functional teams and executed project deliverables on Budget and schedule
• Conducted workshops with business periodically prioritizing deliverables, to effectively stay on-track and converted data into visualizations
• Written Functional specs managing cross-functional group dependencies and worked closely with technical teams
• Managed Projects following Agile, conducting scrums to monitor daily progress/status using TFS
• Responsible for managing/maintenance of BI servers on AWS(Amazon cloud server)
• Delivered KPI dashboards showing top 10 customers, product bookings, MTD Orders and Invoices, Past due Orders, customer support time via live chats captured by tags, Lines Shipped vs Lines overloaded, etc.
• Created Daily Management System and Global Parts integration drilldown dashboards to track key metrics under Safety, Quality, Cost, Delivery and Morale Monthly/Weekly/Daily by region/plant viewed by VP, Sr Directors and Plant controllers
• Conducted UAT workshops with Business to evaluate web forms on data entry, navigation, tag performance, security and BI reports/dashboards

Confidential, Redmond, WA

Global BI Program Manager

Responsibilities:

• Managed team of 3 BI(Reporting & ETL developers) in support of various BI data warehouse projects for Quality, Finance and Operations functional groups
• Managed Estimation, Resource management and deliverables in different phases of Project
• Partnered with stakeholders on the Change Management Process for scope management post approval of the requirements work package
• Designed Enterprise Data Warehouse Architecture
• Managed Enterprise Data Reporting applications (Cognos, WhereScape RED and Teradata)
• Completed project milestones ahead of project schedule, maintaining cost, time and quality project deliverables
• Led team to build data models needed to analyze and translate into meaningful business insights
• Excelled in managing relations with stakeholders following Effective communication influencing the organization & leadership, Motivating team, Resolving by negotiation/conflict management, and Problem solving techniques
• Managed automation of Device Event Life tool that captures complete history of a device across multiple data sources by reducing total of 120 man hrs/month
• Architected process to automate daily ETL loads using stored procedures and defining parameters
• Significantly improved DELR performance from 8mins to 40secs by running stats
• Managed Global BI Reporting Analysts Team as part of Divestiture
• Headed Migration Project, created repository for the legacy SAP sales and purchase order data allowing a place to extract legacy data without having to migrate it into current systems which allowed these projects to progress faster
• Streamlined the ETLs to reduce the data extraction from 13+ hours to 2, also assessed the schema changes between versions to ensure there wasn’t any data issues post upgrade
• Migrated 90 tables, 78 procedures and 47 views to PROD, re-configured data source connections for tables, procedures and parameters and scheduled and automated daily loads

Confidential

Consultant Architect/Sr Business Analyst

Responsibilities:

• Implemented End-To-End BI Solution within Budget and Schedule
• Designed and built Enterprise Reporting data warehouse using Wherescape RED and Teradata
• Designed and Built BI Models Using Cognos 8.4 Framework Manager for Finance and HR Commissions
• Created and automated Custom Stored Procedures, fiscal date calculations, derived calculations
• Worked with Infrastructure Admin on database monitoring strategies such as setup triggers to identify and release database, table and row level locks, database backups and archive recovery
• Documented and Trained users on Adhoc Report development

Confidential

Consultant BI Specialist

Responsibilities:

• Interacted with the Business Analyst in gathering the reporting requirements
• Coordinated with Subject matter experts to better understand the dimensions and measures
• Created relational models using Framework manager and published to Cognos connection
• Generated various complex crosstab and list reports using report studio
• Implemented Master-Detail reporting, Conditional formatting, Stored Procedures and Drill through
• Provided testing using Unit Testing
• Provided to business analyst on query studio

Confidential, Chicago, IL

Consultant / Sr Business Development Analyst

Responsibilities:

• Gathered reporting requirements from Business Analyst
• Developed multidimensional cube using Cognos Transformer
• Developed various chart, crosstab and list reports using Impromptu
• Designed and Executed test plans and test cases
• Used SQL to perform Backend Testing
• Modified and documented scripts for Regression Testing

Confidential

Programmer Analyst

Responsibilities:

• Involved in analyzing the user requirements, for report generation
• Responsible for Migrating Reports and Models from ReportNet 1.1 to Cognos 8 using Cognos Migration Utility
• Coordinated with subject matter experts and business analysts to better understand measures and dimensions in database
• Designed Business Models using Framework Manager
• Created various List, Crosstab reports and Pie charts using Report Studio
• Set Security and published packages to the Cognos Connection Portal