Business Systems Analyst Resume Profile
OH
Professional Summary:
- Over 5 years of 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.
- 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.
- 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 complex Formulas, Sub Reports, Summary Reports.
- Involved in Trouble Shooting, Performance tuning of reports and resolving issues within SAP BO.
- Installation, configuration and administration of Crystal reports and SAP BO.
- Deployed the reports and Scheduled Reports for the use of end users and customers.
- 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
- Worked extensively with creating reports as per user requirements using MS Reporting Services 2005/2008R2
- Extensive working experience in Packages, Procedures, Cursors and Triggers.
- 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
Databases : Oracle 8i/9i/10g/11g, MS Access, MS SQL Server 2000/2005/2008R2
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
Business Systems Analyst
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 like flat 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.
- Extensively used data blending in Tableau.
- 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 SQL Index, Views, Complex Stored Procedures, triggers and appropriate User 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 v7/v8, Tableau Desktop v7/v8, Windows Server Standard R2, Clear quest, Clear case, Excel, JAVA, J2EE, SQL Server management studio, MS SQL Server 2008R2, UNIX , Linux RHEL 5.4.
Confidential
Tableau Developer/ Analyst
Responsibilities:
- Involved in creating dashboards and reports in Tableau 6.1.
- Created interactive dashboard and applied actions filter, highlight and URL to dashboard.
- 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.
- Created incremental refreshes for data sources on Tableau server.
- Administered user, user groups, and scheduled instances for reports in Tableau server and documented upgrade plan from Tableau 6.0 to Tableau 6.1
- Created and assisted users in Tableau dashboard development.
- Documented complete server architecture and solutions to troubleshoot performance, scheduling, and server related issues.
- Defined and created procedures to install Tableau desktop in silent mode.
- Defined best practices for Tableau report development.
- Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
- Involved in writing complex SQL queries using table joins inner and outer .
Environment: Tableau Server 6.1, Tableau Desktop 6.1, MYSQL Server, MS SQL Server 2005, MS SQL Server 2008, Oracle 11g, Netezza, Sybase, Crystal XI, Info view, Excel, JAVA, J2EE, Tomcat., TSQL.
Confidential
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.