SUMMARY

• Around 6 years of experience in the state - of-the-art mission critical and scalable end-to-end (Full life cycle) Data Visualization & Analysis, Business Intelligence/Data Warehousing industry solutions with expertise in Splunk Dashboard,Tableau BI, SAP BO (Business Objects, Crystal Report), Microsoft Office Performance Point Server 2007(PPS), Informatica and Business Objects hands-on experience in analysis, and development for BI project solutions.
• Technically hands-on commercially experience mainly with full range of BI Skills.
• Experience turning research ideas into actionable designs.
• Proficiency with Unix and databases, as well as working knowledge of PERL/ Python.
• Experience working with large, unfiltered data sets.
• Expertise in BI reporting tools & Dashboards Developments & Server Administration.
• Designing, building and deploying, publishing data analysis reports/dashboards for large volumes of data.
• Hands-on experience with suite of products- Server, Desktop .ETL, OLAP analysis and reporting processes using Splunk Dashboard,Tableau, MS SQL Server 2005 and BO. Working knowledge of ETL processes.
• Involved in implementation and maintenance of high performance BI solutions-, ETL, analysis (OLAP).
• Good knowledge of Business Intelligence/Data Warehousing BI-DW Fundamental architecture concepts, dimensional modeling, requirement gathering.
• Strong experience in various top ranked vendor BI specific tools such as Splunk Dashboard, Tableau & BO
• Strong skills with Business Intelligence application stack including Tableau Desktop/Tableau Server Performance Point Server, multi-dimensional cube building, OLAP/MOLAP and have the solid experience in data warehousing/BI environments.
• Proven myself as a dedicated, worth full and energetic well-rounded Business Intelligence/DWH background professional in growth oriented reputed organizations that gives me scope to apply my knowledge and skills and be a member of a team that dynamically works towards success and growth of the organization.
• Good Communication and interpersonal skills.
• Self motivated high-energy person who enjoys challenging assignments and good at working on multiple engagements.
• Versatile team player with excellent analytical and presentation skills.

PROFESSIONAL EXPERIENCE

Confidential - Bellevue, WA

Splunk Dashboard Developer

Responsibilities:

• Involved in reviewing business requirements and analyzing data sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects .
• Created views in Splunk Dashboard that were published to internal team for review and further data analysis and customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand where we have most users vs. least users.
• Projected and forecasted future growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on which states were connected the most.
• Converted charts into Crosstabs for further underlying data analysis in MS Excel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blended data from multiple databases into one report by selecting primary key's from each database for data validation.
• Combined views and reports into interactive dashboards in Splunk that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Splunk Dashboard by connecting live/dynamic and static datasets.
• Developed story telling dashboards in Splunk and published them on to Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Scheduled data refresh on Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately.
• Tested dashboards to ensure data was matching as per the business requirements and if there were any changes in underlying data.
• Participated in meetings, reviews, and user group discussions as well as communicating with stakeholders and business groups.
• Develop and document prototypes to simulate the behavior of a new technique
• Design and monitor tools to measure a particular problem or the contribution of a particular technique over time
• Work closely with a cross functional team to design new features and resolve issues as they arise
• Aggregating dozens of data sources into a big data repository
• Enable us to correlate many data points that had historically been locked away in disparate system

Confidential - Dallas, TX

Tableau Developer

Responsibilities:

• Deep experience with the design and development of Tableau visualization solutions.
• Background in installing and upgrading of Tableau server and server performance tuning for optimization.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.
• Defined best practices for Tableau report development.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server log-ons and security checks.
• Preparing Dashboards using calculations, parameters in Tableau.
• Understanding of relational database structures, theories, principles, and practices.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Excellent analytical, problem solving and debugging skills, with strong ability to quickly learn and comprehend business processes and problems in order to effectively develop technical solutions to their requirement.
• Working on generating various dashboards in Tableau server using various sources such as Teradata.
• Found ways to make graphs and tables visually exciting, and aesthetically pleasing, while at the same time maintaining the accuracy of the core information content that is being communicated
• Involved in license management SLA's with Tableau support.
• Defined and created procedures to install Tableau desktop in silent mode.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Proof-read all documents and maintain accuracy of information and preparing SOP.
• Responsible for Developing a Dashboard and preparing ad-Hock Reporting.

Confidential - Washington, DC

Business Objects /Crystal Reports/System Analyst

Responsibilities:

• Installed and Configured Business Objects development and testing environment.
• Involved in addressing installation issues with client.
• Resolved issues during XIR2 installation.
• Involved in complete SDLC of reports lifecycle.
• Designed proof of concept BOBJ reports for business analysis.
• Involved in designing blueprint solutions for BOBJ roadmap.
• Supported and maintained BO environments through Central Management Console.
• Created hierarchies in universe for drill down reports.
• Designed and developed Web Intelligence reports for Department of Energy external clients.
• Supported report requirements for over 500 users.
• Provided training assistance for super users in WebI functionality.
• Created reporting folders and universe folders.
• Provided roadmap for Business Objects Reports.
• Created Crystal Reports supporting activity tracking management system, case management, budget and resource planning efforts for FERC.
• Performed data analysis on Office of Energy, Office of the General Counsel, Office of Energy Market Regulation, and Office of Administrative Litigation Crystal reports.
• Supported BO environments in dev, test and prod.
• Coordinated day-to-day activities with minimum supervision.
• Modified existing Crystal reports and trained end users on Crystal reports functionality.
• Updated Project Manager on the status of the project and resolved issues related to Business Objects users.
• Performance tuned WebI reports with DBA by running SQL trace.
• Worked in cluster environment flavors of BO deployment.

Confidential - Boston, MA

Business Analyst

Responsibilities:

• Collaborate with business partners to develop the Business Case, Statement of Work, Requirements Specification, and Functional Design documents utilizing the Enterprise Project Management Methodology for Commercial Loan Services line of business.
• Developed the systems implementation project management plan with milestones and steps from procurement of vendors to project implementation and maintenance.
• Develop and maintain sales reporting using in MS Excel queries, SQL in Teradata, and MS Access.
• Created specifications BRD, FTR, Use Cases - for Loan IQ front and middle-end-lending solution enhancements.
• Supported PMO by mentoring specific projects in application of the new SDLC based on the Rational Unified Process, especially from the project management, requirements and architecture perspectives.
• Was responsible for indexing of the tables in the data warehouse.
• Implemented the full project lifecycle phases including requirements gatherings, development and quality assurance.
• Worked with the Business community, Tech Lead and 3rd party vendors in gathering the requirements.
• Functioned as the primary liaison between the business line, operations, and the technical areas throughout the project cycle
• Monitored and assisted in designing and development of Use Cases, Activity Diagrams, Sequence Diagrams, OOAD using UML.
• Created DTS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files.
• Identified, researched, investigated, analyzed, defined and documented business processes and Use Case Scenarios.
• Documented and delivered Functional Specification Document to the project team.
• Assisted with user testing of systems (User Acceptance Testing), developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.