SUMMARY

• 7+ years of experience in the field of Information Technology.
• 5 years of experience in Tableau dashboard development and analytics includes experience as a BI Developer and 2 year as a SQL Developer.
• Experience transforming complex business requirements into rich data visualizations using Tableau.
• Experience working with both relational and multidimensional data sources and good understanding of client server architecture.
• Data extraction, creation of metrics, attributes, filters, sets, ranks, parameters, aging bins, reports and dashboards.
• Created advanced chart types, rich data visualizations and complex calculations to present the data in a meaningful way.
• Strong experience working with SQL server databases.
• Experience in all phases of SDLC including requirement gathering, analysis, design, implementation and testing.
• Experience in coordinating with the business users and other interface teams effectively for any kind of requirements/impact analysis.
• Good experience in managing all the change requests, bug fixes and data requests.
• Excellent understanding of concepts like Star - schema, Snowflake Schema using fact and dimension tables
• Having working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating database objects like tables, Constraints, Indexes.
• Knowledge of Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources to targets.
• Working knowledge of Microsoft Office products such as Word, Excel and Visio.
• Excellent presentation, communication and organizational skills.
• A good team player with good analysis, problem-solving ability, verbal and written communication.
• Ability to learn quickly and adapt to new technologies.

TECHNICAL SKILLS

Databases: Oracle 9i/10g/11i, SQL Server 2000/ 2005/2008 , Teradata, Microsoft Access.

Business Intelligence Tools: Tableau 9.0/8.2 / 8.1/ 7.0 , Microsoft BI (SSAS, SSIS & SSRS), Informatica

Languages: C, C#, Java, PL/SQL, T-SQL

Web Technologies: JavaScript, Ajax, HTML, CSS and XML.

Operating Systems: Windows 98/2000/2003/ XP, Windows 2008, UNIX

Applications: Eclipse, NetBeans, Oracle SQL Developer

Office Tools: MS Word, Excel, PowerPoint, MS Outlook

Data Modeling Tools: Star Schema, Snowflake Schema, OLAP, OLTP

PROFESSIONAL EXPERIENCE

Confidential - Naperville, IL

Tableau Consultant

Environment: Tableau 9.0/Oracle/Microsoft Data Cubes/Access/SQL server

Responsibilities:

• BI Analyst responsible for developing and maintaining Tableau dashboards.
• Creation of dashboards for business groups like finance, sales and health care.
• Analysis of business requirements and creation of metrics required for the reports.
• Data extraction, creation of calculated fields, calculated measures, filters, sets, parameters and bins and action filters.
• Working on generating various dashboards using data sources such as Oracle, MS Access, Microsoft SQL Server and Microsoft Analysis Services.
• Designing rich data visualizations of the complex business requirements using advanced chart types and metrics.
• Designing and publishing visually rich and intuitive Tableau dashboards for executive decision making.
• Resolving technical issues and managing all the change requests, bug fixes by delivering it in time without any issues.
• Coordinating with business users effectively for any kind of requirements/impact analysis during the development of reports.
• Maintaining project documentation, enhancements / bug fixes list and user access request approvals for the dashboards.
• Translated business perspectives into technical perspectives and vice-versa.
• Transformed manual reports into automated department KPI dashboards.
• Used analytical methods and tools to extract data to authenticate its validity, applicability, efficiency, and accuracy.
• Provide visual/graphic analysis based on data content.
• Facilitated a common shared vision amongst departments of all deliverables including business, functional, and non-functional requirements.
• Demonstrated proficiency with databases, analytics and business applications.
• Developed and maintain tools to monitor and improve compliance processes and ensure data integrity.
• Conducted Tableau training to inexperienced users and Business Analysts.

Confidential

BI Developer

Environment: MS BI (SSIS, SSAS, SSRS), Tableau 7.0, SQL Server 2000/2008, VS 2003/2008, C#, Asp.net 2.0

Responsibilities:

• BI and web developer responsible for reporting for Confidential finance department.
• Worked with Business Intelligence data visualization tools with specialization on Tableau.
• Interacted with Business users to understand their requirements.
• Analysis of business requirements and providing estimation.
• Developed, Designed and supported interactive Tableau Dashboard reports, delivered them on a timely manner
• Creation of SSIS packages and report generation using SSRS.
• Worked upon full range of Tableau platform capabilities to design and implement proof of concept
• Solutions and created advanced BI visualizations, including complex views and predictive models.
• Translated business perspectives into technical perspectives and vice-versa
• Transformed manual reports into automated department KPI dashboards
• Automation of Payroll journal and accrual entry reports which was manually prepared by the Confidential Finance users.
• Designed and maintained SSRS reports used to analyze timesheet and earning data.
• DB upgrade from including conversion of DTS packages into SSIS packages.
• Running the application process successfully every month and supporting the post process run issues or Queries raised by the users and resolving it in time without any escalation.
• Performance tuning in the complex SQL stored procedures.
• Involved in developing of star schema and snowflake schema dimensional data model.
• Analyzed business process workflows and developed ETL procedures for moving data from source to Target systems.
• Design and maintenance of internal Paycost website to be used by Confidential finance users.
• Disaster Recovery system set up for the application.
• Creation of all project documents, enhancements / bug fixes list and user access request approvals for the application in the project portal and updating the same whenever required.
• Providing complete KT of the application to the new joiners in the team and also ensuring that any change in the Application process is being shared with them.
• Also the changes are documented and shared it with the team for future reference.

Confidential

SQL Developer

Environment: MS SQL Server, SQL Developer, TOAD, SQL * Plus

Responsibilities:

• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Provide database coding to support business applications.
• Perform quality assurance and testing of SQL server environment.
• Develop new processes to facilitate import and normalization, including data file for counterparties.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Worked with internal and external clients for import and normalization of third-party data.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Provide technical support and guidance to staff and clients.
• Generate reports and spreadsheets detailing database changes and performance.