SUMMARY:

• Overall 8 + years of total IT experience in Analysis, Design, Development, Testing and Implementation of Business Intelligence, Data Warehousing and Legacy Applications.
• Extensive experience working wif Business Intelligence & data visualization tools like Tableau 6.0/7.0/8x, SQL.
• 3 + years of extensive Tableau Experience in Enterprise Environment (Tableau 7.0/ 8.x) and Tableau Administration.
• 4 Years of Extensive development and working experience wif different BI tools.
• Experience wif teh Design and Development of Tableau visualization and Dashboard solutions using Tableau Desktop.
• Mastered teh ability to design and deploy rich Graphic visualizations wif Drill Down and Drop down menu option and Parameterized using Tableau.
• Extensive experience in various reporting objects like Hierarchies, Filters, Calculated fields, Sets, Groups, Parameters etc., in Tableau.
• Worked on teh development of Dashboard reports for teh Key Performance Indicators for teh top management.
• Experience in creating different visualizations using Bars, Lines, Pies, Maps, Scatter plots, Gantts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.
• Experience wif creation of users, groups, projects, workbooks and teh appropriate permission sets for Tableau server logons and security checks.
• Experience in administrative and support activities across a multi - environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Experience in Performance Tuning by analyzing and comparing teh turnaround times between SQL and Tableau.
• Experience in Reports Deployment and Reports Scheduling for teh use of end users and customers.
• Experience in developing Relational and Multi dimensional models .
• Extensive experience working in Windows, UNIX, LINUX environments.
• Experienced in tuning long running SQL queries for better performance.
• Strong knowledge of Dimensional Data Modeling, Star Schema Modeling, Snowflake Schema Modeling, FACT and Dimensions Tables.
• Experience working wif Informatica PowerCenter 9.x/8.x. Designed complex ETL mappings like slowly changing dimensions, performed critical performance tweaking stages wif partitioning, persistent cache and extensive use of mapplets.
• Experience in Integration of various data sources like Oracle, MS SQL Server, IBM DB2 and Teradata.
• Experienced in application development using Teradata utilities BTEQ, Fastload, Multiload and Fastexport.
• Good Independent / team working skills and experiences, excellent communication skills wif very good customer handling capabilities.
• Worked on Agile-scrum and Waterfall methodologies.

TECHNICAL SKILLS:

BI Reporting Tools: TABLEAU 8.x/7.0, COGNOS 10.x BI and COGNOS 8.x Suite.

ETL: InformaticaPowerCenter9.x/8.x

Languages: COBOL, PL/me, JCL, C, SQL, HTML, UNIX Shell Scripting and DYL280.

Database: IMS DB, DB2, Oracle 10g/9i, MS SQL Server, Teradata.

OLTP: IMS DC, CICS

Tools: Changeman, Endevor, File-Aid, SPUFI, QMF, Teradata SQL Assistant 13.10, TOAD 8.0

Scheduling Tools: Control-M, CA-7, Unicenter Workload Manager & Autosys.

Project Management: MS Project, MS Word, Excel, Visio and Power Point.

Others: Rational (Clear Quest and Quality Manager), HP QC, Share-point and Service Center.

Operating System: MVS, UNIX, DOS & Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN.

Tableau Developer

Responsibilities:

• Involved in business requirements gathering and translated them into requirement specifications.
• Prepared functional and technical specification documents.
• Presented teh Functional Design wif Stakeholders for teh sign off.
• Developed Tableau dashboards and worksheets using action filters, parameters and calculated fields.
• Applied Context filters, quick filters and global filters in dashboards and worksheets development.
• Developed dashboards & worksheets from various data sources (SQL server, spreadsheets etc).
• Developed Tableau data visualization using Pie Charts, Bar Charts, Line charts, Cross-tab, Maps, Scatter Plots, Bubbles, Heat and Highlight tables.
• Implemented Binning & Blending concepts in Tableau worksheets.
• Worked on Dual Axis concept while working wif Tableau worksheets.
• Created Groups, Sets, Hierarchy's on Tableau worksheets.
• Involved in trouble shooting of performance issues which was associated wif Tableau reports.
• Coordinated wif integration teams during system testing, UAT & Go-Live.
• Provide UAT support to teh business users during UAT Phase.
• Implementation of teh project in all teh environments.
• Recording and managing project issues and escalating where necessary.
• Work closely wif stake holders to secure acceptance and approval of deliverables from teh Project
• Involved in administrative and support activities across a multi-environment Tableau infrastructure including security administration, release management, troubleshooting and general systems maintenance.
• Managed creation of users, groups, projects, workbooks, licenses and teh appropriate permission sets for Tableau server logons and security checks.
• Created extract / report refresh schedules and monitored teh tasks daily on teh server.
• Performed production readiness audit of tableau applications.
• Monitoring Tableau server performances on different environments.

Environment: Tableau 8.x, MSSQL Server 2008, MS Excel and Power Point.

Confidential, Tampa, FL

Tableau Developer

Responsibilities:

• Involved in business requirements gathering and translated them into reporting needs including documenting.
• Prepared functional and technical specification documents.
• Designing, developing, testing and maintaining Tableau reports and dashboards based on user requirements.
• Presented teh report Design wif Stakeholders for teh sign off.
• Created complex reports utilizing teh features like hierarchy, New Calculated Columns, Drill functionality, Tables, graphs, line Charts and Bar Charts.
• Created Parameters to achieve desired functionality.
• Implemented Binning & Blending concepts in my Tableau Reports.
• Worked on Dual Axis concept while working wif reports.
• Created Filters, Groups, Sets on Tableau Reports.
• Involved in trouble shooting of performance issues which was associated wif Tableau reports.
• Utilized Tableau server to publish and share teh reports wif teh business users. Also involved in administration tasks such as providing access to teh users and adding them to teh specific group.
• Coordinate wif integration teams during system testing, UAT & Go-Live.
• Provide UAT support to teh business users during UAT Phase.
• Implementation of teh project in all teh environments.
• Recording and managing project issues and escalating where necessary.
• Work closely wif stake holders to secure acceptance and approval of deliverables from teh Project
• Managed creation of users, groups, projects, workbooks, licenses and teh appropriate permission sets for Tableau server logons and security checks.
• Created extract / report refresh schedules and monitored teh tasks daily on teh server.
• Performed production readiness audit of tableau applications.

Environment: Tableau 7.0, DB2, Oracle 10g, MS Excel and Power Point.

Confidential, Indianapolis, IN

ETL / BI Consultant

Responsibilities:

• Interacted wif business representatives for requirement analysis and to define business and functional specifications.
• Extraction, Transformation and Loading of Data from Sources such as Teradata, Mainframe dataset, Excel Spreadsheets and Text Files using Informatica.
• Performance tuning of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Created customizable mapping by passing parameters at session level.
• Used Teradata Utilities and query performance tuning techniques like collect stats to improve teh performance of jobs.
• Production support existing jobs in teh data warehouse.
• Interacted wif teh customer wif regular project update and hosted status report meetings.
• Extensively used Teradata Utilities like BTEQ, Fast export for teh creation of reports.
• Worked on Cognos Reports for teh creation of state specific reports.
• Generated various List Reports, Grouped Reports, Cross tab Reports, Chart Reports, Master-Detail Reports, Drill-Up/Drill-Down and Drill-Through Reports.
• Applied Prompts, Cascading Prompts pages, Conditions, Filters and Calculations for reports in Report Studio.
• Generated reports using Conditional Formatting, Conditional Block Reports Using String and Boolean variables.
• Using User Prompts, Conditions and Filters for various reports to specify teh reporting parameters.
• Modified existing shell script to suite teh existing business logic and developed teh utility script to archive, move and copy files and also to automate teh batch jobs.
• Developed UNIX shell scripts to automate manual tasks.

Environment: InformaticaPowerCenter 9.1.0, Teradata 13.10, Teradata SQL Assistant 13.10, BTEQ scripting, Cognos 10.0 BI (Framework Manager, Report Studio, Analysis Studio, Query Studio), Unix Shell Scripting, Workload Manager.

Confidential, NJ

SQLDeveloper

Responsibilities:

• Designed, Coded, Tested, Implemented teh Stored Procedures to support teh System.
• Fixed bugs in teh existing in-house developed Software, which is used to upload teh reports for teh end users to view teh reports.
• Designed coded and tested several SQL Queries to Support teh System.
• Fixed bugs in teh software dat was used to support teh healthcare system.
• Designed, Coded, Tested, Implemented Stored Procedures to get data for teh reports.
• Designed teh reports using Crystal reports And SSRS to create reports for teh end users.
• Created ad-hoc reports, drill down, and drill through reports using Crystal Reports and SSRS.
• Scheduled meetings wif teh end users and business owners and gatheird requirements for teh system.
• Developed triggers on tables to support teh system.
• Created and configured SQL mail to send mail as events occur.
• Used teh SQL profiler to trace teh data and thus troubleshoot effectively.

Environment: SQL Server 2008, MS Visio, Erwin Visual studio 2008, NET Framework, PowerBuilder, Crystal reports, SSRS.

Confidential, Irving, TX

SQLDeveloper

Responsibilities:

• Created detailed design and requirements documents wif logic to help team members understand teh requirements and design.
• Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
• Gather requirements and design of data warehouse and data mart entities.
• Built Data marts (Fact and Dimension tables) from teh warehouse tables.
• Understanding Customer requirement via interaction and writing functional specifications.
• Involved in creation of Dimensions using Star and Snow Flake Schema.
• Developed OLAP Cubes, Dimensions, Data Source View, Partitions and Aggregations.
• Responsible for identifying and defining Data Source and Data Source Views.
• Defined attribute properties in a Parent ChildDimensions.
• Installed, configured and maintained SQL Server Integration Services.
• Maintained Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, Locks and performance of SQL Server.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Incremental and full database recovery wif experience of complex recovery scenarios.
• Designed, added, eliminated and maintained indexes, organized tables, recommended changes to application development team.

Environment: MS SQL Server 2005/2008, Windows Server 2008, Windows 7.