SUMMARY:

• 10+ years of experience in full software development and data warehousing lifecycle (SDLC)
• Knowledge in variety of industries including Travel, Retail, Manufacturing, Health Care Insurance, Sales and Education
• Over 5 years expertise in successful execution of Enterprise BI Program Management
• Proficient with AGILE development methodologies and solution delivery through continuous development and deployment processes
• Expertise in managing project activities including building strong relations with business stakeholders
• Skilled at testing activities and ensuring data quality of BI data extracts, reports, and dashboards
• Adept at risk management, change control management, vendor management and people management of both direct resources and cross functional teams in matrix organizations
• Skilled at acting as a liaison between Business and IT, documenting business requirements and translating them into technical requirements and specifications
• Responsible for establishing Enterprise Business Intelligence Roadmap and IT Governance
• Experience in Data Acquisition, Integration, and Analysis projects
• Expertise in driving business insights through use of data visualization and automating using variety of Dashboard/Data discovery tools
• Excellent knowledge and understanding of Teradata, MS SQL Server, and Oracle
• Excellent verbal and written communication and collaboration skills
• Strong team player and fast learner with the ability to adapt to new environments and technologies

TECHNICAL SKILLS:

Reporting Tools: QlikView, QlikSense, Tableau, Domo, Power BI, SSRS, Cognos

Databases: Teradata, Hadoop, MS SQL Server, Oracle, Progress, MS Access

Data Modelling Tool: Alteryx, SSIS, Oracle ODI, WhereScape RED, QAD Data Transformer

Applications: TFS, JIRA, MS Project, Visio, SharePoint, Service Now, SalesForce.com

PROFESSIONAL EXPERIENCE:

Confidential,Bellevue, WA

Sr Technical Data Warehouse Lead

• Partnered with Program Manager in managing Orbitz data and platform Integration from multiple databases and BI applications into Confidential EDW
• Coordinated with business(Orbitz) in identifying data (Informatica, Greenplum, Hadoop, Teradata) and reports (Tableau, Qlikview, Cognos and Micro strategy) usage
• Managed development activities using JIRA board
• Coordinated platform, data and application migration efforts with BI Operations
• Regularly communicated with business users, setting expectations and prioritizing appropriately
• Documented, prioritized, tracked and drove customer requirements consistently by providing technical solutions
• Reviewed platform capacity, usage and licenses and published Executive Dashboard on Platform Capacity Utilization
• Total platform, application and system license savings of over $1.5M annually
• Coordinated with team as needed to meet and exceed business needs, while managing customer expectations to prevent overload or missed deadlines

Confidential,Redmond, WA

Sr BI /Analytics Lead

• Managed and mentored BI team in building enterprise data warehouse
• Led cross functional team in execution of Parts integration project from pre - initiation to closure
• Collaborated with business partners to understand objectives, identify opportunities, and prioritize tasks to deliver maximum business impact and reported into Business reviews
• Improved processes (prioritization, change control, deployment and communication)
• Drove proof of concepts(POC) with various BI Vendors and steered Global IT in choosing Enterprise BI tool
• Efficient in improving data quality, SLAs and collaborating with cross-functional teams
• Responsible for managing/maintenance of BI servers on AWS(Amazon cloud server)
• Managed project deliverables following Agile methodology, conducting sprint planning bi-weekly and daily scrums using Team foundation Services(TFS)
• Created Daily Management System and Global Parts integration drilldown dashboards to track key metrics viewed by VP, Sr Directors and Plant controllers
• Headed 3 Qlik View training sessions(10/class) with cross functional groups, negotiated and reduced training costs by 12%

Confidential,Redmond, WA

BI Program Manager

• Managed a Cross Functional team (Reporting, Analysts & ETL developers) in support of implementing BI data warehouse projects for Quality, Finance, HR and Operations
• Managed charter, vendor, resource management and deliverables for all phases of project
• Played key role in choosing Enterprise Reporting solution (Cognos, WhereScape RED and Teradata) and designing Enterprise Data Warehouse Architecture
• Worked closely with Vendors in cost negotiation, product specifications, proof of concepts(POC)
• Responsible for creating statement of work(SOW) in support of CRM(Salesforce.com) implementation and evaluating deliverables in preparation for closing
• Excelled in managing relations with stakeholders and vendors
• Responsible for influencing the organization & leadership
• Improved change management processes partnering with business
• Effectively motivated team, resolving issues by negotiation and problem solving techniques
• Provided Cognos Training and responsible for reducing the costs by 4%
• Automated Device Event Life tool(DELR) that captures complete history of a device across multiple data sources by reducing total of 120 man hrs/month
• Significantly improved DELR performance from 8mins to 40secs by running stats
• 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
• 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
• 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
• 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

Sr BI Analyst/Developer

• Interacted with Business Analysts in gathering reporting requirements
• Coordinated with subject matter experts and created relational models using Framework manager
• Generated various complex Master-Detail, Conditional formatting list and cross tab reports
• Provided training to business analyst on query studio

Confidential,Chicago, IL

Consultant Business Development Analyst

• Gathered reporting requirements from Business Analyst
• Developed multidimensional cube using Cognos Transformer
• Developed various chart, crosstab and list reports using Impromptu
• Designed, Executed and Documented test plans and test cases using SQL for Regression testing