SUMMARY:

• Over Nine plus years of extensive experience in IT industry which includes extensive Functional and Technical experience in Data Analyst,Data Modeling, Data Reconcciliation, Data Warehousing, Business Intelligence (BI), Operational Data Store (ODS) and OLAP, ETL product development.
• Successful career working in very complex organizations, start - up companies ( Confidential and with minimal work direction and guidance.
• Experience in wealth management/ investment management data patterns and trends.
• Outstanding Data Analysis skills including Data Profiling, Data Mapping, Data Mining from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Excellent vendor management in exchanging files, catalogues, setting up meeting, carrying out cadence, investigating updades and through product knowledge documentation.
• Experienced in data warehouses and data marts for business intelligence reporting and data mining along with developing and documenting process flows for business processes.
• Strong understanding of dimensional data modelling, strong SQL optimization capabilities, Metadata Management (Connections, Data Model, VizQL Model).
• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Cognos, Teradata, SAP BW, DataStage, SQL Server, UNIX, DB2, Oracle technologies.
• Hands on experience working with modelling tools such as ERwin, Power Designer, E-R Studio and Visio.
• Highly Proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.
• Actively participated and conducted in JAD sessions with business users, technical leads and with development personnel in all aspects of the SDLC.Expert in documentation of business requirements and system functional specifications, including BRD, FRD, FSD and end to end Traceability Matrix.
• Proficient in creating Tableau scorecards, Tableau dashboards using advance Tableau functions like Calculated fields, Sets, Groups, Parameters, Actions, LOD, Ad hoc Calculations, etc.
• Experience in development of Dashboard reports for the Key Performance Indicators for the top management.
• Good experience in establishing best practices for Enterprise Tableau Environment - application intake and development processes.

TECHNICAL SKILLS:

Reporting Tools:: Tableau(Desktop/Server/Mobile/Public), Cognos

ETL Tools: DataStage, SSAS, Teradata

Databases: Teradata, Oracle, MS SQLServer, DB2, SAP BO

Database Tools: TOAD, Teradata SQL Assistant, DataStudio, SQL Developer

Requirements Management: Requisite Pro, Microsoft Office (Excel, Word, PowerPoint)

Languages: SQL, PL/SQL, HTML, XML, VB, JAVA API, Python

Data Modeling Tools: Power Designer, ERwin, ER Studio, MS Visio

Design/Version Control: UML, Rational Rose, SVN, GitHub

Operating Systems: Windows Server 2003/2008, Linux, Unix (AIX, HP-UX), OS 400

PROFESSIONAL EXPERIENCE:

Confidential, Maple Grove, MN

Sr. BUSINESS DATA ANALYST

• Performed analysis of complex business process/user stories and executed functional and data integrity test cases.

• Utilized technical and functional knowledge of applications and enterprise standards to evaluate and resolve complex testing risks/issues and managed through resolution.
• Partnered closely with BPMO, STAKE HOLDERS, Business partners to develop test strategies, end to end (integration) strategies and acceptance criteria.
• Consulted and partnered with vendors and clients to help them develop proposed solutions to satisfy their product preferences.
• Acted as Lead in the creation, preparation, and conduct of quality assurance reviews and the development and execution with testing of test plans and test scripts.
• Collaborating with data stewards that incorporated processes, policies, guidelines and administrating entire data with compliance.
• Planed and directed quality assurance schedules and assignments and monitored project status in comparison to cost/time projections.
• Have collaborated with reporting team such as, tableau to understanding technical requirements and aling with functional requirements.
• Used Excel VBA to perform statistical and quantitative analysis of wealth management products in terms of macro trends.
• Used XML file to outsource data and move to different source.
• Collaborated with vendors for procurement purposes throughout life cycle of process and carried out cadence in timely fashion.
• Made XML file as a standard file format to share data among different vendors and data team members.
• Imported data from XML to editor and identified data elements for mining and to investigate test cases.
• Hands on experience with tableau tool as a super user.
• Hands on experience with IVR and interface testing experience, including skills based routine testing.
• Ability to co ordinate troubleshooting activities across Lines of Business (LOB)
• Facilitated research and assisted in making recommendations for improvements in application performance management test strategy.
• Supported the incident management process relating to revenue and cost-impacting issues within Confidential
• Served as a mentor/lead and provided training to less experienced staff, and assisted in the development of testing skills for all team members (onsite and off shore).
• Provided communication to project stakeholders and vendor companies in scoping and sizing work efforts.
• Experience with various types and levels of testing (e.g., unit, smoke integration, system, regression) and Test planning and execution is done in ALM and provided various reports using the Dashboard Module.
• Coordinated functional, regression testing efforts as well as coordinating with automation and business teams (UAT) and defined test strategies, test plans, test cycles and test execution timelines with effective collaboration across, project teams, vendors and business teams at all levels for planning, issue identification and resolution, risk mitigation and production implementation.
• Developed testing documents and leads meetings and/or presentations to communicate risks, change controls and testing decisions or recommendations.
• Experience tracking and reporting testing progress, key metrics and issues and follow-through on resolving project, application, testing and environmental issues.
• Financial management and analysis, Investment management and reporting, Economics and Taxation analysis and member of the wealth management skills program.

Environment: MS SQLServer, MS Access, Teradata, Oracle 10g, Oracle 11g, SQL, IVR, XML, MS Visio, MS Office Suite (Word, Excel, PowerPoint), BOEXI, TOAD, Python, Salesforce, IBM CURAM

Confidential, SAINT PAUL, MN

Sr. BUSINESS DATA ANALYST

Responsibilities:

• Analyze EDI 834 ST Enrollment data, check patterns, set in sequence and load.

• Source to target mapping and gather monthly reports in a repository for documentation.
• Reconciliation with the carriers and Confidential data and create test case scenarios.
• Gather, analyze, and documented business requirements.
• Successfully assisted the branch achieve the sales goals in terms of sales profit margin.
• Data Mining after reconciliation and to provide recommendation for the dashboard.
• Data cleanup and sorting after extract from the warehouse.
• Extracted XML files from data warehouse and vendor companies, and converted, compared and reconciled data to check orphan levels.
• Collaborated with metadata managers to oversee and managing data compliance issues within organization.
• Conduct data profiling and gap analysis.
• Excellent vendor management skills and organzing meetings with key contributors.
• Expeienced with metadata workbench administrator to prepare metadata for lineage and analysis, to help create log views, and run services to identify relationships between data sources and jobs.
• Understanding the technical aspect for (tableau) reporting team and changed orders, test plans, scenarios on timely basis and created business requirement and documented for management.
• Help BPMO and stake holders in providing reports and updates weekly.
• Developed functional and technical specifications in refernce to stake holders and vendors.
• Created context diagrams and flowcharts with various teams based on requirements.
• Pull the data from warehouse in XML format and sort according to data elements for ETL processes.
• Tableau super user and have involved in designing dashboard for Helath insurance data and open enrollment data.
• Strong experience in Toad, SQL Server and Excel.
• Experienced working on HDFS for production scalability.
• Utilize the tools built within company and do manual ETL process if necessary.
• Created user stories and acceptance criteria for procurement purposes.
• Write queries, troubleshoot, performance tuning etc other related work performed for greater results.
• Investigated orphans by drill down and gave recommendations for source of carrier orphans.
• Extract data from warehouse with help of TOAD, SQL and SQL Server.
• Hands on experience in BOEXI for reporting purposes.
• Hands on experience in Oracle BI for deriving object-level and data-level security using duty roles.
• Used XML files for exchange of data files with clients and vendors.
• Worked on SAP BO for reporting daily enrollment and stored in the common repository.
• Check Data intergrity, Sequence and trends regularly to maintain consistency in the process.
• Implemented best practices such as naming convention, folder structure, source to target mapping and security.

Environment: SAP BO, MS SQLServer, MS Access, Teradata, Oracle 10g, Oracle 11g, PL/SQL, XML, MS Visio, MS Office Suite (Word, Excel, PowerPoint), BOEXI, TOAD, Python, Salesforce, IBM CURAM

Confidential, Long Beach, CA

BUSINESS /DATA ANALYST

Responsibilities:

• Performed data analysis on daily, weekly, and monthly scheduled data refreshes based on the business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date.

• Worked closely with the business users to identify various KPI’s and designed solutions to enhance business decision-making.
• Gather, analyze, and documented business requirements.
• Actively involved as part of a team for gathering and analyzing the needs of End User Requirement and System Specifications.
• Developed ad hoc Calculations, Statistical functions, Trend lines, Forecasting, Actions, Filters (Quick, Global, Context), Parameters, Groups and sets for various analytical reports and dashboards.
• Created ad hocSQL queries for user reports, executive management reports.
• Performed Data mining for the identification of unusual data records or data errors that require further investigation.
• Participated in weekly meetings, reviews, and user group meeting as well as communicating with stakeholders and business groups.
• Performed troubleshooting and performance tuning of reports and resolving issues within Tableau Server and Reports.
• Worked on HDFS to store data sets reliably, and to stream the data sets at high bandwidth to user application.
• Developed and maintained high level overview of the data flows using MS Visio.
• Developed and modified Business Intelligence analytical reports/dashboards using Tableau Desktop.
• Extensively used advance chart visualizations in Tableau like Dual Axis, Box Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Implemented advanced geographic mapping techniques and used custom images and geo coding to build spatial visualizations of non-geographic data.
• Utilized Tableau visual analytics and best practices like Dashboard structure, view orientation, Sizing and Layout, Data Emphasis, data mining, Highlighting, Color, Fonts, Tooltips, and performance improvement of complex dashboards/reports
• Created user stories and acceptance criteria and also various reports like Master/Detail reports, Cross Tab reports, slice and dice reports, and drill down reports, Charts using Freehand SQL and Stored Procedure as data providers.
• Created very complex Dashboards using Tableau using the drill down, drill across, actions for business steering committee.
• Designed and developed various reports and dashboards that could be easily accessible through Tableau App in iPad, iPhones, and other smart mobile phones.
• Built complex calculations using advanced functions (LOD, ATTR, DATEDIFF, STR, Ifs, OR, Nested Ifs, NOT, AND, SUMIFs, COUNTIF, LOOKUPs, RUNNING SUM, RANK DENSE, and QUICK TABLE Calculations).
• Performed Tableau type conversion functions when connected to relational and SAP BW data sources.
• Designed, developed and modified Interactive Dashboards using actions (filter, highlight, URL) and created guided navigation links within Interactive Dashboards.
• Developed Standard Operating Procedures (SOP) for Monitoring and involved in license management SLA’s with Tableau support.
• Defined best practices for Tableau report/ dashboard development.
• Extensively done ETL process and extracted the data from different source systems like Teradata, Salesforce, MS SQL Server, Flat files, XML.
• Created row level / user level filters and also administered user, user groups, and scheduled instances for reports in Tableau.
• Mentored Power users in creating and modifying worksheets and data visualization dashboards.
• Used TabAdmin and TabCMD commands in creating backups and restoring backups of Tableau repository.

Environment: Tableau 9.x/8.x(Desktop/Server/Mobile), SAP BW, MS SQLServer, Cognos, MS Access, Teradata, PL/SQL, XML, Control-M, Python, MS Visio, MSOffice Suite (Word, Excel, PowerPoint)

Confidential, Towson, MD

Sr. DATA ANALYST

Responsibilities:

• Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.

• Participated in the Business and Specifications requirements gathering sessions and converted it into Design specifications.
• Gather, analyze, and documented business requirements.
• Developed functional and technical specifications.
• Performed Data mining for the identification of unusual data records or data errors that require further investigation.
• Created user stories and acceptance criteria.
• Created context diagrams and flowcharts with various teams based on requirements.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Analyzed requirements for various reports, dashboards, scorecards and created proof of concept / prototype the same using Tableau desktop.
• Defined, created, and managed business and technical specifications, and other project documentation for applications development.
• Mentored business power users to create reports/dashboards using tableau desktop.
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Tableau.
• Involved in created stored procedures, views, and custom SQL queries to import data from SQL server to Tableau.
• Blended data from multiple databases into one report by selecting primary keys from each database for data validation.
• Combined views and reports into interactive dashboards in Tableau Desktop that were presented to Business Users, Program Managers, and End Users.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Identified customer marketing opportunities by applying data mining models and writing advanced T-SQL stored procedures and queries.
• Utilized advance chart visualizations in Tableau like Dual Axis, Box and Whisker Plots, Bullet Graphs, Tree maps, Bubble Charts, Water Fall charts, funnel charts etc., to assist business users in solving complex problems.
• Worked on Motion chart, Bubble chart, Drill down analysis using Tableau desktop.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information
• Created Data Extracts (. TDE), published and scheduled data refreshes (Complete/Incremental) of the same on Tableau Server.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Worked collaboratively with a team of SQL Server developers to build ETL process needed for reporting.

Environment: Tableau 8.x (Desktop/Server), SQL Server, Oracle, Cognos, MS Access, MS Visio, SharePoint, Microsoft Office Suite (Word, Excel, Power Point)

Confidential, Miami, FL

Tableau / SQL/ Data Analyst/ Report Writer

Responsibilities:

• Defined the scope of the project based on the gathered business requirements including documentation of constraints, assumptions, business impacts, project risks and scope exclusions.

• Analyzed existing reports and developed business, functional and/or technical requirement specifications adhering to standard requirement templates.
• Designed and developed analytical reports and dashboards using filters, parameters, sets, bins and implemented visualizations with complex calculations to manipulate the data.
• Interacted with business users and performed Gap Analysis of Client requirements.
• Elicited business solutions to develop SOX compliance into the existing procurement workflow executed through IT channels.
• Worked extensively with MS Visio and Rational tools to document requirements.
• Created AS-IS and TO-BE process flow diagrams.
• Drew upon full range of Tableau platform technologies to design and implement proof of concept solutions and create advanced BI visualizations.
• Generated high detail oriented views using multiple measures, Individual Axes, Dual Axes and Custom Geo-coding.
• Competent in using business intelligence tools of enterprise resource planning, online analytical processing, data mining, etc.
• Created side by side bars, Scatter Plots, Stacked Bars, Heat Maps, Filled Maps and Symbol Maps according to deliverable specifications.
• Developed and maintained dashboards using Tableau Desktop and publish it to Tableau Server to meet business specific challenges.
• Designed and developed workbooks and dashboards those are accessible on different environments like any browser or tablet.
• Developed dashboards for calendar year and fiscal year.
• Incorporated a regional and national comparative / benchmark metrics to give context to Confidential performance.
• Created extensive custom joins for blending data from several different data sources.
• Prepared monthly status reports for Enhancement Requests to the project team that was used in efficient tracking and monitoring of open issues of the project.
• Created batch and incremental refreshes for data sources on Tableau server.
• Coordinated database middleware issues with DBA's, system performance with System Architects.
• Involved in creating and developing test strategies, test cases and test plans for User Acceptance testing (UAT).
• Interacted extensively with offshore development team to make sure that the developed system matches the requirements.

Environment: Tableau 7.x/ 8.x (Desktop/Server), Oracle, Teradata, MicroStrategy, PL/SQL, MS SQL Server, MS Visio, ERwin, Cognos, MS Office Suite (Word, Excel, PowerPoint)

Confidential, Waukegan, IL

Data Analyst

Responsibilities:

• Gathered Business and Specification Requirements from the Business users and Technical team.

• Provided high level Conceptual Data Model to the Business Users once the Business Requirements are evaluated and finalized.
• Conducted user training to produce standard and ad hoc reports.
• Wrote Bteq, SQL scripts for large data pulls and ad hoc reports for analysis.
• Assisted the IT team to develop service oriented architecture (SOA), and data warehouse system to utilize data mining for data analysis.
• Created Conceptual Data Model (CDM), Logical Data Model (LDM) and Physical Data Models (PDM) using ERwin data modeling tool.
• Create source to target mapping documents (design documents) involving the Business rules and transformation rules.
• Reviewed High Level Design (HLD) Documents and Design Specification Documents provided to the ETL technical team once the Logical Data Model is reviewed and approved by the business users.
• Developed SQL, Bteq (Teradata) queries for extracting data from production database and built data structures, reports.
• Worked with BA in updating the source to target mappings (Data Dictionary) including business rules and transformation logic.
• Performed Data Quality Framework (DQF) analysis to filter the source data which violates the defined Business rules. Performed Allowable values and Range Value Checks.
• Coordinated with Business Analysts/Developers/Architects and other team members, attended code reviews and design walk troughs to get a grip of the whole end to end process and suggested changes wherever necessary
• Added multiple checkpoints in the end to end DW process and performed checks to ensure the data flow is as expected, by running queries on the Oracle/SQL Server/Teradata.
• Extracted data from existing data stores, designed departmental reports for performance and response purposes by using Cognos.
• Designed and developed templates, standard reports, master detail reports like list reports, cross-tab reports and chart reports in Cognos 8 Report Studio, Analysis Studio and Query Studio.
• Implemented Filters, Calculations, Conditions, and Graphs & Prompts in ReportNet reports Query Optimization.
• Involved in performance tuning by analyzing and comparing the turnaround times between SQL and Cognos.
• Actively participated in the integration testing which ensured deliverables stand by the business and user requirements.
• Deployed packages, folders and Reports from a development environment to Testing and Production environment.

Environment: ERwin, DataStage, Oracle, Teradata, Cognos, Toad, UNIX, BTEQ, SQL, Teradata,SQLAssistant, MS Office (Word, PowerPoint, Access, Excel, Visio).

Confidential, Grand Rapids, MI

SQL ReportWriter

Responsibilities:

• Gathered functional requirements from business customers, analyzed and transformed them into business intelligence reporting specifications.

• Developed Technical Design Documents.
• Wrote SQL queries in Oracle for data validation, inserting data, updating data, etc..
• Designed DMR models in Cognos 10 Framework Manager.
• Created and published packages for different functional areas and assigned security rules to them in Framework Manager.
• Created list, crosstab and drill through reports for departments like claims, billing, members/subscribers in Cognos 10 Report Studio.
• Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Created Drill through Reports & Master Detail Reports for Merchandising team.
• Used Union, Intersection, and Exception for creating queries.
• Developed various reports on Sales data - MTD, QTD, YTD, last fiscal year, current fiscal year reports, etc..
• Created complex reports that had multiple pages, multiple UI items like lists, charts, graphs, etc..
• Created score cards using Metric Studio.
• Involved with making changes in the reports generated as business requirements changed and carry out validation and verification of the reports.
• Created models in Transformer, built cubes and published cubes to Analysis Studio.
• Involved performance tuning of reports including database tuning and model tuning,
• Interacted with ETL team to gather the requirements for the reporting.
• Trained end users to operate the reports.

Environment: Cognos 10/ 8.4, Transformer, Report Studio, Query Studio, Metric Studio, Oracle 11g, ERwin 4.0, TOAD, DataStage, SQL Server 2005, MS Office Suite (Word, Excel, PowerPoint)

Confidential

Data Analyst

Responsibilities:

• Requirement gathering for various users, interviewing them, and satisfying their exact needs.

• Used Power Designer for data modelling - database logical and physical design.
• Designed ER Diagrams, star schema and snow flake schema.
• Used model marts, forward backward/reverse engineering of ERwin to extract and export data among different databases.
• Importing source definitions. Creating and importing target definitions. Creating the table targets.
• Tested all the business application rules with test & live data and automated.
• Developed & modified database Stored procedures and Functions.
• Involved in testing and fixing bugs on test and On-line data.
• Executed statistical Wealth management data analysis and test on the hypothesis to check the significance level.
• Wrote SQL queries to perform wealth and assest data mining and analysis.
• Managing claims in Salesforce and validating wealth management data.

Environment: Power Designer, SQL Server, PL/SQL, Oracle9i, TOAD, UML