SUMMARY

• 9+ years of progressive experience in Business Intelligence (BI), Data Analytics, Solution Architect and Software Portfolios.
• BI architect experience in implementing Business Intelligence projects. Helped clients with server - sizing, clustering, and load balancing to ensure scalable and robust BI implementations. Worked with clients through upgrades and installations.
• Strong sense of bigger picture yet down to detail in alignment with sales & marketing.Drive results in cross-team collaboration projects with good prioritization skills.
• Strong Analytical skill to find the trend, anomalies and present insight to leadership and engineering teams to act.
• Successfully led and engaged with end to end projects with buy-in from executives, business leaders, and technical leaders to deliver new software features/ functionality and services.
• Experience in working through numerous cycles involving UAT and validation. Worked in close co-ordination with validation teams to design test cases. UAT cycles are designed to test applications for data, functionality, and performance.
• Experience in complete project life cycle (SDLC) including requirement gathering, Scripting and ETL, Front-end design, Functional testing, Data validation, Performance Optimization, User Acceptance Testing (UAT), deployment, Access Control, Documentation, Presentation, and Training.
• Wide knowledge of technology stacks such as BI Software (Tableau, QuickSight, Confidential, Power BI), CRM- Salesforce, cloud (AWS, Azure, GCP), Databases (SQL, Oracle, MongoDB, PostgreSQL, Snowflake), ETL tools.
• Certified Confidential Developer and Designer.

TECHNICAL SKILLS

Dashboarding/Analytics: Confidential Sense, QlikView, Nprinting, Power BI, Tableau, Alteryx, Looker, and Salesforce.

Big Data Technologies: Python, Spark, MongoDB, Hive, Presto, Google Big Query.

Database Technologies: SQL Server, DWH, Teradata, SAP BW/R3, DB2, NetSuite, Oracle 10g/11g, MySQL, PostgreSQL, NoSQL, MongoDB, Informix.

Languages: JavaScript, Python, VB Script, Shell Scripting, PHP.

Platforms: AWS, Azure, GCP, Kubernetes, Docker, Windows Servers, Linux (Ubuntu).

PROFESSIONAL EXPERIENCE

Sr. Business Intelligence Software Engineer

Confidential, Newark, CA

Responsibilities:

• Assessed analytics requirements based on technical and business use cases. Developed custom reporting solutions in the realm of available technologies and created strategy for the future roadmap for finance & accounting, business planning, Sales, HR, marketing and product teams.
• Worked with PoweBI Dashboards. Wrote complex DAX functions in Power BI and Power Pivot.
• Established and rolled out development best practices & KPIs to improve productivity and project quality (code/UI review), project management, cross-team collaboration & Agile development (bi-weekly sprints, daily scrum).
• Led development and implementation of enterprise dashboards like forecast performance, product analytics, sales performance. Implemented a statistical model (using Python) for Account Receivables.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Worked with QlikSense Engine API to automate the reloading process.
• Developed Excel PowerView, PowerQuery and PowerPivot dashboards for data analysis.Scheduled Automatic refresh and scheduling refresh in power bi service.
• Ran a PoC for Nprinting tool for executive buy-in and eventually automated daily and monthly reports. 300% increase in team productivity shown after 6 months of implementation.
• Queried to Presto, Hive, Snowflake, SQL to bring out data for quick analysis and coordinated to bring in to production.
• Trained and presented to 150+ Sales/SalesOps and coordinated roll-out of analytics and reporting for the Sales department.
• Led Business Intelligence group at Confidential to architect companywide enterprise BI software tools including Tableau, Power BI, Confidential, Postgres, SQL Server, Oracle, ETL tools, Salesforce, and Snowflake Computing.

Sr. Solution Architect

Confidential, San Diego, CA

Responsibilities:

