SUMMARY

• Over 8 years of experience in Business/Data Analysis, Software Design, Development, Integration, Implementation and Maintenance of Business Intelligence and Database Platforms.
• Over 3 years of extensive Tableau Experience in Enterprise Environment, in Tableau 7.0, 8.0, 8.1 as a Developer and Analyst
• Over 4+ years of experience working with financial and banking applications
• Expertise in administration, design, development, testing, deployment and support of BI Reporting tools and delivering accuracy, efficiency, and responsiveness.
• Experience in working on various SDLC models including Waterfall, RUP and Agile methodologies
• Conducted GAP Analysis, created use cases, workflows and PowerPoint Presentations
• Expertise inSQL Server Integration Services(SSIS)andSQL Server Reporting Services (SSRS)with good knowledge onSQL Server Analysis Services(SSAS)
• Transformed data from one server to other servers usingSQL Server Integration Services(SSIS)
• Vast experience in developing Business requirement documents (BRD), Functional Requirement Specification (FRS), Software Requirement Specification (SRS), Use Case Specifications and Technical Requirements
• Skilled in eliciting user demands and converting them into visualizing models, as well as ensuring that the business goal is met throughout the product lifecycle.
• Mastered the ability to design and deploy rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized using Tableau.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie - Charts, Heat Maps, Bubble Charts, Tree Maps, Box Plots, Bullet Graphs, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Created many METADATA MODELS and followed some best practices for optimizing the performance of the workbooks
• Worked on the development of Dashboard reports for the Key Performance Indicators for the top management and facilitate strategic planning in the organization.
• Prepared creative and interactive dashboards for financial clients, including credit risk dashboards
• Experience in creating and implementing interactive charts, graphs, and other user interface elements
• Excellent understanding of Data modeling (Dimensional & Relational) on concepts like Star-schema, Snowflake schema using fact and dimension tables and relational databases (Oracle), UNIX, MS Access and client/server applications.
• Expertise in delivering data warehousing applications using UNIX, DB2, Oracle, SQL
• Extensive experience in using Normalization and De-Normalization techniques for performance optimization
• Creating Database tables, Primary key, Foreign Key, Unique, Default etc., Indexes
• Created trend reports, service provider functionality, online business intelligence, fleet management systems, Biotech/Pharmaceutical systems and capital markets
• Expertise in PL/SQL and performance tuning SQL queries in TOAD
• Providing technical and analytical expertise in responding to complex, specialized report requests requiring higher-level data analysis and data management services
• Experience in creating Logical Data Models, Data Mapping Documents, Data Dictionaries and Meta Data Specifications
• Good leadership skills, reporting and analytical/problem solving skills with attention to detail
• In depth understanding of the As-Is and To-Be business processes and experience in converting these requirements into Technical Specifications for preparing Test Plans
• Strong interpersonal skills with strong verbal and written communications to maintain effective work relationships with all levels of personnel

TECHNICAL SKILLS

Modeling Languages: Rational Rose, MS Visio, Snagit9, UML

Languages: SQL,PLSQL, C,C++, Shell scripting, .Net, Java

Operating Systems: Windows Vista, XP,7,8,Unix

Databases: MS SQL Server (2005, 2010,2012), Oracle 9i, 10g,11g, DB2, MS Access

Microsoft Tools: MS Office, MS Outlook, MS Project, MS Visio

Project Management Tools: Clear Quest, Rational Requisite Pro, SharePoint, Quality Center, DOORS, Clear Case, Clear View

BI Tools: Tableau 9.0, 8.1, 8.0, 7.0

ETL Tools: Informatica

PROFESSIONAL EXPERIENCE

Confidential - San Francisco

Senior Tableau Developer

Responsibilities:

• Created customized Calculations, Conditions and Filters(Local, Global) for Government Prices Competition and Analytical Solution and dashboards
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Utilized advanced features of Tableau to link data from different connections together on one dashboard and to filter data in multiple views to create the Best Price Dashboard with margin of Profit.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and Parameterized for calculating the AMP value (Actual Manufacturing Price)
• Created Interactive Dashboards for Scenario Modeling vs AMP Calculations
• Created Side by Side bars, Stacked Bars, Heat Maps, Pie Charts, Trend Charts to project the changes of the AMP values and VAT prices for the forecast years for each Drug
• Created Table of Contents (TOC), a common navigation page that had all the links to various reports, like Gross Sales Volume, Ineligible Indirect Sales, Eligible Discounts, Net Eligible sales, all these reports are the metrics for AMP Calculation Report
• Used Action filters, trend charts, custom calculations to create reports on adhoc requests like Creating Report for the Inter year discounts for given products, Contract Management Report
• Actively participated in User Acceptance and training with the Clients
• Provided support for Tableau developed objects and administration.
• Scheduled frequency and time to refresh data when the sources are published or extracted to server.
• Created Custom Hierarchies to meet the Business requirements in Tableau
• Designed and developed various reports and dashboards that can be easily accessible through Tableau App in Ipads, iPhones, and other smart mobile phones
• Converted Accesses Reports to Tableau Dashboards for Advanced Visualizations
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau
• Performed unit testing and performance testing using the SQL Scripts for Tableau reports, Dashboards, Scorecards and handled the performance issues effectively.

Environment: Tableau 8.1, MS Project/Visio/Access, UML, Agile, Oracle 11g, Toad, SQL, Flash 4.0, Quality Center

Confidential, Iowa

Tableau Developer

Responsibilities:

• Developing and maintaining high-level overview of the project and design flows using MS Visio
• Gathered Business Requirements, Interacted with the Users and SMEs to get a better understanding of the Business Processes.
• Worked with senior management, risk management, finance and other functional areas to provide analytics regarding the performance of the Default/Workout portfolio
• Analyzed management and regulatory reports to assess the HAMP program initiatives.
• Prepared monthly/quarterly Agent Reports and Payment Reports after the initial review of the data is completed, and submitting reports in proper format
• Created filter actions to send information to other tableau worksheets and to connect the same in analytical flows, URL actions to connect views of data to external resources and Highlight action to provide rich visual interaction between the views on the sheet
• Developed customized calculations for calculating the APR (Annual Percentage Rate) for the APR Earnings Report
• Designed business intelligence dashboard using Tableau Desktop and publishing the same on Tableau server, allowing Management to view current and past Delinquencies and HAMP, forecast Repayment Plan, and to track loan current state
• The Dashboards included Risk of Loan Default Dashboard, Loan Delinquency Dashboard, Banking Revenue or Capital Dashboard
• Analyzed the source data and handled efficiently by modifying the data types
• Used MS Excel, Word, Access, and Power Point to process data, create reports for Tableau adhoc requests like Quarterly Loan Outgoing Report, Fees Report
• Created extensive joins for data blending from several different data sources
• Created custom Function's (Date range, Time functions, array functions, and Conditional formatting functions), pie charts, parameters for selecting the loan dates and states for the Loan Amount and Outstanding Days by State report
• Created Tableau Extracts of historical data to quickly retrieve information for reports
• Wrote PL/SQL, SQL, and performance tuning SQL queries in TOAD for Customers and Accounts data.
• Supported UAT for the entire mortgage loan related data

Environment: Tableau 8.0, Tableau 7.0, Windows XP, DOORS, MS-Visio, MS-Excel, Oracle, Toad

Confidential, TX

Senior Business Analyst

Responsibilities:

• Worked on account tool and balance bar tool.
• Worked with multiple development teams since I worked on two tools
• Proposed creative features for trading applications
• Employed customized agile software development process through iterations
• Performed test cases at the end of three iterations performing UAT
• Management of time constraints efficiently and meeting the project deadlines.
• Efficiently recorded incomplete features for later releases
• Conducted meetings and interviews with business associates to gather requirements
• Leading members by conducting JAD sessions to engage Subject Matter Experts in business planning, business analysis and business requirement definitions
• Gathered information regarding business problems by leading research
• Created ad-hoc queries to retrieve data from the database using SQL.
• Providing information by analyzing and translating information to IT teams and management
• Designed Use-Case, Active and Sequence diagrams using Unified Modeling Language (UML) methodologies
• Worked with the development teams to assure business requirements are met
• Tracking and managing changes in business requirements and scope of project.
• Effective communication with business customers, upper management, technology specialists and vendors
• Re-engineered business process and built detailed maps for future business process.
• Designed Business Use cases and Functional Requirement Specification
• Experience with Data Extraction, Transformation and Loading (ETL), query enhancement and managing data relationship with IT teams
• Managed Traceability matrix for business, functional and use case requirements.
• Created test plans and User Acceptance Test (UAT) procedures.
• Determine opportunities for modifying business process and problem resolution and proposed for its changes.

Environment: Requirements Analysis, UML, RUP, Use Case Analysis, MS Visio, Rational Rose, Requisite pro, Oracle DB, SQL, ETL, .Net, SIEBLE, CMMI Standards

Confidential, TX

Business Analyst

Responsibilities:

• Involved in all phases of software development life cycle for this project, Agile Methodology
• Conducted daily stand up meetings in the role of a scrum master
• Assisted the manager on product backlog by documenting the user stories
• Managed and prioritized release backlog
• Assisted in providing with cross-functional knowledge to developers and business users
• Tracking and managing requirements changes using Spreadsheets
• Acted as User Acceptance Testing coordinator and monitored business testing and interfaced with the development team regarding defect status and fixes on daily basis
• Also actively participated in UAT testing for the application
• Formulated Excel spreadsheets and charts for analyzing the reports
• Developed end user training modules for training the user about the new system

Environment: Oracle 8.0, PL/SQL, MS Office Suite, UNIX, HTML, PeopleSoft

Confidential

Business Analyst

Responsibilities:

• Involved in developing various screens, Also involved in developing, testing and coding of applications
• Supported various web application related testing efforts, that were outsourced to offshore team
• Involved in all phases of software development life cycle for this project, which used Waterfall
• Interacted with the development team in translating the specifications
• Worked with the team in creating test cases and test plans
• Coordinated unit testing and system testing to ensure a good delivery
• Participated and facilitated in UAT (User Acceptance Testing) to make sure that all the user requirements are met by the application
• Actively participated in the implementation meetings

Environment: MS Access, MS Office, MS PowerPoint, MS Project, JAVA, HTML