PROFESSIONAL SUMMARY:

• 7 plus years of extensive experience as a Data Analyst/ BI Report Developer using Tableau / Power BI with hands - on experience in integrating business needs into IT solutions in Agile/ Waterfall environment.
• In-depth knowledge and experience in Classic Waterfall, Agile, Scrum. Agile experience includes working with JIRA, Confluence or other similar tools for Agile project management
• Exposure in interacts with business user and stockholder; coordinated meetings with users during different phases of project.
• Extensive experience in writing Business Requirements Document, System Requirements, Specifications, Functional Requirements Document, developing Use Cases, creating screen mockups, and preparing training manuals.
• Excellent understanding/experience of SDLC, Agile, SCRUM, Waterfall, Spiral, Rapid Application Development (RAD), Prototype and Rational Unified Process (RUP)
• Experienced in Finance and Insurance domains with exposure to Investment Banking, Retail Banking and Global Capital Markets with clients in a few of the most renowned organizations.
• Good exposure of utilizing requirements collaboration techniques; workshops, storyboards, questionnaires, interviews, use cases, scenario descriptions, document walkthroughs, constructive debates, brainstorming and JAD sessions.
• Experience in conducting GAP analysis, documenting Current State (AS-IS), preparing Future State (TO-BE), and preparing Transition Strategies.
• Adept at creating Unified Modeling Language (UML) diagrams such as Use Case Diagram, Activity diagrams, Class diagrams and Sequence diagrams.
• Proficient in Tableau and Power BI data visualization tool to analyze and obtain insights into large datasets, create visually compelling and actionable interactive reports and dashboards.
• Created different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps, Tree maps, etc. using Tableau and Power BI.
• Expert in writing complex SQL Queries for Data analysis, Data Profiling and Data validation
• Experienced and comfortable with motivating teams and building consensus; establishing and implementing strategic initiatives with short-term and long-range objectives. Work history exemplifies skills in interfacing with all levels of management, associates, and customers.
• Ability to critically evaluate the information gathered from multiple sources, reconcile conflicts, and decompose high-level information into details, abstract up from low-level information to a more general understanding.
• QA/Testing experience in reviewing Test Procedures, defining Test cases, reviewing and maintaining Test scripts, analyzing bugs, interacting with team members in fixing errors and User Acceptance Testing (UAT)
• Utilized HP Quality Center 10.0 for Test Requirements, Test Planning, Test Designing, Test Analysis, Test Execution, Defect Tracking and Test Result.
• Managed reporting, analysis and decision-making for a change request by using tools like ClearQuest and Excel

TECHNICAL SKILLS:

OPERATING SYSTEMS: Windows XP/Vista/7/8/10

RDBMS: SQL Server, Oracle, MySQL, Hadoop Hive, Impala and MS-Excel

LANGUAGES: SQL, PL/SQL, T-SQL, VB.NET

WEB TOOLS: HTML, XML

BI TOOLS: Tableau, Power BI

Desktop Software: MS Word, Excel and Power Point

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Data Analyst/Tableau Developer

Responsibilities:

• Identified business requirements and devised implementation strategies to solve the business problems.
• Facilitated meetings for LOB, APP/DEV and SIT/QA team to level set the progress of assigned requirement and provide clarity/transparency on any discrepancy.
• Analyzed business requirements into high level and low-level Use Cases, Activity Diagrams/ State Chart Diagrams following UML methodology.
• Worked closely with Business Analyst, Data Modeler and all team within the organization to understand business processes.
• Performed GAP analysis by identifying existing technologies, documenting the enhancements to meet the end state criteria.
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Analyze source system data to assess data quality. Work with technical and business representatives to determine strategies for handling data anomalies that are identified.
• Led multiple UAT teams by demonstrating strong leadership skills and solely owning the requirements.
• Collected, tracked and organized data to evaluate current business and market trends.
• Coordinated with application developers, and engineers to ensure system functionality.
• Data Masking- Data Creation, masking of sensitive fields and loading masked data in non-production environments.
• Created and presented informational reports for management based on SQL data.
• Designed and implemented SQL queries for QA testing and data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Designed and developed Tableau dashboards using stack bars, bar graphs, scattered plots, Gantt charts.

Environment: Agile, Microsoft SQL Server 2017, Microsoft SQL Server Data Tools 2017, Microsoft Visual Studio 2019, Microsoft Office, CRM, JIRA, Windows 10, Tableau 10.2, Data Masking Tool- Data guise

Confidential, Irving, TX

Data Analyst / Power BI Developer

Responsibilities:

