Senior Business analyst and outstanding performer in business intelligence and data science within Finance industry. Proven success in leadership, operational excellence and organizational development with keen understanding of elements of data engineering and business systems. Recognized for inspiring management team members to excel and encouraging creative work environments.
Skills
Business intelligence Tools: Tableau, Qlik Sense, Qlikview, Data Studio, PLX, Power BI, Looker, MS Excel, Google sheets, Data Studio
Data Modeling: Oracle SQL Developer Data Modeler, ER/studio, Erwin Data Modeler
Languages: Python, JavaScript
Databases: Oracle, MS SQL Server, ANSI SQL, Google BigQuery
IDE Tools: SQL developer, Toad, Eclipse, Visual Studio Code
Key Areas: Data Analysis, Business Intelligence, Strategic Planning, Predictive Modeling, Data Modeling, Data Mining, Data Warehousing, OLAP, Data Science, Forecasting and Planning, Business Process Mapping, Competitive analysis, Technical writing, Analytical Problem Solving, Software Engineering, Software Development, Business Analysis, Strategic Planning, Critical Thinking, Customer Service, Communication Skills, Written Communication, Analytical Skills
Work History
Senior Business Analyst, 06/2019 to Current Unisys – Newark, DE,
Translate business needs to technical specifications and compose the SQL queries to mine the essential data from the data warehouse.
Lead the ETL development team to modify pipelines for data extraction of entities if required.
Support the creation of single source of truth for performance monitoring leveraging agreed upon data definitions, create a common data foundation, and semantic layers to be consumed by business.
Deliver highly available, reliable, innovative large-scale data warehousing solutions to facilitate data induction, build optimized aggregates and building reporting solutions.
Provide leadership and expertise to define solutions architecture and strategies at all layers, for next generation reporting platform with high performance and scalability.
Unleash data trends and provide useful insights to the business users by developing various statistical reports and dynamic dashboards using BI tools like Tableau, Data Studio, PLX.
Improve the timeliness for product delivery by following Agile product development methodology.
Assigned tasks to associates, staffed projects and updated all involved parties to enhance optimal business flow.
Synthesized current business intelligence data to produce reports and polished presentations, highlighting findings and recommending changes.
Plan, review and support process and systems change configurations and customization requests
Technologies Used: Standard SQL (Google BigQuery), Tableau, Data Studio, PLX, Google sheets, Clarinet, Pentaho.
Business Analyst, 08/2015 to 05/2018 Western Alliance Bancorporation – Boston, MA,
Capturing and documenting requirements, understanding business impacts and tradeoffs, conducting interviews and workshops, proposing solutions, documentation and process mapping, etc.
Lead developers mine, cleanse, transform data from Oracle database and other static data sources.
Normalize and manage data storage in a data warehouse.
Regulate extraction, transformation and loading processes on data to automate data flow from data source to data warehouse and from data warehouse to the end user reports.
Optimize the ETL process with use of bulk inserts, indexes, query hints and other performance tuning techniques.
Identify patterns, attribute hierarchies and data relationships and organize into data dictionaries, create standardized definitions for metrics and critical metrics.
Implement predictive analytics and linear regression using python to uncover meaningful data insights
Highlight data analytics trends and KPIs by developing and designing visually appealing dynamic dashboards using Tableau and Qlikview.
Reduce dashboard response time by working on optimization techniques to improve availability of dashboards and reports.
Business Intelligence Engineer, 04/2014 to 07/2015 Amazon.Com, Inc. – Smithfield, RI,
Work with product owners for requirement gathering. Analyze and validate the business requirements and create Business requirement documents.
Develop Informatica ETL workflows and transformations for data extraction from relational database to reporting and analytical tools.
Deep dive the extracted data and list down the statistical KPIs to be included in analytical reports and discuss with management to effectively add them in upcoming dashboards.
Evaluate and improve existing reports to reduce end user response time.
Lead ongoing reviews of business processes and develop optimization strategies.
Provide technical guidance, direction and problem solving to engineering team members. Drive technical excellence in software development and solution design.
Improve development methodologies over time. Engage with architects, engineers, BI developers across regions and departments to deliver the program.
Researched, designed and implemented scalable applications for information identification, extraction, analysis, retrieval and indexing.
Technologies Used: Tableau, Qlikview, Informatica Power Center, Oracle, SQL developer, MS Excel.
Data Engineer, 04/2012 to 04/2014 Apex Systems – Austin, TX,
Partner with business users for requirement elicitation and gain functional knowledge of the insurance industry.
Architect the data model for new schema and design the schema for data science requirements.
Develop ETL using oracle PL/SQL packages, procedures to extract data into data warehouse.
Optimize the SQL code by analyzing the explain plan and using query Hints to change default query execution plan.
Develop various statistical and analytical dashboards which focus on major business KPIs and help to establish insights and forecast trends of data over a time period.
Assessed platform statistics to create customized, data-intensive BI analytics.
Design Qlik Sense dashboards and manage Integration of dashboards across different projects.
Define and drive programs and projects relevant to the delivery of BI, reporting, and analytics capabilities.
Monitored assessment software for performance, security and database availability throughout lifecycle.
Resumes, and other information uploaded or provided by the user, are considered User Content governed by our Terms & Conditions. As such, it is not owned by us, and it is the user who retains ownership over such content.
How this resume score could be improved?
Many factors go into creating a strong resume. Here are a few tweaks that could improve the score of this resume:
