SUMMARY

• Technically skilled and certified Business Intelligence Developer. Adept in ETL, creating dashboard and report by combining data from multiple source systems within Power BI to create executive reports with row level security (RLS) and publishing it to Power BI service to distribute among end user and keeping it update by scheduling gateway refresh.
• Developed mappings to perform Extraction, Transformation and load of source data into Datawarehouse schema using various power center transformations like Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, Stored Procedure, SQL and update strategy to meet business logic in the mappings
• Strong Knowledge on Power BI to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.
• Expert level experience of experience with Microsoft BI stack (SQL Server, SSAS, SSIS, Power BI), specifically developing Analysis Services Tabular model in Power BI using DAX. Strong SSIS Integration experience with dimensional data models and data mapping.
• Performed leadership role in the design, build and deployment of executive - level dashboards and reports
• Experience with Microsoft PowerApps, PowerBI, Flow and Common Data Service
• Combined data from multiple data sources like Oracle database, SQL Server, ODBC, OneDrive, GoogleSheets, Data Lake, Facebook, Linkedin, Jira, ServiceNow, SharePoint to create custom reports.
• Highly skilled in migrating reports from legacy systems like Hyperion, OBIEE to Power BI using Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails, Heat Map etc..
• Extensive experience using data cleansing and reporting techniques using R, Python, SQL, Power BI / Tableau, Advanced Excel - pivot tables, VLOOKUP, SUMIF and charts
• Experienced in writing SQL queries, with expertise in Relational Database Management Systems stored procedures, constraints, querying, joins, keys, indexes, data import/export, triggers, and cursors
• Proficient at interacting with stakeholders, business users and development team through onshore offsite model
• Worked extensively in Agile and Scrum development teams with project stakeholders, SMEs, and staff to understand the requirements and specifications for new applications along with enhancements to the existing applications
• Ability to gather, document Business Requirements and writing Use Cases. Proficiency in SDLC, good understanding of workflow concept, ability to gather and document the 'As-Is' and 'To-Be' process
• Elicited requirements from stakeholders, vendors, consultants, subject matter experts and existing system users using various techniques like JAD sessions, brain storming, one on one sessions.
• Hands-on experience with process modeling techniques using UML - Use Cases, Work Flow Diagrams, Data Flow Models, Swim Lane Diagrams, Sequence Diagrams and Activity Diagrams.
• Excellent analytical skills coupled with interpersonal, communication and self-organizing skills

TECHNICAL SKILLS

Databases: PL/SQL, Oracle SQL, SQL Server 2014

Data Analysis/ETL Tools: Power BI, Tableau, Informatica, Excel, SAS, SSIS

CRM: Salesforce

Web Technologies: HTML, CSS, JavaScript, PHP

Programing Languages: Python, Java

Project Mgmt./ Agile Tools: JIRA, Pivotal Tracker, Git, Jenkins

SDLC: Agile, Scrum, Waterfall

Testing Tools: QTP, HP ALM / Quality Center

OS: Windows, Linux/Unix

Others: AWS, Visio, VBA

PROFESSIONAL EXPERIENCE

Confidential - Stamford, CT

Sr. Data Analytics Engineer

Responsibilities:

