SUMMARY

• Over 8 years of IT experience in Data Warehousing wif Data Modelling, ETL, Data Administration, Data Mining, Data Cleaning and Business Intelligence Tools (Business Objects, Tableau and MSBI).
• Retrieved business data using complex SQL queries, analyzed information, and developed improvement and enhancement solutions based on findings.
• Working noledge on Java and visualization on OOPS concepts.
• Proficient in Data Analysis wif sound noledge in extraction of data from various database sources like MySQL, MSSQL, Oracle, Teradata and other database systems.
• Performed data profiling and analysis in order to craft business and data requirements to deliver quality data to support the business.
• Extensive experience in Tableau Desktop, Server, Reader, Public and Mobile in various versions of Tableau 7/8.1/8.2/9 and Tableau 10.
• Hands on experience wif Tableau Filter Hierarchy especially using Data Source Filters, Context Filters to fine tune dashboards.
• 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, Funnel Charts, Box Plots, Waterfall Charts, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement.
• Assisted in conducting feasibility studies and gave recommendations to meet business needs.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in developing Use Case Model, Analysis Model, Design Model, Implementation Model, Use Case Diagrams, Behavior Diagrams (sequence diagrams, collaboration diagrams, and activity diagrams) based on UML methodology using modeling tools.
• Knowledge on Common Reporting Standards(CRS)
• Strong experience in all phases of Software Development Lifecycle(SDLC) using Waterfall, Agile/Scrum and Software Testing Life Cycle
• Experienced in White Box/ Black Box Testing, UAT, Unit, Integration, Functional, Stress, Load and Interoperability testing
• Strong experience in creating wireframes, mockups using tools like MS Visio and Balsamiq.
• Expert in generatingSub Reports, Standard, Mailing Labels, Cross Tab ReportsandGraph Reportsby usingChart expertof Crystal Reports.
• Experienced in training and mentoring team members wif product, domain noledge and business processes.
• Hands on experience working wif ETL tools -Informatica, IBM Data Stage and SSIS.
• Facilitated optimal internal communications by serving as liaison between services organization and product development, product management, and technical teams.
• Experienced in working wif Business Managers, Architects, End users and all the stake holders in documenting requirements, providing estimates, creating High and Detail Level design specifications.
• TEMPHas noledge on python and AWS services like S3, EC2.
• Analyzed data from Google Analytics tool to create customized reports calculating key performance indicators, metrics and trends
• Experienced in conducting GAP Analysis between the "AS-IS" and the "TO-BE" system. Performed SWOT Analysis and Cost-Benefit Analysis during project inception phase.

TECHNICAL SKILLS

Domain: Banking, US Healthcare, Finance.

Methodologies: Agile/Scrum, Waterfall

Requirement Management Tools: Rational Requisite Pro

Business Modeling Tools: MS Visio, Balsamiq, Rational Rose

Bug Tracking Tools: JIRA, Rally, Bugzilla

ETL Tools: Informatica, Talend, SSIS, IBM Data Stage

Reporting Tools: MS Excel, R, SQL, SAP, Tableau, Crystal Reports, Power BI, Google Analytics

Database: MYSQL, Oracle 11g, SQL Server

Operating Systems: UNIX, LINUX, WINDOWS, MacOS and MS-DOS

Languages: C, C++, Java, HTML, CSS, JavaScript, XML, SQL, R.

Others: Quality Center, ALM, AWS(EC2, S3, ELB, VPC)

PROFESSIONAL EXPERIENCE

Confidential, Kansas City, MO

Senior Business Analyst

Responsibilities:

• Requirements gathering: Interacted wif stakeholders to understand their business structure and needs; documented business, functional, non-functional requirements using interviews, JAD sessions, Focus group
• Escalation: Responded to application technical issues and escalated them on time. Helped the clients understand the complex call center analytics solutions in a simpler manner
• Reporting and Analytics: Developed qualitative and quantitative business metrics reports and dashboards using Tableau on a monthly and yearly basis to make key decisions
• Performed SQL and PL/SQL optimization queries to cleanse and organize large chunks of customer and order data which saved more than 90 minutes of daily cycle time for call center agents
• Responsible for conducting Knowledge Transfer Sessions among onsite/offshore users for technical support and enhancements of the application and mentored new members to speed wif various aspects of the project
• Used Google Analytics to analyze website visitors and increase the number of visitor’s rate and few other metrics.
• Extracted large volumes of data feed from different data sources, performed transformations and loaded the data into various Target systems.
• Developed and reviewed SQL queries wif the use of joins clauses in tableau desktop to validate static and dynamic data for data validation.
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on business change to ensure that the views and dashboards were displaying the changed data accurately
• Schedule data load and refresh by using batch scripts for import from SQL Server and run it in cmd. Scheduling is done using windows scheduler

Environment: BI Applications, Tableau 9.0/10, Windows 8/10, SQL Server 2015, PL/SQL, Oracle 11g/12c, Excel, MS Access.

Confidential, Rochester, MN

Sr Business Analyst

Responsibilities:

