SUMMARY

• Over 7+ years of extensive IT experience in Business Analysis, Business Intelligence, Data Warehousing, Data Mining, Data Analysis, Design, Development, Implementation, OLAP and Testing of BI, Database & Data Warehousing applications and Tableau.
• Extensive experience in Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Extensive Tableau Experience in Enterprise Environment and Tableau Administrator Experience including technical support, troubleshooting, report design and monitoring of system usage.
• In - depth knowledge on Tableau Desktop, Tableau Reader and Tableau Server.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.
• End to end experience in designing and deploying data visualizations using Tableau
• Deployed the reports andScheduled Reportsfor the use of end users and customers
• Successfully upgraded Tableau platforms in clustered environment and performed content upgrades.
• Extensive experience working as a Business Intelligence Consultant with specialization in Crystal reports and SAP BO.
• Extensive experience working in Windows, UNIX, LINUX environments.
• Extensively used Business Objects reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, Filters, Ranking, Sections, Graphs and Breaks.
• Experience in creating ad-hoc reports using Business Objects Web Intelligence tools.
• Expertise in working with all modules of SAP Business Objects XIR3/XIR2/6.X/5.X,Crystal Reports 2008
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), Mainframes, MS Access and client/server applications.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Worked with ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Worked extensively with the major functionality of SAP BO ad-hoc reports, Drill down reports, multi-parameterized reports and drill through reports.
• Professional in writing complexFormulas,Sub Reports,Summary Reports.
• Involved inTrouble Shooting, Performance tuning of reportsand resolving issues withinSAP BO.
• Installation, configuration and administration of Crystal reports and SAP BO.
• In depth knowledge of Software Development Life Cycle (SDLC) Phases such as Requirement analysis, Design, Development, Testing and Deployment
• Strong working knowledge in software development methodologies like Rational Unified Process (RUP), Agile, Waterfall across the span of various projects
• Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
• Excellent data-analysis skills and ability to translate specifications into a working Universe and Report
• Experienced in tuning Long running SQL queries for better performance.

TECHNICAL SKILLS

Languages: HTML, PL/SQL, SQL, XML, Java/J2EE

Applications: Oracle SQL Developer

Reporting tools: SQL server 2005/2008 R2 SSAS/SSRS/SSIS, Tableau Desktop, Tableau Server, SAP BO, Crystal Reports

Databases: Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008 R2

RDBMS: MS Access, Teradata

Operating Systems: Windows XP/7/8, MS-DOS, Sun Solaris, Linux

Web/App Servers: Apache Tomcat, Web logic Server 8.1/9.2/10, MS IIS 5/6.0, JBoss

Packages / Tools: MS Office, Toad, Putty, FrontPage 2000.

PROFESSIONAL EXPERIENCE

Confidential, GA

Tableau Developer

Responsibilities:

• Involved in reviewing business requirements andanalyzingdata sources form Excel/Oracle SQL Server for design, development, testing, and production rollover of reporting and analysis projects withinTableauDesktop.
• Created views inTableauDesktop that were published to internal team for review and further data analysisand customization using filters and actions.
• Created Heat Map showing current service subscribers by color that were broken into regions allowing business user to understand wherewe have most users vs.least users.
• Created dashboard using parameters, sets, groups and calculations.
• Created drill down and drill up in worksheets.
• Involved in creating a dual-axis bar chart with multiple measures.
• Created report schedules on Tableau server.
• Projected and forecastedfuture growth in terms of number of subscribers based on upgrading to LTE by developing Area Maps to show details on whichstates were connected the most.
• Converted charts into Crosstabs for further underlying data analysis inMSExcel.
• Created Bullet graphs to determine profit generation by using measures and dimensions data from Oracle SQL Server and MS Excel.
• Blendeddata frommultiple databases into one report by selecting primary key’sfrom each databasefor data validation.
• Combined views and reports into interactive dashboards inTableauDesktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins inTableauDesktopby connecting live/dynamic and static datasets.
• Developed story telling dashboards inTableauDesktop and published them on toTableauServer, 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 onTableauServer for weeklyand monthlyincrementsbased 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 groupdiscussionsas well as communicating with stakeholders and business groups.

Environment: TableauDesktop 7 & 8.1,TableauServer,MS Office Suite,Oracle SQL ServerR2, MS Excel

Confidential, Jacksonville, FL

Tableau Developer

Responsibilities:

• Involved in creating dashboards by extracting data from different sources.
• Created dashboard using parameters, sets, groups and calculations.
• Involved in creating interactive dashboard and applied actions (filter, highlight and URL) to dashboard.
• Involved in creating calculated fields, mapping and hierarchies.
• Created drill through reports in dashboard.
• Involved in creating data blending in case of merging different sources.
• Involved in creating a dual-axis bar chart with multiple measures.
• Involved in extraction, transformation and loading of data directly from different source systems likeflat files, Excel, Oracle and SQL Server.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Performed Tableau type conversion functions when connected to relational data sources.
• Maintained and Installed Tableau Server in all the environments.
• Created incremental refreshes for data sources on Tableau server.
• Monitored VizQL server, Application Server and data server activity to track performance and system stability.
• Ability to authoring on Tableau server by changing mark types and adding filters directly in a web browser.
• 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.
• Created report schedules, data connections, projects, groups in Tableau server.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Involved in creating complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Involved in creation and updates of several SQLIndex, Views, Complex Stored Procedures, triggersand appropriateUser defined functions.
• Used ETL process to Extract, Transform and Load the data into stage area and data warehouse.
• Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.

Environment: Tableau Server v6/v7, Tableau Desktop v7/v6, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX, LINUX

Confidential, Mclean, VA

BO Developer

Responsibilities:

• Involved in gathering business requirements, functional requirements & data specifications
• Migrated reports from BOXI R2 to BOXI R3.
• Designed complex Web Intelligence and Desktop Intelligence Reports.
• Created and tested classes and objects to organize the universe.
• Created complicated reports including sub-reports, graphical reports, formula based and well formatted reports according user requirements.
• Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.
• Created Objects using different Business Objects functionalities like @ prompt in the process of designing the universes.
• Linked the Universes to share the common objects between them.
• Created Alerts in various reports according to user requirement.
• Used Broadcast Agent to schedule the reports depending on the user profile.
• Prepared many other reports by using master details, cross-tabs, slice and dice and drill mode as per the requirement of the end-user.
• Worked on Query Panel, Prompts, Report Layout and Re-formatting.
• Defined Hierarchies in Universe to provide the users with Drill down option in reports and predefined Conditions to use in Business Objects.
• Involved in designing Business Objects Universes, Queries, and Reports.
• Worked closely with the end users and user decision makers to develop the transformation logic to be used in Reports.

Environment: Business Objects XI R2/XIR3 (Desk I, Web I), Import Wizard, Repository, Migration Wizard, Xcelcius, Crystal Reports, SQL server 2005, Oracle 10g.

Confidential, Baltimore, MD

Business Systems Analyst

Responsibilities:

• Liaison between the client and development team to support the client’s data analysis and reporting needs.
• Proficient in discussing and defining project, Gap Analysis with the clients from both a business and technical perspective
• Worked on following applications Business Objects, Enterprise Architect, Toad, PlanView (project management), Microsoft Suite (Word, Excel, PowerPoint, Visio, Access, Project)
• Gather requirements for the listed options risk management system, specifically for index options risk management spreadsheet. Defining requirements for product control and risk management end of day feeds.
• Performed monthly analysis comparing the monthly interest rate calculation to interest income booked to the general ledger.
• Reconcile internal & external financial reports to ensure proper account balance are maintained and accurate data, which are reflected on client accounts.
• Managed the production of cash flow, P&L and balance sheet reports
• Design and develop data conversion programs relating to Oracle Project Contracts and Oracle Work in Process.
• Engaged in analyzing requirements, identifying various individual logical components, expressing the system design through UML diagrams
• Worked on Rational Rose to develop the use cases, class diagrams and sequence diagrams.
• Worked on Requirement Change Management System in Rational Requisite Pro.
• Setting up document hierarchy and standards to define different level of requirement using Rational Requisite Pro.
• Requirements Elicitation, Analysis, Communication, and Validation according to Six Sigma Standards.
• Responsible for executing User Interface Testing, System Testing, Data Quality Testing on the configuration design and prototypes.
• Performed Regression testing for User interface
• Conduct data mapping sessions, and write the required business requirements documentation including use cases.
• Interacted and interviewed customers and business sponsors to gather data requirement.
• Developed detailed auditing and reporting of the current status and history of all components related to a product.
• Translated customer/clients’ needs into new features and new services.

Environment: Rational Suite (Rose, Requisite Pro), Rational Unified Process (RUP), Windows XP/2000, Linux, Oracle, PL/SQL, MS-Project, MS-Office Suite, MS Visio, MS Word, MS Excel.

Confidential, OK

Business Analyst

Responsibilities:

• Conducted requirement gathering using focus groups, document analysis, interviews, prototyping and blueprints for the project
• Involved in Business Process Reengineering (BPR) - analyzed existing business processes and implemented new improved processes
• Did the initial study of Health Care Management to collect customers’ information, data about existing systems Confidential client site, specific customer requirements for the Electronic Data Management System
• Used Crystal Reports for querying underlying database tables
• Involved in designing of the system with the system architecture and the development team, implementing technology based solutions
• Designed user interface for PHTS and process flows to control the patient records and Information Management System to secure PII - Personal identification information similar to LaboratoryManagement System (LIS)
• Written all Business requirements and Functional/Non functional requirement.
• Worked on Workflow of the project, concentrating on Current and Future Workflow Description, Created Use cases diagrams using Visio
• Developed Sequence Diagrams, Activity Diagrams
• Designed and implemented basic SQL queries for QA - Quality Assurance testing and report / data validation
• Conducted JAD sessions between the end users and the development team, Point of sales (POS) team, Business Team
• Performed User Acceptance Testing (UAT) and describing the bugs to the development team
• Coordinated between the on-site coordinator and development team Confidential Offshore to derive correct requirements for the product
• Responsible for directing analysis and need assessments to get the present manual medical records and translates them to Electronic Health Records.
• Helped to develop a Knowledge Management (KM) portal subsystem, for doctors to keep abreast of the latest evolutions
• Understood the Business Logic, User Requirements and test-objectives to develop Use Case, Test plans, Test cases, Scenarios to reevaluate the Business Process and models
• Co-authored detailed Business requirement document (BRD) and Functional architecture and solution Specification Document

Environment: Use cases, JAD, Interview, KM, SQL, Oracle 10G, Clear Quest, Clear case, MS EXCEL, MS Access, MS power point, DOORS, Microsoft Vision, Mercury Quality center, statistics, BPR, Toad, HIPAA, Functional Analysis,