SUMMARY:

• Program, Project Management and Analytics leader with ~9 years of experience in building data pipelines, enabling business intelligence platforms and in business process optimizations.
• Ability to effectively collaborate across teams, business leads and stakeholders to drive strategy, planning and implementation using data and analytics.
• Strong skills in data analysis, reporting and ability in presenting insights to relevant audience.
• Working in an Agile environment to develop, test, deploy, and maintain, while collaborating with team members on multiple products integration.
• Coordinating offshore teams in full filling the customer requirements along with managing the support team.
• Experienced as a scrum master to provide the deliverables on time in agile methodology by using Microsoft VSTS tool.

FOCUS AREA/SKILLS:

Data Analysis | Critical Thinking | Problem Solving | Unix, Perl and SQL Programming | Business Analytics & ROI Analysis | Database Modelling | Cognos | Tableau | ETL | Informatica Power Center | Informatica Developer (Data Quality) | Systems/Data Integration | Analytics Support Specialist | Project/Program Management | Risk Management | Agile, SDLC Methodologies | Networking Testing | Presentation/Application Layer Testing | GUI Testing | System Testing | Regression Testing

EXPERIENCE:

Confidential, San Diego, CA

Business Intelligence Lead

Responsibilities:

• Managed a team of 5 in upgrading the reporting platform to Cognos Analytics (11) whilst ensuring no downtime to all the critical reporting needs; Used process improvements & optimization to save $300k in Opex costs; Project managed the requirement gathering, technical deep dives, design, implementation & cutover planning.
• Strategized the technology roadmap using Cognos, Tableau, IDQ, MDM, and Alteryx to support both the current & future business objectives.
• Ideated & developed complex dashboards using Analytics to help with business planning and for tracking critical KPIs.
• Identified opportunities across different value - streams in the company and converted them into projects.
• Research on New BI products & Capabilities and enable them at appropriate client environments which helped in offering best solutions, this helped me to learn tools like Informatica Data Quality and Master Data Management.
• Led complex data integration from multiple systems and created an easy to use analytical dashboard that helped Finance team identify Uninvoiced Installments backlog worth $7M
• Analyzes the issues being raised against the applications and design, then implemented enhancements/upgrades to prevent future occurrences of the reported problems or issues.
• Created highly complex reports using OLAP CUBES as data source for Multi-Dimensional Analysis; Avoided a potential loss of $350k
• Develop, enhance and preserve metadata layers, reports, report definitions and dashboards from requirements and form an understanding of organizational business needs.
• Designed Business Intelligence applications spanning ad hoc query, data mining, statistical analysis, online analytical processing (OLAP), strategic reporting, as well as dashboards and performance scorecard requirements
• Upgraded the reporting platform from Cognos 8.4 to Cognos 10.1(Major Upgrade)
• By Integrating multiple source systems and advanced analytics developed a single CS Fleet Analytics Dashboard that provided Sales Team with a complete 3600 view of a Package’s present status and history; Dashboard helped find new opportunities worth $3M.
• Created Route optimization analytics for supply chain logistics which helped $300k in savings per year.
• Led development and adoption of complex visualization solutions, data prep, data enrichment, and automation solutions across Enterprise to include: regional purchasing and operations, retail operations, merchandising, finance, supply chain, sales, HR and the foundations.

Environment: Tableau, Alteryx, Cognos - Report Studio, Query Studio, Framework, Oracle, SQL, PL/SQL, Windows, Toad, SQL Developer, MotioCI, QC, Remedy, Selfservice.

Confidential

Responsibilities:

• Created a complex ETL pipeline that helped the central finance team to easily retrieve all purchase orders; This new process identified previously missed payment orders worth $600k
• Ideated automated, repeatable and stable processes to support data load, data validation, and data synchronizations for BI data warehouse
• Design and developed end-to-end ETL procedures for intake and transformation of data from both internal and external sources, incorporating data quality and verification steps in building enterprise Datawarehouse

Environment: Informatica, Alteryx, Informatica Developer, Informatica Analyst, Oracle, SQL, PL/SQL, Windows, Toad, SQL Developer

Confidential

Responsibilities:

• Enforcing data governance standards, policies, and procedures for the design and proper use of customer’s data.
• Design future-state concept of operations through development of business process models and data flow diagrams; By research and experiment with emerging Data Quality Profiling technologies and tools associated to data quality, metadata, data governance
• Good understanding of complex data relationships and business requirements that formulates new technologies to reduce overall cost and ROI for customers.

Environment: Informatica, Informatica Developer, Informatica Analyst, Oracle, SQL, PL/SQL, Windows, Toad, SQL Developer

Confidential

Responsibilities:

• Managing the design & implementation of a futuristic Master Data Management (MDM) solution that is tasked at enabling a 360-degree overview of all customer & partner activities.
• Ideated and now influencing development of a hybrid 1P - 3P system combination to leverage the best of internal offerings and customizable off the shelf solutions.
• Acting as a subject matter expert and representing the team with Data Governance Council with representatives from all the functional arms of the Enterprise - Ops, Security & Finance to brainstorm and agree on definitions of key data elements & future roadmaps
• Supporting the strategic decisions around Data Acquisition & Curation through well thought out presentations backed up by industry research.

Environment: Informatica MDM, Informatica, Informatica Developer, Informatica Analyst, Oracle, SQL, PL/SQL, Windows, Toad, SQL Developer

Confidential, Santa Clara, CA

Software QA Engineer

Responsibilities:

• Led the Confidential software and hardware testing project on the company’s game-changer product(s) in the industry.
• Automated test case execution on Selenium and Silk test suite to quickly & easily gather the performance testing results; Helped reduce the testing time of all future tests by 25%.
• Started managing customer escalations and hotfix validations within 6 months of joining.
• Developed and executed end to end test plans and shared critical in-depth analysis to the engineering team and supported the rollout of all new software and hardware offerings; Helped launch 8 offerings.
• Mentored a 3-member team in developing internal tools.

Environment: Networking Testing, Presentation/Application Layer Testing, GUI Testing, System Testing, Regression Testing, Active Directory, Windows 2003/XP, Linux, Confidential NIOS and Windows BIOS, IPMI firmware and RAID firmware, UNIX, Perl, TCP/IP, DNS, DHCP, FTP, TFTP, SNMP, NTP, HTTP, Bugzilla, JIRA