SUMMARY:

• 8 years of experience in gathering Business Requirements, Analysis, Design, Development, Testing, Implementations and Documentation of various functionalities of Data Warehouse / Data Marts and Business Intelligence.
• Extensive experience in Installation, configuration, upgrade (simple Configuration, 3 - server and 5-Server Cluster) and administration of Tableau Desktop/Server.
• Solid understand of SQL and understand and have worked with various data source types like Oracle, Neteeza, SQL server, in Linux and unix scripts also
• Expert in Strong understanding of dimensional data modeling, Strong SQL optimization capabilities, Metadata Management(Connections, Data Model, VizQL Model).
• Skilled in Tableau Desktop for data visualization, Reporting and Analysis; Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Proficient in creating Calculations (Cube Calculations, Hide Columns, Creating/using Parameters, Table Calculations, Totals) and Formatting (Annotations, Layout Containers, Mark Labels, Mar Card Changes, Rich Text Formatting, Shared Encoding) using Tableau Desktop.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like barGraphs, scatter plots, pie-charts, geographic visualization and other making use of actions, other local andGlobal filters according to the end user requirement. Extensively involved in Reverse-Engineering and Business Rules Extraction Expert in project planning,
• Strategic planning, systems analysis and troubleshooting, quality control, forecasting, scheduling and planningAnd tracking of results.
• Experience in configuring reports from different data sources using data blending.
• Implemented Tableau/oracle BI security at the Data (Data security) and object (Roles and Permissions) security.
• Supporting and helping users for mortgage application for reports and dashboard report on weekly and monthly
• Expert in tableau server commands like synchronization, Tabcmd and Tableau server backup activity.
• Experience with Dashboard & Scorecard Reports for Corporate Financial Forecasting as per user requirements using XSL, HTML, and DHTML
• Improved Reports performance in tableau using extracts and context filters
• Expertise in the concepts of Data Warehousing, Data Marts, ER Modeling, Dimensional Modeling, Fact and Dimensional Tables 
• Bachelor of Computer Science

TECHNICAL SKILLS:

BI Tools: Tableau Desktop 9.2/9.0/8.3/8.2/8.1/7 , Tableau Server 7,8.2, OBIEE 11g,SSRS,SSAS,

ETL Tools: Informatica 7.x/8.x (Power Center), SSIS

RDBMS: SAP Hana, Oracle 9i/10g/11g, MS SQL Server 2008,2012, Teradata,star schema

Languages: HTML, XML

Operating Systems: Windows 95/98/NT/2000/XP/7/8/10, unix

FTP Tools: WinSCP 5.X, Filezilla 3.5.x, Putty

PROFESSIONAL EXPERIENCE:

Confidential, Portland OR

SQL Server Developer

Responsibilities:

• Actively participated in gathering of User Requirement and System Specification.
• Created database logical and physical design to fit new business requirement and implemented new design into SQL Server 2005.
• Made changes to the existing data flows and redesigned the system.
• Part of Business Intelligence team responsible to build BI Reports using logi analytics . 
• Creating Database objects - tables, views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Created and scheduled jobs to run on a daily and weekly basis including the maintenance of the jobs.
• Involved in taking backups and restoring of crucial databases involved in the business.
• Writing queries which involve various joins in order to perform a thorough analysis on the missing sales on a daily and cumulative basis.
• Directly responsible for developing, testing and troubleshooting applications using LogiAnalytics
• Worked with SQL Server Analysis Services (SSAS).
• Multidimensional Expressions (MDX) is to make accessing data from multiple dimensions.
• Pulling data on a daily basis from OLTP database to OLAP or staging database using the SSIS packages.
• Used link servers in cases where data is to be pulled form a different database like oracle.
• Worked in OLAP environment where star schema is implemented, creating and identifying fact and dimension tables and establishing proper relations between them.
• Created special dimension tables like time dimensional tables.
• Created cubes and dimensions and measures and calculated measures according to the business requirements .
• Worked in creating hierarchies for dimensional tables like date dimensions and region dimension tables.
• Browsing the cube for analysis and validation of the data.
• Knowledge universe has an extensive background in mortgage banking and real estate industries. Plan and develops long time range mission-oriented programs and manage systems integration aspect into IT project plans identifies for change management and controls the change process by reviewing incident or configuration change requests.  Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Publishing scorecards which gets its data populated from the cubes, purpose being the verification of sales by the client business executives and also for further analysis.
• Fixing bugs in scorecards which pertain to the pivot tables and formulas.
• Used visual source safe to store all the versions of scorecards and design flows.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Created dashboards, scorecards, KPIs, Filters, PPS applications, chart reports and tablix reports
• Filtered bad data by using complex T-SQL statements, and implemented various constraint and triggers for data consistency.
• Used Report Generator (Report Writer) which is a program to extract information from one or more files and is presented in a specific format .
• Data generated through is presented in the form of pie charts, bar charts.
• Wrote stored procedures and functions to be called from front-end developers.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Created and managed users, roles and groups to handle database security.
• Tuned database by creating proper indexes.
• Created data dictionary for all columns and documented all the processes involved in maintaining the database for future reference.

Environment: SQL Server 2005 Management studio, LADBS,T-SQL, Excel, unix, Windows 2000/XP, SSIS, SSAS, star schema

Confidential, Atlanta,GA

SQL Server Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Manage LADBS System, I modified the existing POS to conform to customer specifications using Delphi 2010. Allowed the POS to communicate with bothSQL-Server 2008 R2 and Oracle d the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production back ups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Created dashboards by using Data connections for data source and designed KPIs, Filters, Reports, Indicators and Scorecards by using performance point,
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Management studio, T-SQL, Excel, LADBS,Windows 2000/XP, SSIS, SSAS,star schema

Confidential, Nashville TN

SQL Server Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Had a great hands in parallel data ware housing
• Worked with different methods of logging in SSIS.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Designed and developed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Experience in upgrading SQL Server software to new versions and applying service packs and hot fixes and unattended Installations.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation. Developed, monitored and deployed SSIS packages.
• Building UAT and Test environments using Production back ups.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Created dashboards by using Data connections for data source and designed KPIs, Filters, Reports, Indicators and Scorecards by using performance point,
• Wrote store procedures to generate account statements for different types of accounts
• Involved in migration of SSRS from SQL 2000 to SQL 2005
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.

Environment: SQL Server 2005 Enterprise Edition, SSAS, SSIS, T-SQL, SSRS, Windows Server 2003, Oracle 9i, Sybase, PDW

Confidential, Temple Terrace, FL

BI Consultant

Responsibilities:

• Experience in gathering and analyzing business requirements from various sources, ensuring the needs and delivery feasibility.
• Experience in Preparing Design Specification documents based on functional requirements and also involved in the preparation of Technical Design Documents.
• Used MUD environment during development of the project.
• Responsible for Creating the Physical Layer, Business Model and Mapping Layer and Presentation Layer in ANA Repository (.RPD) using Oracle BI Administration Tool.
• Created Dimensional Hierarchies for Drill Down, Level Based Measures and Time Series Functions like Ago(), To Date based on the Requirements.
• Created Attributes and Metrics in the BMM layer.
• Created Aggregated Tables to improve the Performance of the Reports.
• Created Logical Tables, Logical Columns with Measures Calculated as per the Business need.
• Implemented OBIEE Security (Object Level and Data Level Security in the OBIEE Repository and Answers) using Repository Variables, Session Variables and Initialization Blocks.
• Worked extensively on Oracle Answers, Delivers, and Intelligent Dashboards.
• Created Global Prompts, Narrative Views, Charts, Pivot Tables, Compound layouts to design the dashboards.
• Created Business Model to support Ad hoc Reports for User Access based on Requirements.
• Configured Presentation layer used by different User Groups and also established the various standard queries, in order to support the presentation layer.
• Security settings in Oracle Administration Tool to set up groups, access privileges and query privileges and also manages security for groups in BI Answers.
• Managed Security privileges for each subject area and dashboards according to user requirements.
• Worked on Installation and up gradation of OBIEE 10.1.3.4.1 to 11.1.1.6.0.
• Worked on Migration of OBIEE 10g to 11g and deployments of web app for customizations.
• Used the Catalog manager and maintained the web catalog to manage Dashboards and Answers.
• Test the reports and data in OBIEE against Micro strategy and validate them.
• Responsible for documenting the OBIEE framework and track the progress.

Environment: OBI 10/11g, Informatica Power center 7.1.2/8.1,Oracle 11g, Microsoft Windows Server 2003, MS VISIO.

Confidential

Tableau Consultant

Responsibilities:

• Develop various data connections from data source to Tableau Server for report and dashboard development
• Creation of metrics, attributes, filters, reports, and dashboards created advanced chart types, visualizations and complex calculations to manipulate the data.
• Combined visualizations into Interactive Dashboards and publish them to the web.
• Transformed Tableau into a managed service offering for consumption across Corporate Treasury and Corporate Investments.
• Act as a Point of Contact/Administrator in Data Interoperability, Analytics and Business Intelligence and Production Support issue resolution.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Designed, developed and supported BI solutions, Involved in Debugging and monitoring, and troubleshooting issues.
• Implemented advanced geographic mapping techniques and use custom images and geo coding to build spatial visualizations of non-geographic data.
• Work directly with management, vendors, and third parties to ensure that Web-site’s financial transactions and database management applications operate at peak efficiency.
• Ensured projects were completed on time and within budget.
• Setting up, and configuring a Tableau Server and MS-SQL 2008 R2 server for Data warehouse purpose.
• Utilize Tabadmin and Tabcmd commands to create backups and restore backups of Tableau repository.
• Utilized Tableau command line tools of Tableau Server for automation and maintenance.
• Good knowledge and experience on Tableau licensing: guest, interactor, viewer, editor.
• Tableau server maintenance, Tableau server backup activity.
• Consolidate multiple data silos that exist on campus to one location.
• Resolved end user reporting problems through collaboration with IT and Operations.
• Environment Support to User community, Service Request & Resolution.
• Expertise in failed over activities in production Environments.

Environment: Windows XP, Tableau 8.1/7.0, Tableau Server, SQL Developer, MS-SQL 2008 R2, MS-Access, MS Excel and JavaScript, OLAP, OLTP