SUMMARY

• Adaptable Data Analyst & Catalog management skilled in recording, interpreting and analyzing data in a fast - paced environment. Advanced proficiency in all aspects of Excel. Experienced in preparing detailed documents and reports while managing complex internal and external data analysis responsibilities.
• Over 5 years of experience as Data Analyst including analysis, design, development and implementation of Data warehouses/business intelligence projects.
• Strong Experience in creating dashboard, reports through Power BI and Tableau.
• Extensive exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Involved in creating dashboards and preparing ad-hoc reporting in Power BI and Tableau.
• Interacts with business user at various levels and coordinated meetings during the different cycles of the project.
• Proficient with Microsoft Suite which includes visualization tool Power BI, ETL Tool (SSIS), SSRS and RDBMS MS SQL server 2014/16 and cloud base Azure SQL DB; designed, developed and published multiple report and dashboard in MS SQL Server/Azure cloud environment
• Experience in working with ETL team on Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory, SSIS, PowerShell
• Good understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling
• Having 2+ years of Power BI development skillset including visualization development, use of parameters, and report optimization
• Strong knowledge of data warehousing methodologies and Agile methodology.
• Created in context filters, quick filters, table calculations, calculated measures and parameters in Power BI also experience working large volume of data.
• Involved in creating different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Power BI and Tableau.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Hands on Experience in performance tuning and query optimization.
• Have good experience in creating advanced chart types, visualizations and complex calculations to manipulate the data as per business need through Power BI.
• Experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions.
• Experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export using ETL tools such as SSIS. Experience in testing and writing SQL statements.
• Hands on experience with MSBI (SSIS) to extract, transform and load data into database.
• Perform Data profiling and analysis of structured and unstructured data in Hadoop environment using Hive / HDFS.
• Part of the end user team where in gathered requirements and organized scrum meetings.
• Prepared projects, dashboards, reports and questions for all JIRA related services.
• Good experience in Migration of Reports & Packages in different environment.
• Proficient in Tableau data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Mastered the ability to design and deploy rich Graphic visualizations using Power BI and Tableau.
• Proficient in creating configuring workflows design in MS SQL server
• In-depth knowledge on SQL queries and working with SQL Server 2014,2016.
• Well versed in query optimization for performance tuning and monitoring of processes.
• Worked on complex KPI scorecards, heat maps, tree views, circle views, bar charts. Data visualizations and interactive dashboard which helped business get a good handle on the team's productivity.
• Worked on data blending and increased the dashboard performance by extracting data.
• Good understanding of technical trends, architectures and highly motivated to know more about latest technology, new software and products.
• Strong commitment to organizational work ethics, value-based decision-making and managerial skills.
• Exposure of end to end SDLC and Agile methodology.
• Good communication and presentation skills works well as an integral part of a team, as well as independently, intellectually flexible and adaptive to change.
• Over 5 year of experience as Business Analyst, Scrum master acted as a liaison between client and technical organization by planning, conducting, and directing the analysis of complex business processes.
• Successfully implemented numerous projects with various risk strategies and ensured on-time delivery as well as quality demonstrated from proven statistics of defect containment and traceability process.
• Ability to adapt to new technology and learn quickly in order to deliver quality product on time.
• Experience in managing a geographically dispersed SCRUM teams positioned in different time zones.
• Complete life cycle experience in SCRUM, AGILE and project life cycle.
• Ability to Organized and facilitated sprint planning, daily stand-up meetings, reviews, retrospectives, release planning, demos and other scrum related meetings.
• Followed Agile best practices by conducting backlog grooming sessions, Sprint planning, and Sprint retrospectives with the development team
• Business-based, business intelligence analyst and scrum master with a passion for data quality and process optimization. Talent for quickly mastering technology to deliver business critical information quickly and accurately.
• Proficient in using Agile Scrum methodologies, performed roles of scrum master following Sprint/standup sessions and used Microsoft Suite extensively to write user stories, analyzed the Iteration Burn Down charts and reviewed defects.
• Project Management Office formulation, enterprise wide multiple project management, process development, lead, mentor and coach using Agile methodologies including Scrum and XP.
• Ability to manage cross functional projects, executed complex endeavors in multiple technology frameworks using onsite / offshore models (J2EE, Web, PEGA, Data migration, Client Server, Mainframe).
• Strong analytical, problem solving, communication and documentation skills, with emphasis on clear, detailed Business Requirement Document (BRD), Functional Specification Document (FSD), as well as reports to keep executive staff and team members informed of goals and project status.
• Business-based, business intelligence analyst and program manager with a passion for data quality and process optimization. Talent for quickly mastering technology to deliver business critical information quickly and accurately.
• Mentored teams through a complete transitioning from SDLC to Agile Scrum. Helped define processes and tools best suited. Focused on customer needs through adherence to Agile Scrum best practices.

TECHNICAL SKILLS

Reporting Tools: Power BI Desktop 2.6, Power BI Service, Power BI Gateway, Power BI Report Server, Tableau Desktop 8.0/9.3 Tableau Server, SQL server reporting services (SSRS), SQL Server Analysis Services (SSAS).

ETL Tools: SQL Server Integration Services, Informatica

Databases: Oracle 10g/11g, MS SQL server 2014/16, Teradata 15, Azure SQL DB

Hadoop Ecosystem: HDFS, Hive

Operating System: Windows

Languages: SQL,SSIS,RDBMS

Others: TOAD, Oracle SQL developer, MS Office, FTP, Control-M, Teradata View Point, Teradata SQL Assistant, Rally, JIRA, GitHub, JSON

