SUMMARY

• Total 11+ years IT experience and 10+ years of MS SQL Server 2005/2008/2012 experience in MSBI including Tableau, QlikView and Big Data with strong background in Databases and Data warehousing concepts.
• Microsoft certified technology specialist MCTS & MCITP for business intelligence in Sql server 2005/2008/2012.
• Equal competence Integration Services, Analysis and Reporting Services for Design, Development, Integration & Implementation of Information Management Solutions
• Extensively involved in data extraction and loading using .dtsx in MS SQL Server 2005 using SSIS in MS SQL Server 2005/2008/2012.
• Excellent hands on experience deploying SSAS Objects using deployment wizard or using Synchronize database wizard.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Strong experience in database Backup, Restore and Recovery procedures.
• Experience in Data Marts, Data warehousing, OLAP using the Dimensional Modeling techniques such as Star schema and Snow flake schema, FACT and Dimension Tables using MS Analysis Services (SSAS).
• Good experience in creating a Big Data framework and deploying tools to capture, transform, analyze and store terabytes of structured and unstructured data.
• Experience designing, reviewing, implementing and optimizing data transformation processes in the Hadoop, Hive and Talend ETL Tools. Able to consolidate, validate and cleanse data from a vast range of sources - from applications and databases to files and Web services.
• Installed and configured Apache Hadoop, Hive and Pig environment on the prototype server.
• Extensive Experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts.
• Administered user, user groups, and scheduled instances for reports in Tableau and documented upgrade plan from (Tableau7.0 to 8.1).
• 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.
• Excellent hand on experience in creating report model on SSAS cubes, as well as changing default configuration on existing cubes.
• Good experience in Designing Aggregations and pre-calculating in SSAS 2005 and 2008.
• Experience in writing MDX Scripting and MDX Queries. Experience in Building Cubes and Dimensions.
• Strong conceptual, analytical, and design skills and excellent communication skills with leadership qualities.
• Experience in Business Intelligence tools like Performance Point Server and Pro Clarity.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Functions, Performance Tuning and Query Optimization.
• Possesses very good communication and analytical skills as well as flexible to learn advancements in the IT industry.

TECHNICAL SKILLS

Technologies: Microsoft Business Intelligence Tools ( SSIS, SSAS, SSRS), Hadoop, Pig, Hive, HBase

Operating Systems: Windows 2003 / NT / XP

Languages: C, C++, JAVA, VB 6.0, T-SQL, Big Data

OLAP Tools: SQL Server 2012 Analysis Services, MDX, Proclarity, PPS

Databases: Oracle 9i, SQL Server 2005, SQL Server 2008 R2, SQL Server 2012

Packages: MS Office 2010, MS Visio, Visual studio, MOSS 2012

Reporting Tools: SQL Server 2012 Reporting Services, Business Objects, QlikView11, Tableau8.0, 8.1

PROFESSIONAL EXPERIENCE

Confidential, FL

BI Architect

Responsibilities:

• Providing the business intelligence (BI) solution using SSIS, SSRS, SSAS and SQL server tools and technologies.
• Developing technology specifications and ensuring that new technology solutions are designed for optimal access and usefulness, and leveraging existing technologies when possible
• Applying architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability
• Identifying the technologies to employ based on price, performance, service agreements and organization constraints
• Designs, implements and supports data warehousing and also building Data marts for each department.
• Pull the Data through ETL process from multiple systems like Oracle ERP, PeopleSoft, Work Brain and Footprints into Data ware house.
• Dimensional Data Modelling using Star and Snow Flake Schemas.
• Developed complex store procedures for business requirements.
• Developed SSAS cubes for each department like Finance, accounts, HR, PeopleSoft and Service desk.
• Designed very complicated Security setup using MDX So that when users login they will see only their divisions data.
• Developing multiple SSRS reports like parameterized, sub report, cascading and dynamic.
• End to End testing on all development activities to retain data accuracy and performance related issues.
• Creating multiple Tableau dash boards for couple of business areas to improve Masco business.
• Involved in building financial reports in Tableau so as to have nice look and feel.
• Worked both on Tableau Desktop and Tableau Server.
• As BI Architect, Taking care of all project management activities and helping out my employer to full fill other client’s technical issues.
• Managing Off shore team of 10 resources and providing production support to developed marts.

Environment: SQL Server 2012, SSIS 2012, SSAS 2012, SSRS 2012 and Tableau 8.x SQL Server 2008 R2, SSIS 2008 R2, SSAS 2008 R2 and SSRS 2008 R2.

Confidential

