SUMMARY:

• Overall 7 years of IT experience in Business Analysis, System Analysis, Data analysis, Data Modeler, software design, development, testing and maintenance of BI/Data Warehousing environment .
• Sound knowledge of Food Science, Manufacturing, Health Care, Insurance and Financial industries .
• Experience in working with Tableau Desktop, Tableau Server and Tableau Reader in various versions of Tableau 9.x, 8.x, 7.x and other BI technologies like Business Objects, Alteryx, Informatica etc.
• Expertise in designing and developing dashboards using Tableau 9.x/8.x/7.x (Desktop/Server) using data from multiple sources like Oracle, SQL Server, Teradata, DB2 and Flat Files.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile.
• Proficient in gathering requirements and authoring Business Requirement Documents (BRD) into System Requirement Specifications (SRS) and identifying interface and business process specifications.
• Experience in gathering and writing detailed business requirements and translating them into technical specifications and design . Specialized in Healthcare, Telecom, Home Improvement, Banking and Financial Services industry.
• Interaction with the Power Users & Business users during the various stages of the project lifecycle to identify various KPI’s and designed solutions to enhance business decision making.
• Extensive experience in using Tableau functionalities for creating different Requests, Filters, Charts, Interactive Dashboards with page and dashboard Prompts.
• Experience in developing rich interactive Tableau reports and Dashboards using various visualizations like Chart - Box (Drill Down, Drill up & Cyclic Grouping), Heat Maps, Tree Maps, Bubble Charts, Reference Lines, Dual Axes, Line diagrams, Bar Graphs, Geographic Visualizations ( Detailed and filled in maps), etc .
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, Transformations , filters, Pivot tables, prompts, Calculated fields, Sets, Groups, Actions, Parameters etc., in Tableau.
• Extensively worked with various database systems like Oracle, Teradata, MS Access, Flat files, XML and SQL Server.
• Proficient in creating the Design Documents for loading data into Data Warehouse and Data Mart tables.
• Experienced in working with Data modelers to translate Business rules/requirements into conceptual/logical dimensional models and worked with complex de-normalized and normalized data models.
• Outstanding knowledge in writing complex SQL queries, Stored procedures , database tuning, query optimization and resolving key performance issues,.
• Designed the data conversion strategy, development of data mappings and the design of Extraction, Transformation and Load (ETL) routines for migrating data from non-relational or source relational to target relational.

TECHNICAL SKILLS:

Analytical Tools: Tableau (Desktop/ Sever/ Reader), Business Objects, Confidential, SSAS, Google Analytics (Adobe Site Catalyst).

ETL Tools: Data Stage, Informatica, Alteryx, SSIS

Databases: Teradata, Oracle, DB2 UDB, MS-SQL Server

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

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst, Lotus Notes

Document Management: TFS, Documentum, Visual Source Safe, Share point, Ultra Edit

Defect Management tool: Mercury Test Director, HP Quality Center

Methodologies: Kimball/Inmon, Agile, Iterative

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

Languages: SQL, PL/SQL, JavaScript, HTML, Perl, XML.

Operating System: Windows, UNIX (HP-UX, Solaris, AIX), Linux

Scheduling Tools: Control M, AutoSys, ESP Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Austin, TX

Data Analyst

Responsibilities:

• Performed data manipulation, data cleansing and data profiling in the source systems that are required for Dual credit report Data mart.
• Experience with the design and development of Tableau visualization solutions.
• Performed statistical analysis using SQL, SAS, R, and Excel.
• Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.
• Experience with high performance data processing.
• Import, clean, filter and analyze data using tools such as SQL.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked on Big data and involved in ingesting data from multiple sources and Automating the reports by using HIVE.
• Expertise in SQL Server Reporting Services ( Confidential ) with good knowledge on SQL Server Analysis Services (SSAS).
• .Liaising with end-users and 3rd party suppliers.
• Analyzing raw data, drawing conclusions & developing recommendations also writing SQL scripts to manipulate data for data loads and extracts.
• Generated several reports from cube utilizing MDX.
• Applied Master Data Management standards in data conversion, mapping and migration.
• Publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Performing daily system checks, Data entry, and data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Used data analysis techniques to validate business rules and identify low quality for missing data in the existing Data Mart.
• Conducted User Acceptance testing (UAT) and A/B testing worked with users and vendor who build the system.

Environment : SQL/Server, MDX, Tableau, Oracle 10g & 11g, MS-Office, Pivot tables, SSAS, Confidential, Hadoop, Excel, Hive.

Confidential, Hopkins, MN

Business Data Analyst

Responsibilities:

• Work with the businesses and project team members (Architect, Solution Designer, and SME’s) to understand and create reporting solutions. This includes prototyping potential solutions, or modifying existing work to meet new or changing needs through the use of development standards, processes, and tools available to the team.
• Performed data profiling, cleansing, validation, and verification utilizing SSIS tasks and SQL stored procedures.
• Conducted JAD sessions, interacted with the End users on a regular basis for resolving issues pertaining to the reports, attending weekly status meetings.
• Understanding of using structured data, dimensional models or cubes and various forms of ETL for reporting.
• Develop and manage SQL, Python and R code bases for data cleansing and data analysis.
• Created data mapping documents for the worksheets to be built.
• Setup replication clusters with multiple nodes for MySQL and PostgresSQL
• Designed and Developed data mapping procedures ETL -Data Extraction, Data Analysis and Loading process for integrating data using Informatica.
• Developing reports on Confidential on SQL Server … Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Develop ETL to support multiple metric calculations for corporate wide reporting using Cognos.
• Data Stage ETL in development and support of multiple Data warehouse environments.
• Primary development for Data Stage and SSIS ETL work.
• Performance review and tuning for Data Stage and SSIS ETL tool coding, Support for Monthly Data Stage Corporate scorecard loads along with staging loads.
• Performance tuning of Report queries using Teradata explain results.
• Performed Data validation and Data integrity checks on the data mart.
• Working with QC and UAT teams for respect team approvals. Created Complex workbooks and Dashboards by connecting to multiple data source using data blending.
• Used Tableau URL Actions to navigate from the main Dashboard to detail Reports
• Created Advanced Charts using Tableau Desktop like Box and Whisker plots, Bullet charts, Waterfall charts for measuring the Sales growth by different departments within the company.
• Created and edited the update schedules, managed scheduled update tasks on Tableau server.
• Created Tableau dashboards using advance charts, drill downs, stack bars, bar graphs, scattered plots, and geographical maps.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Provided tableau training on the Survey dashboards built to the end users.
• Extensively involved in doing user acceptance testing (UAT).

Environment: Tableau 9.x/8.x, Oracle, SQL Server, Toad, Informatica, Power Designer, Pivot tables, PostgresSQL, Microsoft Office (Word, Access, Excel, Outlook, Project).

Confidential, Scranton, PA

Data Analyst

Responsibilities:

• Stored reformatted data from different Mainframe applications using Informatica (ETL).
• Translated business-reporting requirements into data warehouse architectural design.
• Designed and maintained logical and physical enterprise data warehouse schemas.
• Designed, developed and deployed new data marts along with modifying existing Marts to support additional business requirements.
• Extracted business customer product/revenue data from Express Track systems and consumer product/revenue data. Created naming and system standards for lookup, transformation and target tables. Loaded consolidated data using SQL*Loader in parallel and direct mode.
• Used Business Objects Designer, Reporter and Supervisor.
• Scheduled and monitored transformation processes using Informatica Server Manager.
• Designed, developed and implemented universes using Business Objects and Web intelligence.
• Maintained stored definitions, transformation rules and targets definitions using Informatica repository manager. Generated reports for end client using Query tools.
• Developed data mining to validate various data pulls for accuracy and completeness.
• Involved in meeting with Project owners and project managers to define the scope of the project.
• Followed the Agile methodology for elicitation and representation of requirements based on interaction with the Project owner, SME's and the development team, participated in daily scrum.
• Facilitated requirement sessions, including creation of agendas and recording of action items from meetings and writing meeting minutes.
• Documented the requirements in the form of detailed use cases and sent out the same for inspection to the team.
• Responsible for creating Use case diagrams and process flow diagrams by using tools like MS-Visio.
• Involved in preparing test cases and also involved in reviewing test plans and test scripts developed by QA team to make sure that all requirements are covered in scripts and tested properly.

Environment: Informatica ETL, ER-Win, Shell Scripts, SQL*Loader, Excel, Business Objects 5.0, PowerPivot, Web Intelligence 2.0, BigData, Oracle 7.x/8.0, Windows NT, OBIEE.

Confidential

SQL Developer

Responsibilities:

• Promote emphasis on tools and process to facilitate analytics
• Involved in the development of system test plan which included scope, objectives, resources, timelines etc. of the testing effort.
• Assisted in creation of SQL Server Analysis Services (SSAS) cubes for analysis.
• Analyzed the reporting service tool provided by Microsoft to generate reports using Oracle and SQL as backend and developed a similar application with SharePoint as backend.
• Handled unit and system integration testing
• Prepared a help guide to system usage for the convenience of end users..

Environment : Oracle, SQL Server, Excel, Pivot tables, SQL/PLSQL and Windows 2000.