OBJECTIVE

• Deliver enterprise systems by leveraging database and technologies to help businesses transform their data into usable information. Team oriented, customer focus and appreciative of opportunities to continue to share and growth in all aspects: personally and professionally.

TECHNICAL SKILLS

• Process modeling, relational modeling, dimensional and multi - dimensional models,de-normalization patterns, KPI management and governance
• data & system architecture system and data analysis, data integration flows, Power BI, Snowflake Cloud Data Warehouse
• Bash ( Advance), ANSI SQL(Advance), T-SQL, PL/SQL(Advance), process optimization data partitioning
• ThoughtSpot Analytics,SSAS (Classic /Tabular / Partitioning) Advance DAX, SSIS, SSRS, Power BI, R scripting. Data preparation and quality controls
• Load analysis & tuning, partitioning, Knowledge of replication concepts and databases (CDC), HVR training, Wherescape trained, Python & R trained.
• Former Informix/Oracle/SQL DBA/Manager with good scripting scripts in Unix and Windows environment.
• C#, Java. Visual Studio .Net. Scrum, Agile (JIRA/HPLM)

PROFESSIONAL EXPERIENCE

Confidential

Manager BI & Analytics - Technical

Responsibilities:

• Hands on deep critical development is required on data models, processes all-hands on deck as technical (hands dirty with heavy t-sql ) leader to deliver automated executive impact scorecard analytics and other major BI components for Covid-19.
• Review dimensional and relational models for performance and advise and partitioning strategies.
• Write Complex T-SQL code and tune others engineers code.
• Deep data analysis on data pattern
• Apply C# or Scripting as needed to provide the data as needed for Marketing/Sales/HR areas.
• Leverage rendering framework for SSRS to generate merchant data via export reports from SSRS
• Wrote and deployed SSAS asynchronous framework to refresh SSAS cubes with capabilities to fully manage: add/merge/refresh of objects. Data model to sustain the strategy helps in overall performance with all the cubes.
• Parse data sets using T-SQL or Jupyter notebooks as needed to verify quality and completeness.
• Create data models and denormalization patterns for performance as needed: columnar/wide as per challenges presented.
• Cross-team collaboration on Microsoft BI Platform as we upgrade product stack to mitigate impacts.
• Work in multi-disciplinary team and ensure we are aligned on strategy to delivery analytical products.
• Recruit and retain top talent for the BI & analytics organization
• As part of management team, provide strategic vision as part of the leadership Analytics & BI organization
• Participate in Architecture review board for merchant common platform as well as snowflake analytics platforms.
• Research BI & analytics landscape for new and empowering tools and platform to improve not only our analyst but the overall organization by improving data literacy
• Empower engineers and analysts with their content, keep working in agile and foster deeper collaboration between team/peers.
• Coordinate efforts with infrastructure in order to deliver the ultimate experience for data analytics delivery for the whole organization
• Encourage and motivate engineers to dig deeper into all things data to bring up the level of proficiency in all things data delivery, data quality as well as how to execute with excellence while following all Progressive policies and procedures as per data governance and compliance areas.
• Review models with engineers and perform logical code review for Google Analytics data and other marketing integration for ThoughtSpot.
• Advise engineers in tuning methodology.
• Lead by example and continue to exhibit progressive values through the organization.
• Participate and lead strategic initiatives requiring quick turn deep technical expertise.
• Coordination upgrade of Analytics & BI Platform with IT Infrastructure and DBA team to ensure optimal delivery for our internal and external customers.
• Ensure efficiencies are obtain while scaling between Power BI Cloud Services and on-premise services to delivery optimal functionality for internal and external customers.
• Problem management via weekly review of all incidents/requests.
• Escalation point for data delivery on hour 24x7 on-call rotation for analytics engineers as we deliver high quality products to our external and internal partners.

Confidential

Lead Engineer - Data Analytics & BI

Responsibilities:

• Partner with Sales/Marketing to gather requirements and determine appropriate end to end solutions.
• Create advance for merchants as needed. For example: Best Buy daily and hourly view, Ashley waterfall, others.
• Work on data integration to extract data for ThoughtSpot platform
• Work on POC for Snowflake cloud data warehouse with Microsoft Stack.
• Materialized objects to reduce compute costs
• Integration between local data warehouse and Snowflake on Azure cloud.
• Write and Leverage JavaScript Store Procedure and user define functions
• Build SSAS tabular cube with snowflake data source
• Transform store procedure from T-SQL to Snowflake compatibility mode.
• Test Microsoft BI stack against snowflake to determine gaps between current stack and future state.
• Prepare data integration flows between merchants like best buy, wayfair,overstock.com,Cricket, Lowe’s and others merchants.
• Apply security and encryption to comply with security procedures, policies and standards: SSH/PGK keys integrations to allow for effective and timely data flow integrations.
• Lead the integration of SSRS via rest-api and service-now for end-to-end subscription platform for the company and deliver timely information to merchants.