SUMMARY

• Over 6 years of Experience in Designing, Analysis, Management in the Business Intelligence Data warehousing, Client Server Technologies, Web - based Applications and Databases and Experience in industries such as Production, Retail, Mining, Inventory and Distribution.
• Experienced in evaluating short-term business needs to support key business goals.
• 6+ years of hands-on experience in tableau, data analysis, and data warehousing.
• Proficient in natural language processing and opens source technologies MS SQL Server for high-performance analytics to enhance business results and decision-making.
• Respectful self-motivator gifted at finding reliable solutions for software issues.
• Good understanding of various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters Using Tableau and MSBI tools like SSIS, SSAS.
• Proficient in developing SQL queries and Stored Procedures using various data sources like MS Access, MySQL, and MS SQL Server databases.
• Quick learner & Self-directed, consistently updating self with emerging trends in the industry.

TECHNICAL SKILLS

• Tableau Desktop
• SQL (MS SQL Server)
• Data Warehousing
• Tableau Admin
• SSRS
• MSSQL
• SSAS
• T-SQL
• Dashboards
• Tableau Data Visualization
• SSIS
• MySQL
• EXCEL
• WORD
• Relational databases

PROFESSIONAL EXPERIENCE

TABLEAU DEVELOPER/BUSINESS ANALYST

Confidential

Responsibilities:

• Requirement gathering from the Business Team.
• Convert functional requirements into technical document as per the business standards.
• Aid in developing a style guide for the development of BI visualizations, design of components, naming of items, data source creation, and naming.
• Provide guidance to IT Infrastructure and Application teams on Architecture’s Frameworks, Patterns, Best Practices, and Programming concepts
• Building and maintaining SQL scripts, indexes, and complex queries for data analysis and extraction.
• Database Management and Data Modeling
• Translation of questions into a visualization which provides insight and answers the questions
• Performing detailed data analysis (i.e. determining the structure, content, and quality of the data through examination of source systems and data samples)
• Creation of sets, groups, parameters, dashboard and dashboard actions, graphs and mappings
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Creation of joins, unions, relationships and data blending
• Good understanding of various reporting objects like Facts, attributes, heierachies, Transformations, filters, prompts, calculated fields, Sets, Groups, Parameters Using Tableau
• Good experience of coordinating with various teams like Deployment, Testing Team to speed up Development process.
• Experience of good client interaction dealing with their requirements.
• Data validation/Reconciliation report generation.
• Experience working with relational and multidimensional database
• Creation and designing ETL (SSIS PACKAGES)
• Creating Multidimensional cubes(SSAS)

DATA ANALYST/DATABASE DEVELOPER

Confidential

Responsibilities:

• Worked extensively in developing Stored Procedures, Functions, Triggers, Views, Cursors, Packages, Exceptions, Joins, Sub Queries and Set Operators.
• Created/managed Projects, Database Views, Data Sources, and Data Connections.
• Efficiently managed time for timely project deadlines as well as ad hoc requests
• Developed supporting and integrating a variety of financial operations systems
• Led meetings with technical peers regarding the solution designs
• Built, customized, and published interactive reports, visualizations, and dashboards with tableau
• Analyzed Existing code and did the impact analysis.
• Created Database Objects like tables, Views, sequences, Synonyms, Stored Procedures, functions, Packages, Cursors, Ref Cursor and Triggers as per the Business requirements.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Wrote SQL Queries using Joins, Sub Queries and correlated Sub Queries to retrieve data from the database
• Involved in the development backend code, altered tables to add new columns, Constraints, Sequences and Indexes as per business requirements.
• Performed DML, DDL Operations as per the Business requirement.
• Created views and prepared the Business Reports.
• Worked under the senior level guidance.

Data Analyst

Confidential

Responsibilities:

• Was responsible for people management, including goal setting and providing performance feedback
• Worked on all aspects of the engineering of the service, including such topics as performance, testing, HA, dashboard design & tuning
• Quickly and effectively diagnosed and responded to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards
• Developed dashboards and visualizations that empower decision-makers
• Performed peer review of code and testing to detect and minimize application problems.
• Developed and provided training to team members and staff on basic utilization and advanced proficiencies, up to and including training others to provide backup to this role/function
• Provided and promoted development guidelines to business (dept.)-based authors
• Interacted directly with Audit Managers and their staff, Business process owners, Finance, and IT to design and implement data analysis solutions.
• Continually re-assessed solutions in efforts to make them more efficient and effective.
• Developed methodologies that allow for efficient and repetitive data extraction processes