• Worked on multiple projects like Travel & Expense Dashboard, ServiceNow Ticketing Metrics Dashboard and BI reports migration project from Hyperion, OBIEE, SWR systems.
• Created complex SQL scripts to extract data from Oracle, SQL Server, AWS Athena, Data Lake to make data available for enterprise reporting
• Gathered and documented business requirement for analytical reports. Participated in requirement meetings and data mapping sessions to understand business needs.
• Made use of Alteryx, Python scripts and SQL queries for Data Analysis and transformation
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
• Extracted data from CRM systems to Staging Area and loaded the data to the target database by ETL process using Informatica Power Center.
• Worked on development and implementation Data Governance and Data management across the organization.
• Used custom visuals, third party connectors, Power Query, Power Apps as part of BI project.
• Created user-friendly and dynamic dashboards and reports with KPIs, heat maps, scatterplots, bar charts, slicers, drill down, drill up etc.
• Utilized Jira to create agile user stories, Log bugs, Track and escalate issues.
• Provided guidance, training, and problem-solving assistance to end users and other team members.
• Created DAX Queries to generate calculated columns and measures in Power BI.
• Created Azure Blob Storage for Import/Export data to/from CSV File
• Published Power BI Reports on Service and provided access in Web clients and mobile apps
• Used Power BI Gateways to schedule dashboard refresh on to keep the reports up to date.
• Installed and configured enterprise Gateway and personal Gateway in Power BI Services.
• Performed monitoring, optimizing of dashboards/reports; troubleshooting dashboard/report problems and outages; scheduling upgrades
• Created technical self-help documents for end users and maintained it in the IT Knowledgebase

Confidential - San Francisco, CA

BI Analyst

Responsibilities:

• Created Different chart objects like Bar Chart, Line Chart, Text Tables, Tree Maps and Scatter Plot to analyze data.
• Utilized Agile Methodology to configure and develop process, standards and procedures.
• Performed GAP analysis to compare the existing system with the proposed system and document new requirements.
• Involved in Designing, Developing and Testing of ETL (Extract, Transformation and Load) strategy to populate data from various source systems feeds using SSIS
• Performed data mining, remapping / validating data with SQL. Utilized Agile Scrum methodology, Jira, Microsoft Office 365 and Zendesk to perform required job functions
• Developed testing suites and rigorously tested newly implemented processes in SQL Server 2014
• Collected and loaded data from Schoolzilla, Naviance and other third-party vendors into Salesforce database
• Supported refinement of annual data collection to ensure the process is as low-burden as possible to users by continually refining collection processes

Confidential - New York, NY

BI Analyst

Responsibilities:

• Worked as with Marketing Team to provide information and analytics on advertisement spend and audience characteristics to support business decisions, growth trends, and measurement
• Gathered and translated requirements using Agile methodology and tracked them into user stories to improve usability
• Performed in-depth analysis of third party datasets using complex SQL queries, visualized results using Power BI
• Analyzed and summarized data utilizing Excel PivotTable and functions like VLOOKUP, COUNTIF, etc. to find the revenue drivers
• Responsible for converting the business requirements into functional and non-functional requirements
• Prepared and analyzed dataset on audience segments across networks to develop strategic recommendations for managerial action
• Performed segmentation and trend analysis of marketing spends by networks to increase retention and targeting of revenue drivers

Confidential

BI Analyst

Responsibilities:

• Performed analysis of structured and unstructured data to investigate manipulations in stock price movement
• Collected data on daily stock market transactions from multiple sources, Exchange, Depository and KYC agencies
• Used SQL queries like joins, unions, group by and aggregate functions to analyze data
• Developed and Published BI reports to Tableau Server for navigating the developed dashboards in web.
• Scheduled the published dashboards from Tableau Server on weekly basis.
• Provided training/demos to users on Tableau Desktop for development.
• Created Data Connections, published on Tableau Server for usage with Operational/Monitoring Dashboards
• Managed and maintained Excel spreadsheets and using advanced formulas such as VLOOKUP, Pivot Table and Pivot reporting to ensure accurate data availability for managers and decision-makers
• Involved in extensive DATA validation using SQL queries and back-end testing
• Assisted with extraction, transformation, and loading (ETL) data from multiple tools to develop valuable metrics and dashboards to assess risk, detect irregularities, and identify trends
• Utilized Agile SDLC methodology, Scrum work flow in Jira and Microsoft Office to perform required job functions
• Generated ad-hoc reports, worked on special projects and supported other operational areas with analysis and recommendations
• Developed Test Plan, Test Cases and Test Scenarios for testing based on Business Requirements, technical specifications and product knowledge
• Conducted User Acceptance Testing, gathered and documented User Manuals and Business Rules