SUMMARY

• 7 years of IT experience in analysis, design, and development in teh fields of databases, business intelligence, client server technologies and web - based applications.
• End to end experience in designing and deploying data visualizations using Tableau
• Worked in teh agile methodology-using Scrum, which TEMPhas its primary focus on teh management part of teh software development in small iterations of two weeks sprint.
• Experienced in many aspects of teh SDLC including requirements gathering, proof of concept delivery, Implementation, development, user support and maintenance.
• Extensive experience working on trend reports, service provider functionality, sample assessment, online business intelligence, fleet management systems and capital markets.
• Administered user, user groups, and scheduled instances for reports in Tableau.
• Good knowledge in developing and designing reports through SSRS and Excel
• Worked on teh development of dashboard reports for teh Key Performance Indicators (KPI) for teh top management.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer
• Experience in SQL Server development, analysis, design, development and support of MS SQL Server 2012 and 2008R2.
• Expertise in working on all activities related to development, implementation, administration and support of ETL processes for large scale data warehouses.
• Strong understanding of Data warehouse concepts, ETL, Star Schema, Snowflake, data modeling experience using Normalization, Business Process Analysis, Reengineering, Dimensional Data modeling, FACT and dimensions tables, physical and logical data modeling.
• Extensive experience in PL/SQL and SQL and in performance tuning SQL queries in TOAD.
• Expertise in data extract from different data sources like SQL Server, Google BigQuery, Google Analytics, Microsoft Access, Oracle SQL, flat file etc.

TECHNICAL SKILLS

Languages: C++, SQL, PL/SQL.

Operating Systems: Windows, Linux, UNIX

Databases: SQL server, Oracle, MS Access, My SQL

Visualization Tools: Tableau Desktop 9.2/9.0/8.3, Tableau Server

Other Tools: Informatica Power Centre, SSIS, SSRS, MS Office (Excel, Access, etc.)

PROFESSIONAL EXPERIENCE

Confidential, Wilmington, DE

Tableau Developer

Responsibilities:

• Responsible for planning, defining and designing database/ data warehousing on business requirements and provide documentation.
• Report design, development and distribution, manipulation of raw data into presentation-quality graphs/tables.
• Performed Tableau Server admin duties; add users/groups from active directory; and schedule instances in Tableau Server including weekly data dump.
• Hands on learning wif different ETL tools to get data in shape where it could be connected to Tableau through Tableau Data Extract.
• Expertly handled data modeling (relational, dimensional and star schema) and data retrievals using universes, personal data files, stored procedures and SQL methods.
• Developed POCs by building reports and dashboards using Tableau to demonstrate quick wins.
• Developed different views using Tableau Desktop that were published to teh business stake holders for analysis and customization using filters and actions.
• Created Prompts, customized Calculations, Conditions and Filter (Local, Global) for various analytical reports and dashboards.
• Review teh BSM (Business Scope Management) report to understand teh scope and benefit of teh projects.
• Attend teh BRI (Business Requirement Identification) meeting to understand teh business Requirements.
• Uncover and enable self-service access to employee user experience needs and trending topics, across teh employee lifecycle, via exploratory data analysis
• Track general business activity and provide clear, compelling reports and presentations on a regular basis.
• Restricted data for particular users using Row level security and User filters.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Created schedules and extract teh data into Tableau Data Engine.
• Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight teh value of analytics in Executive decision support control.
• Managed teh Tableau solution architecture, administration and actively managed teh performance and usability. Aligned/standardized team members on best practices around Tableau driven implementations.
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Created and developed Parameterized, Drill Down and AD Hoc Reports using SQL Server 2008 Reports Services (SSRS)

Environment: Tableau 9.2/9.1/9.0/8.3 , Tableau Server, Oracle, PL/SQL, MS Access, SQL Server 2012.

Confidential, Peoria, IL

Informatica Developer

Responsibilities:

• Participated in teh Design Team and user requirement gathering meetings.
• Performed business analysis and requirements per high end users and managers and performed requirement gathering.
• Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, mapplets, transformations, re-usable transformations.
• Created different source definitions to extract data from flat files and relational tables for Informatica Power Centre.
• Used star schema approach for designing of database for teh data warehouse.
• Developed a standard ETL framework to enable teh reusability of similar logic across teh board.
• Created different target definitions using warehouse designer of Informatica Power Center.
• Created different transformations such as joiner transformations, look-up transformations, rank transformations, expressions, aggregators and sequence generator.
• Created stored procedures, packages, triggers, tables, views, synonyms, and test data in Oracle.
• Extracted source data from Oracle, Flat files, XML files using Informatica, and loaded into target Database.
• Created medium to complex PL/SQL stored procedure for Integration wif Informatica using Oracle 10g.
• Developed complex mapping also involving SCD Type-me, Type-II, Type-III mapping in Informatica to load teh data from various sources.
• Extensively transformed teh existing PL/SQL scripts into stored procedures to be used by Informatica Mappings wif teh halp of stored procedure transformations.
• Involved in extensive performance tuning by determining bottlenecks in sources, mappings and sessions.
• Created Models based on teh dimensions, levels and measures required for teh analysis.
• Validate teh data in warehouse and data marts after loading process balancing wif source data.

Environment: Informatica Power Center 9.1, Oracle, MS SQL Server, UNIX

Confidential

SQL Developer

Responsibilities:

• Designed, coded, tested, debugged, and documented complex database programs to ensure that data processing production systems meet user needs.
• Interacted wif internal and external clients to understand requirements, explain issues and prioritize work.
• Worked closely wif end users in designing and creating teh data warehouse for management group using and Erwin.
• Implemented logical and physical database modeling using Erwin tool.
• Enhanced existing programs.
• Created queries in Oracle SQL, stored procedures, and views to store teh data of clients, advisors.
• Created user defined functions, triggers to store data into appropriate tables as and when data arrives and created indexes to teh tables that has least updating to improve teh query performance.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from teh database.
• Performed tuning and optimization of queries for reports that takes longer execution time using MySQL.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.

Environment: MySQL, Microsoft SQL Server 2008 R2 Enterprise Edition, Windows Server, SQL Business Intelligence Development Studio (BIDS), Oracle, Microsoft Visual Studio.