SUMMARY:

• About 6 years of experience in Software Application Analysis, Design, Development and implementation of web applications.
• Experience as a Business Analyst and Reporting tools (Tableau, SSRS, Power Pivot).
• Experience in Managing and Implementing Agile methodologies and Software Development Life Cycle utilizing Jira, Rally.
• Experience in Confidential Analytics and Confidential Tag Manager. Suggested improvements for tracking, reporting and analysis of performance.
• Assessing the effectiveness of User Stories implemented and updating the plan on the go using problem solving techniques based on the availability of the team.

SKILL:

Agile and Waterfall: Rally and Jira

Databases and Query Languages: Oracle, Confidential Big Query

Graphical User Interface Tools: Visual Studio, ASP.NET

Programming and ObjectOriented Languages: Java, Perl, VB.NET

Reporting Tools: Tableau, SSRS, Power Pivot, Microstratergy

Analytics Tool: Confidential Analytics and Confidential Tag Manager

EXPERIENCE:

Confidential, ElSegundo, CA

Business/Data Analyst

Responsibilities:

• Provide analysis and reporting around all the Financial and accounting data using various tools (SQL, SSRS, and Tableau.
• Manage monthly accounting close efforts, including revenue and deferred revenue account reconciliations, financial audit support etc.
• Define reporting requirements for new business verticals and translate into technical requirements
• Support Confidential Analytics and Confidential Tag manager requests
• Support brand specific adhoc requests
• Provide quarterly audit support for accounting
• Assisted the manager on product backlog by documenting the user stories
• Assisted in providing with cross - functional knowledge to developers and business users
• Developed end user modules for the user about the new system

Environment: SSIS, SQL Server, Tableau, Power BI, Snowflake, Confidential Analytics, Microstratergy, SSRS

Confidential, Long Beach, CA

BI Developer

Responsibilities:

• Created ad-hoc queries and reports as requested and provide on-going analytical support and maintenance for these requests
• Creating and maintaining SQL Server Analysis Services tabular models and SQL Server Reporting
• Services reports in addition to other BI technologies within the full Microsoft SQL Server stack environment
• Work with the business and team to design dimensional models and architect data warehouse enhancements
• Developed parameterized reports and dashboards through Reporting Services from a variety of transactional and data warehouse data sources including Analysis Services Cubes and prepare for online deployment
• Determine testing needed to assure the functionality and integrity of reporting solutions, create test plans, and evaluate testing results taking corrective action as necessary
• Converting existing legacy reporting products and tools to a standardized reporting infrastructure using SQL and Microsoft products
• Created Business Intelligence (BI) dashboards, scorecards and other visualizations using multiple technologies including Microsoft Power BI, Power View, Power Pivot
• Analyze fact, dimensional and hierarchical data to meet appropriate drill down, drill through and decomposition requirements
• In conjunction with data owners and department managers, developed data models and protocols for analyzing production databases to produce advanced, meaningful, and actionable business insights
• Support the transfer of knowledge to team members as appropriate

Environment: Visual Studio, SQL Server, Tableau, Power BI, MS Office Suite (Word, PowerPoint, Excel, Outlook)

Confidential, Alexandria, VA

BI Developer

Responsibilities:

• Coordinated with the DW architects and developers to identify appropriate dimensional modelling, measures and sizing.
• Used various SQL commands like Create, Delete, Update, and Inner, Outer, Left, and Right Joins to update the database and retrieve data for data analysis and validation.
• Used Unified Modeling Language (UML) to prepare Use Cases diagrams, process flow diagrams, sequence diagrams from the gathered requirements and created diagrams using MS Visio.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Organized the Software Design Document and Operational Guide made changes and updates.
• Developed insightful dashboards, and delivery of solutions adhering to BI industry best practices.
• Organized the SDD and Operational Guide made changes and updates
• Assisted the Quality Assurance Lead in the execution of reports and data integrity testing.
• Designed and implemented basic SQL queries for reports / data validation
• Utilized advanced features of Tableau to link data from different connections together on one dashboard and to filter data in multiple views to analyze the status of the tickets

Environment: MS Office Suite (Word, PowerPoint, Excel, Outlook), MS Project, Visio, UML, SharePoint, Tableau Desktop 9.3, Tableau Server 9.3, Oracle 12c

Confidential, Sunnyvale, CA

BA/BI Developer

Responsibilities:

• Organized the Project Plan Document made changes and updates
• Developed Business Process Models to document existing and future business processes and requirements, using Rational Rose
• Performed extensive requirement analysis including Data Analysis and Gap analysis
• Performed User Acceptance Testing (UAT), tracked and managed defects via Quality Center and ensured full signoff from users following the successful completion of the UAT
• Utilized advanced features of Tableau to link data from different connections together on one dashboard and to filter data in multiple views to analyze the status of the tickets
• Designed and deployed rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized for calculating the Time Measurements for each group/queue

Environment: Agile, MS Project/Visio/Access, Rational Rose, Requisite Pro, UML, Tableau 8, Tableau 9, Confidential Big Query, Toad, SQL, Flash 4.0, Quality Center.