BI Architect

Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design.
• Responsible for data warehouse modeling, ETL design and development, and performance tuning.
• Designed and implemented the ETL architecture for the whole project using SSIS.
• Good Experience in publishing reports and dashboards to Tableau server.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Effectively solved ongoing issues in the Test, QA Environment.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on T-SQL / ETL.

Environment: SQL Server 2008 R2, SSIS, SSRS, Tableau 7.x and MOSS.

Confidential, Abbott

BI Onsite Architect

Responsibilities:

• Designed and implemented the ETL architecture for the whole project using SSIS.
• Designed and developed multi dimensional Cube databases using SSAS.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Performing Health checks for Sql Servers and performing Warehouse keeping activities.
• Responsible to monitor all support activities, tickets tracking, providing necessary support to associates Etc.
• Effectively solved ongoing issues in the production Environment.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on Reports and ETL.

Environment: SQL Server 2008, SSIS, SSAS and SSRS.

Confidential

BI Onsite Project Lead

Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design.
• Responsible for data warehouse modeling, ETL design and development, and performance tuning.
• Designed and implemented the ETL architecture for the whole project using SSIS.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on Reports and ETL.
• Ensure smooth deployment on all development and testing environments.
• Co - ordinate with production team for issue analysis and resolution.

Environment: Oracle, Netezza, SSIS, SSRS,UNIX.

Confidential, Atlanta

BI Onsite Support Lead

Responsibilities:

• Built new Business Intelligence systems and re-designed existing ones.
• Responsible for data warehouse modeling, ETL design and development, and performance tuning.
• Designed and implemented the ETL architecture for the whole project using SSIS.
• Designed and developed multi dimensional Cube databases using SSAS.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005 Analysis Services.
• Implemented Performance improvements in T-sql scripts and handled data efficiently.
• Performing Health checks for Sql Servers and performing Warehouse keeping activities.
• Responsible to monitor all support activities, tickets tracking, providing necessary support to associates Etc.
• Effectively solved ongoing issues in the production Environment.
• Extensive experience in report generation using SQL Server Reporting Services (SSRS) from both relational databases and OLAP cubes.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.

Environment: MS SQL Server 2005/2008, T-SQL, SSIS, SSRS, SSAS, Visual Studio, MOSS.

Confidential

BI Architect

Responsibilities:

• Plan development schedules and ensure adherence to the same.
• Support to development teams.
• Design overall ETL solution and templates and guide team for development.
• Review the specs, preparing technical specification documents, analyzing the tasks and providing the feedback to the business.
• Implement performance tuning on Reports and ETL.
• Ensure smooth deployment on all development and testing environments.
• Support client and CG-US team for UAT deployment and issues.
• Maintain effective defect resolution plan and ensure minimum defects in the solution.
• Actively participated in SSAS cube deployment and prepared XMLA scripts for dynamic cube processing and Backup/Restore.
• Support and guide team to overcome challenges due to relatively new technology.
• Co - ordinate with production team for issue analysis and resolution.

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, SSAS, PPS, Visual Studio, MOSS.

Confidential

BI Designer/Developer

Responsibilities:

• Developed specification documents, guidelines and standards at various places in the project.
• Provided excellent solutions for SCD's, Maintenance and process for warehouse and OLAP databases.
• Designed and developed OLAP databases, automated ETL solutions
• Designed and developed financial reports using MS reporting services.
• Implemented Package Configuration, Message Logging, Auditing and event handlers.
• Hand-coded OLAP Process using XML/XMLA scripts for Warehouse &OLAP Process, Backup, Restore dynamically.
• Scheduled the ETL Package by creating jobs Using SQL Server 2005 Management Studio.
• Co - ordinate with production team for issue analysis and resolution.

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS, SSAS.

Confidential

BI Developer

Responsibilities:

• Gathered the requirements from the client and translated the business design into Technical Design.
• Development of mappings according to the ETL specifications for the staging area data load & warehouse data load using Integration Services & SQL Server 2005.
• Created transformations and mappings using data flow tasks.
• Created event handlers per the package using event handler tab.
• Implemented Package Configuration, Message Logging and Auditing.
• Coded stored procedures, Functions, Triggers and SQL scripts at high level
• Actively participated in designing, coding & testing.

Environment: MS SQL Server 2005, T-SQL, SSIS, SSRS.

Confidential

BI Developer

Responsibilities:

• ETL Development using SSIS.
• Created OLAP Cubes using SSAS.
• Design the report requirement and created reports using SSRS.
• Scheduled the ETL Job Using SQL Server 2005 Management Studio.
• Created document for the project.
• Performed unit cases.
• Co - ordinate with production team for issue analysis and resolution.

Environment: MS SQL Server 2005, T-SQL, SQL Server 2005 Integration services.