SUMMARY:

• Over 7 years of experience in Data warehousing and Business Intelligence technologies along with around 3 years of data visualization using Tableau .
• Expertise in Tableau 9,10,10.2, Business Objects 4. 1, and SAP Business Intelligence 7 .
• Experience in requirement gathering/analysis, design, development, testing, and production rollover, post - production support/maintenance, documentation and end-user training.
• Hands on experience on Tableau Desktop versions 9, 10 Tableau Reader and Tableau Server.
• Experience in producing attractive visuals/dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Proficient in troubleshooting of performance issues which were associated with Tableau reports and administration tasks such as publishing workbooks, setting permissions, managing ownerships
• Experience in providing access to the users and adding them to the specific group and schedule instances for reports in Tableau Server.
• Expert in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T- SQL DDL/DML statements for various applications.
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data WareHouse using SSIS.
• Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS:

Programming Languages: C#, CSS, HTML, Java Script, T-SQL, PL/SQL

Databases: MS SQL Server 2014/2012/2008 R2, MS Access, Oracle 10g/11g

BI Tools: Tableau Desktop 8.2,9,10, Business Objects 4.0, 4.1 and SAP BI 7, SSRS

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2003/2007, Rational Rose

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

BI / Tableau Developer

Responsibilities:

• Work closely with Business users, interact with ETL developers, Project Managers, and members of the QA teams.
• Design, develop, test, and maintain Tableau functional reports based on user requirements.
• Convert existing BO and SSRS reports to tableau dashboards.
• Develop Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Work extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps, Trend Lines, Statistics and table calculations.
• Provide Production support to Tableau users and wrote Custom SQL to support business requirements.
• Utilize Tableau server to publish and share the reports with the business users.
• Hands on building Groups, hierarchies, Sets to create detail level summary reports and Dashboard using KPI's
• Create Parameterized, Linked, Snapshot, Cached, Ad hoc, Click through, Drill down, Drill through, Sub reports for HR Department.

Environment: Tableau 9, 10, Business Object 5x, SQL Server 2012. SQL Server Data Tools for SSRS, Jazz source control

Confidential, Bethesda, MD

BI/ Data Warehouse Developer

Responsibilities:

• Implemented Slowly Changing Dimension (SCD) type 2 to maintain historical data in data warehouse using SSIS.
• Created Parent SSIS Package that handles the launching of packages, the sequencing of package execution and populates global project variables used within child packages.
• Worked closely with the business users in defining and documenting reporting requirements in order to design, develop and maintain reports using SSRS.
• Worked extensively in writing and debugging complex stored procedures, triggers, inner joins, outer joins, views and user-defined functions.
• Created and Schedule Jobs for Packages, Reports, Stored Procedure using SQL Server Agent.
• T rained Business Analysts and Data Analysts on basic query writing.

Environment: SQL Server 2012/2008 R2, T-SQL, ETL, C#, SSIS, SSRS, SSAS, MS Excel, Visual Studio 2012/2010/2008, TFS

Confidential, San Diego, CA

BI/ Data Warehouse Developer

Responsibilities:

• Involved in complete SDLC including requirement specifications, analysis, design and development & testing of application.
• Designed SSIS packages to extract data from various data sources into SQL Server 2008 R2 for data warehousing, data analysis and reporting by using multiple transformations such as data conversion, conditional split, bulk insert, merge, union all and lookup.
• Implemented Event Handlers, Error Handling and configuring connection managers in SSIS packages.
• Involved in report design and coding for standard tabular type reports, including drill down and drill through functionality and graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Analyzed database performance with SQL query manager and Optimize indexes to significantly improve queries.
• Tested applications for performance, data integrity, validation issues, job scheduling and alerts.
• Documented all packages and apply Naming Standards for future references.

Environment: SQL Server 2012/2008, T-SQL, ETL, C#, SSIS, SSRS, SSAS, MS Excel, Visual Studio 2012/2010/2008, TFS, WhereScape Red

Confidential, Fairfax, VA

SQL Server/ ETL Developer

Responsibilities:

• Worked with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Designed and developed the Staging Database and load sources to staging and from staging to the Destination (Entity) tables.
• Developed complex T -SQL queries and design SSIS packages to load the data into warehouse.
• Created SSIS Packages using Lookup, Derived Columns, Condition Split, Data Conversion, Multicast, Aggregate, Execute SQL Task and Data Flow Task etc. to generate underlying data for the reports and to export data.
• Extracted data from Flat files, Excel, SAP, RDBS sources like Oracle and SQL Server.
• Scheduled Jobs on various stored procedures and packages to automate processes.
• Created Store Views, Stored Procedures, Functions and Triggers for retrieval and update of data in the database.

Environment: SQL Server 2008/2005, T-SQL, ETL, C#, SSIS, SSRS, SSAS, MS Excel, Visual Studio 2008, TFS