PROFESSIONAL EXPERIENCE

Confidential, Edison, CA.

Power BI Developer

Responsibilities:

• Participated in the user requirement gathering and Design meetings.
• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Read source data from HDFS, Azure SQL DB, CSV, ORACLE, SQL Server through Power BI.
• Read different formats of Source data from hive like JSON, ORC, TXT.
• Generated context filters and data source filters while handling large volume of data.
• Hands on experience in utilizing DAX functions which includes Aggregation, Counting, Logical, information, Text and date functions in source data.
• Used DAX table functions including FILTER, ALL, VALUES, DISTINCT and RELATEDTABLE.
• Used Z-order to overlap the reports on each other using Power BI.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Create and customize simple visualizations, Combination charts, Slicers, Map visualizations, Matrixes and tables, Scatter charts, Waterfall and funnel charts, Gauges and single-number cards.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients.
• Created multiple data model and used as a common data source for the reporting purpose.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• In Power BI developed reports by different time intelligence like year to data (YTD), Month to date (MTD), same period last year.
• Closely worked with ETL to implement Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ELT processing
• Analyze source system data to assess data quality using SQL query.
• Experiences in various types of tasks like to load source data in target using SSIS.
• Created Row level security so based on role, the end user can view the data.
• Analyzing reporting requirements and develop various Dashboards, using trend lines and reference lines.
• Created no of views, calculated tables, calculated columns and measures.

Environment: Microsoft Power BI 2.6x, SSIS, SQL Server 2016, ORACLE 11g, SQL Developer, SQL, PowerShell

Confidential, Columbus, IN.

Power BI Developer

Responsibilities:

• Worked with the business users to understand the architecture, data Model, business logic and rules to be applied to meet the business needs.
• Discussed with team to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Created and published Tableau reports utilizing complex calculated fields, table calculations, filters, parameters.
• Participated in building and visualizing dashboards using Power BI
• Used Power BI to generate Power BI combination dashboards and wrote SQL Queries for testing the Power BI dashboard.
• Implemented Extract filters, Calculation Filters, Context filters, Data source filters to exclude certain values or a range of values as well as better performance.
• Created story using sequence of worksheets to convey information using Power BI.
• In Power BI dashboards used different bars and charts like stack bars, bar graphs, scattered plots, Gantt charts.
• Blended data from multiple sources like SQL Server 2014, PostgreSQL, oracle 10g,Teradata into one report by selecting primary keys from each database for data validation.
• Have done advance analysis, through field calculation, table calculation as well as also involved in forecast analysis.
• Used different functions like number, string, date, Type conversions, aggregate functions.
• Created performance recording to improve Power BI’s performance.

Confidential

Business System Analyst

Responsibilities:

• Involved in analyzing and understanding Business Epics.
• Collecting test data for requirements to perform testing.
• Analyze requirements to ensure testability, report gaps and discrepancies.
• Creating and executing test cases for GUI, Sanity, Smoke, Functional and Regression testing.
• Performed Peer review for testing related documents Test cases, Test Plan and Release summary document
• Executing test cases and log defects in JIRA.
• Retest the scenarios post defect fix.
• Adding scenarios, test data and screen shots used for testing to Test Ready User Stories in JIRA.
• Prepared and present weekly status reports to management
• Interacted with offshore team to share & provide required information on planned work items for the sprint.
• Internal review of user stories with management for scenarios/test data/screen shots prior demo.
• Participated in Sprint Demo sessions with business.
• Involved in giving KT to the new member of the team.
• Well versed with Microsoft SharePoint to manage project related documents.
• Involved in Functional Design review meetings.
• Participated in daily offshore & onsite meetings on daily task assignments.
• Involved in Sprint retrospective meetings scheduled at the end of each sprint.
• Coordinated with team members to share work items based on the priority and completed in timely manner
• Maintained good relationship within the team and was active team member
• Involved in Planning & Product Backlog Grooming User Stories with Business Analyst and Team members.
• Participated in Defect Triage call to discuss open defects and Defect clarifications.
• Maintained Defect/Issues/Observations Tracking sheet.

Environment: HP Quality Center, Agile, ALM, Windows XP, MS Excel, MS word, VM ware.

Confidential, Jacksonville, FL.

Business Analyst

Responsibilities:

• Working as a liaison between the business client and development team for the implementation.
• Involved in Planning & Product Backlog Grooming User Stories with Business Analyst and Team members
• Gather requirements, developed Process Model and detailed Business Policies.
• Collaborate with system architects, SMEs, Developers, Business and QAs in the design, development and implementation.
• Analyze business requirements, document business requirements specifications, and document Test Cases and evidences.
• Project Planning, Project Design, Project Scoping, and resource planning & training.
• Coordinating sessions with stakeholders for documenting requirements.
• Played active role during daily scrum meeting and task planning as part of agile methodology
• Participate in weekly assessment meetings with Business Functional Leads and Program manager.
• Performed Task Assignment, Monitoring and Tracking for Team Members.
• Organize and conduct cross training and knowledge sharing sessions for team members to reduce knowledge gap.
• Experience with writing advanced SQL queries.
• Perform Effort and Resource Estimation for the projects/tasks handle.
• Regularly communicate with QA project managers, Development managers, Release managers and Developers to ensure comprehensive test planning and execution.
• Actively participate in status reporting meetings and interact with development managers to discuss the technical issues.
• Prepare Understanding Documents for any existing process change or a new process to be available for reference in future.
• Experienced in documenting and reviewing all testing artifacts and documents with Business analysts and Team members.