• Led a short term highly visible program to provide technical consulting, training and on-going support to executive stakeholders of Confidential .
• Presented BI software capabilities and developed proof of Concept (PoC) for supply chain and IT Team.
• Worked with Power BI and Tableau dashboards to migration from Confidential .
• Worked on all types of transformations that are available in Power bi query editor
• Created stored procedures and SQL queries to pull data into power pivot model.
• Developed QlikView Dashboards and managed scheduled in Confidential Management console (QMC)
• Part of integration team to Integrate Qlikview with Salesforce interface. Developed automated way to present objects inside Sharepoint.
• Wrote stored procedures from SQL server to make efficient data model, that were consumed in QlikView dashboards.
• Architected and roll-out to the production of an enterprise-wide BI Server Hybrid (on-premise and Cloud) platform.
• Worked with pre-sale team to developed a strategy for Enterprise software implementation of 500+ licenses to stakeholders for the BI platform.

Consulting Solution Developer

Confidential, Dallas, TX

Responsibilities:

• Led development of the " Confidential Accelerators” service line that grew over $900K within one year.
• Performed customer research and developed product personas to generate a well-rounded product/service.
• Key contributor during a period of hyper-growth of the product with varied responsibilities including designing product categories and coordinating sales/pre-sales with functional groups.
• Developed QlikView and Confidential sense dashboards in Sales, Pharmacy, Marketing, Retail domain with integration with multiple web domain.
• Developed Comparison dashboards in Power BI and Tableau to show case functionalities.
• Managed Security and Confidential Sense Server (QMC) to the users and access layer. Applied Section access to the dashboards.
• Debug and developed QlikSense extensions using HTML, CSS and JavaScript.
• Architected and implemented revenue-generating server & application software in the cloud (Azure, AWS) integrating with popular SaaS applications.

Senior Business Intelligence Developer

Confidential, Dallas, TX

Responsibilities:

• Developed QlikView OEM application that sold to customers with $500k with ongoing maintenance service fee.
• Architected Multi- tier QVD generation and transform and job schedule for external and internal customer.
• Developing various tableau dashboards prototype for the future uses and conversion of current excel reports into tableau.
• Along with teammate, created QlikView extension using JavaScript, XML, and JQuery and deployed into production. Lead a team of 6 members for Data warehouse design and report on QlikView, SSRS, and Oracle.
• Provided server tuning and upgrade recommendations, after performed analysis of usage patterns. Used NPrinting to create and push the pixel-perfect reports.
• Provided input on database management, OLAP cube in SQL server with ETL functionalities.
• Part of QlikView Administrator to maintain QMC, and Security for applications. Work with tier-2 application development and document chaining. The created task to optimize the reload and performance of Publisher.
• Worked with Tabeleau, QlikView, Confidential Sense, R, SQL Server, Oracle, Informatica, Tableau, PostgreSQL, Excel.

BI Software Engineer

Confidential, Pleasanton, CA

Responsibilities:

• Worked as a QlikView Administrator which include maintains the QMC, configure tasks; manage the licenses, Implemented Security for applications (Included Section Access, Dynamic Data Reduction, and Document-level security).
• Developed weekly and monthly dashboards tracking sessional trends, that helped the marketing team to identify the type of product need to include in Weekly ad (Just for U) to sell more products.
• Created Project Management and Business Requirements Document (BRD) and created test cases and memory footprint (RAM usage) for a few applications. Set up Nprinting for distribution of Reports.
• Develop and evolve the overall vision for Enterprise Information Lifecycle including data strategy, architecture, rationalization, quality, metadata, and advanced analytics to support strategic business initiatives. Deployed QlikView Enterprise Framework (QEF) for the IT department.
• Worked with Supply chain, Supply Operation, Pharmacy and IT as Subject Matter Expert (SME)
• Improved 10% on the pharmacy team, by analyzing common disease, drug selling patterns, profit, inventory and focus on stores and drugs.
• Increased efficiency of warehouse blackout by 15% by the provided actionable insight of maintenance and purchase of new equipment.
• Worked with QlikView 11.x, SQL Server, Teradata, DB2, Informix, MySQL, MS Access, Essbase, Excel, CSV