• Responsible for defining the scope of the project, gathering business and system requirement and documenting them textually or within Model.
• Served as scrum master for an onsite team and worked very closely with the business team to resolve requirement issue and convert the requirements into a functional backlog using VersionOne.
• Performed Business Analysis support to Product Owners & Teams during project lifecycle covering elicitation, planning & documentation and aligning to Strategic Objectives resolving business problems.
• Managed & resolved, risk & issues and published weekly project status reports against product roadmap and Provide regular status reports to clients, developers, and management as needed.
• Work on test development efforts and assist clients in user acceptance testing.
• Coached a distributed cross-functional team on Scrum best practices and continuous improvement.
• Removed impediments or helped the team find the right people to remove the impediment.
• Facilitated discussions and team ceremonies, including the daily scrum, product backlog refinement, sprint review, sprint retrospective, and sprint planning.
• Assisted the Product Owner with refining the product backlog.
• Built and published interactive reports and dashboards using Power BI Desktop.
• Built multiple data visualizations using Power BI in the form of interactive reports and dashboards; delivered different visualizations using Slicers, Lines, Pies, Histograms, Maps, Scatter, Bullets, Heat Maps etc.
• Used Power BI, Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Writing complex SQL queries to perform testing of reports.
• Blended data from multiple databases including SQL Server, MS Excel and Oracle SQL database.
• Participated in cross-functional meetings to resolve recurring issues of vendors.
• Interacted with vendors directly through scheduled daily / weekly Business Conversation (Email).

Environment: Microsoft SQL Server 2017, Microsoft SQL Server Data Tools 2017, Power BI Desktop 2.5, Microsoft Visual Studio 2017, Hive / Impala Framework in Hadoop, Scala, Sparks, MS Project, MS Visio

Confidential, St. Louis, MO

Data Analyst

Responsibilities:

• Installation, configuration and maintenance of MS SQL Server.
• Performing Database maintenance activities like Backups, Restoring, and indexing etc.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications using Sybase T-SQL.
• Implemented indexes such as clustered index, non-clustered index, covering index appropriately on data structures to achieve faster data retrieval.
• Designed and developed different type of reports including: Drill through reports, Sub reports, Drill down reports based on business requirement using SSRS.
• Rewrote the existing code for long running queries by replacing cursors with various joins, common table expression (CTE).
• Created SSIS Packages using Pivot Transformation, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data to Excel Spreadsheets.
• Created SSIS packages to get data from various sources (DB2, Oracle).
• Worked with Team foundation server (TFS) offering source control, data collection, reporting, and project tracking.
• Populating a database with new information or transfer existing data into it.
• Creating backup copies of data.
• Daily maintenance of firewall protection and file security.
• Development of web-based interfaces for Oracle databases and web applications.
• Responsible for database security and also preventing data loss
• Perform quality assurance and testing of SQL server environment.
• Provided support by troubleshooting and solving the issues.
• Performance Tuning of SQL Server Databases.
• Managing SQL Server security and logins.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Created Stored Procedures applying to complex business scenarios.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Data Tools, SQL Server Business Intelligence Development Studio (SSIS, SSRS), T-SQL, C#, .Net framework, XML, MS Visual Source Safe and Windows Server 2003.

Confidential, Auburn Hills, MI

Data Analyst

Responsibilities:

• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Slowly Changing Dimension and more.
• Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.
• Involved in designing ETL as a part of Data warehousing and loaded data in to Fact tables using SSIS.
• Supported Production Environment with schedules the packages and makes the package dynamic with SQL Server Package Configuration.
• Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed queries or stored procedures using T-SQL to be used by reports to retrieve information from relational database and data warehouse
• Worked extensively with Advance Analysis Actions, Calculations, Parameters, Background images and Maps.
• Create Common Table expressions (CTE) and temp tables to facilitate the complex the queries
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Developed Query for generating drill down and drill through reports in SSRS.
• Designed new reports and wrote technical documentation, gathered requirements, analyzed data, developed and built SSRS reports and dashboard.
• Developed SQL queries or stored procedures used by reports to retrieve information from relational database and data warehouse.

Environment: Microsoft SQL Server 2012, T-SQL, SQL SSIS, SSAS, SSRS, SQL Profiler, Visual Studio 2008, Visual Intercept Enterprise Edition, Oracle 10g, VB.Net

Confidential, Scottsdale, AZ

Data Analyst

Responsibilities:

• Developed PL/SQL triggers and procedures, functions, packages to provide backend security and data consistency.
• Involved in documenting user requirements, technical specifications and Reporting manuals.
• Involved in PL/SQL code review and modification for the development of new requirements.
• Developing functional, technical documents, advanced coding and bug fixation.
• Developed back-end PL/SQL packages, UNIX shell scripts for data migration and batch processing.
• Involved in writing SQL queries, PL/SQL programming and created new packages and procedures and modified and tuned existing procedure and queries using TOAD.
• Generated server-side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling.
• Created indexes on the tables for faster retrieval of the data to enhance database performance.
• Used Bulk Collections for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Partitioned the fact tables and materialized views to enhance the performance.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.
• Implemented using Forms, Reports, PL/SQL, Flex fields and Workflow.
• Customized, created and documented Forms and Reports in Oracle Projects module using Oracle Forms, Reports and PL/SQL.
• Analyzed, designed and developed Oracle forms 10g queries, layout, report triggers, parameter form, data models etc.
• Designed and developed custom database security in PL/SQL for Oracle versions 9i, and 10g.
• Provided Oracle back end programming including PL/SQL, Oracle Stored Procedure.

Environment: Oracle 9i/10g/11g SQL, PL/SQL, Forms 9i, Reports 9i, SQL*Loader, SQL Navigator, Crystal Reports, TOAD.