• Involved in end to end implementation of the Applications, working directly wif users to gather and document their business requirements to implement those requirements.
• Designed, modeled and implemented Data Warehouse, Data Mart and reporting layout in order to cut down the actual process time performed by operational users.
• Developed ETL scripts to enable weekly/daily processing of data sets into data warehouse.
• Developed, documented and validated complex business rules vital for data transformation.
• Managed the development and execution of test plans and effected corrective action on data quality issues.
• Responsible for Analyzing report requirements and developing the reports by using SQL Queries and using Tableau, MS Excel and Power Point.
• Worked on SQL Server installation & configuration of multiple nodes onAWSEC2 system.
• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created SQL Jobs to scheduleSSIS Packages.
• Worked wif various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Developed Tableau visualizations to support ad-hoc analyses and interacted wif Business users in understanding their requirements.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Designed and developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau Desktop.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Worked in creating different Visualizations in Tableau using Bar charts, Line charts, Pie charts, Maps, Scatter Plot charts, Heat maps and Table reports.
• Sharing and Publishing Tableau Dashboards over Tableau Server. Scheduling Data refreshes of the Published Dashboards/reports.
• Developed several transactional reports using Excel connecting to databases via sql query connections.
• Extensively used Excel advanced functionalities like dashboards, pivot, charts, Vlookups, Sorting, filtering etc. as per business needs.
• Analyze data to determine if there are outliers or data accuracy issues and work wif related departments to make the corrections.
• Fine-tuned SQL Queries for maximum efficiency and performance.

Environment: Tableau Desktop 8/9, Tableau server, Oracle SQL developer, SQL Server 2012/2015, Oracle 10g/11g, PL/SQL, T-SQL, MS Access, Windows 2012 server, Teradata, MS Office 2012.

Confidential, Atlanta, GA

Sr Business Data Analyst

Responsibilities:

• Migrated data from SQL Server 2008 to SQL Server 2012 environment.
• Created and managed databases for clients as well as systems to provide import of client data and reporting of finalized data.
• Created schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation
• Developed scripts to migrate data from multiple sources.
• Maintained the security, integrity and availability of SQL Server.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes
• Involved in designingParameterized Reportsfor generatingAd-Hocreports as per the client requirements using Crystal Reports and Tableau.
• Created reports using Crystal Reports wif Standard, Summary, Cross Tabs, SQL,Command Objects,Selection Criteria, grouping,sub reportsetc.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Designing data models, contributed to the overall design and implementation of the data warehouse. Participated in all data warehouse planning and execution.
• Responsible for implementing and maintaining commercial ETL application(s) and integrating them

Environment: Tableau, Crystal Reports, MS SQL Server 2008/12, SSMS, MySQL, PL/SQL, SSIS, MS Access, MS Office Suite (Word, PowerPoint, Excel).

Confidential

Business Analyst

Responsibilities:

• Interact wif business to gather requirements, prioritize work, develop enhancements to the existing system, coordinate testing, and perform change management/training for Business Objects Reporting and other applications.
• Involved in requirement gathering and preparing functional specification documents.
• Extensively worked on developing several complex SQL queries out of MySQL, MS-SQL and Teradata as per the business requirements.
• Developed, implemented, and executed a quality assurance program and quality control standards for all ETL (SSIS) activities. Performed regular data consistency, quality and reliability checks.
• Designed the Queries using Structures, Cells, Variables, Static & Dynamic Filters, Restricted and Calculated Key Figures in Query Designer.
• Provided go-live support, post- live support, trouble-shooting and problem solving as they arise for the web and mobile banking users.
• Extensively used Functions, Formulas, Variables, Prompts and Input Controls in Web Intelligence reports.
• Worked wif UI team and assisted in creating wireframes and mockups of web pages and user interfaces using Balsamiq
• Extensively worked on ‘OpenDocument’ feature to provide navigation from master to detail Business Objects reports by passing parameters to variables.
• Demonstrated superior coordination of performing Pre-UAT & UAT (User Acceptance Testing) across cross functional teams for end-to-end testing.
• Recommends ways to better use system functionality.
• Prepares comprehensive and effective technical documentation including specifications, test conditions, test pans, and test data.
• Provide on-call support and resolve production issues all scheduled batch cycle runs and any other support.
• Worked along users to perform data analysis.

Environment: SQL Server Enterprise Edition, SQL Server Data Tools, SSIS, MS-SQL, Teradata, MySQL, TFS, UAT, XML and Windows Server 2010

Confidential

System Analyst

Responsibilities:

• Gathered user and business requirements through interviews, surveys, prototyping and observing from subject matter experts.
• Extensively involved in implementing the Software Development Life Cycle phases from identifying requirements to conducting UAT.
• Experience wif SQL Scripting for creating cursors, Database Triggers, Packages, Stored Procedures, Functions, and Management of Schema Objects.
• Worked on performance tuning using indexing and explain plan and hints, index rebuilding, partitioning and dynamic performance views.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Partitioned many tables, which has frequent inserts, updates and deletes to reduce the contention and to improve the performance.
• Used SQL queries for organizing and abstracting data from MS Access databases as well as created reports using SSRS.
• Developed several operational reports on SAP Business Objects as a part of initial proof of concepts.
• Assessed business problems, elicited business objectives and requirements wif management and IT teams on-site.
• Experience wif First Level Testing: Unit Testing and Integrated Testing wif multiple Components.
• Developed the J2EE application wif functions like sorting, wildcard search, filters etc., as per the user requirement.
• Managed the Daily Standup meetings and ensured that quality standards were enforced as per the build-release schedule
• Performed Backend testing by using PL/SQL queries to test the integrity of the application.

Environment: MS SQL Server 2008, MySQL, UAT, PL/SQL, SSRS, MS Access, MS Office Suite (Word, PowerPoint, Excel).