SUMMARY:

• Geo is a Confidential certified Solution Expert Professional with 11 years of experience and 7+ years of MS SQL Server 2008R2/2012 Confidential Business Intelligence suit. As part of his assignments, have been involved in Requirement Analysis, Design and Development, Application Maintenance, Functional Studies and Quality Reviews of projects in the MSBI stack.
• 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 Multi - Dimensional Analysis Services (SSAS).
• Experience in Data modelling for the enterprise data warehouse.
• Experience in Developing SQL Server Integration services packages
• Experience in developing reports using SQL Server Reporting Services
• Have done some Proof of concept in PowerBI.
• Experience in design and developing SSAS Cubes/models (both Dimensional and Tabular model), defining Dimensions, Measures, Hierarchies, Attributes, KPI’s, Calculations, Actions, Perspectives and Roles.
• Having experience in SSRS report design and development
• Experience in Performance tuning in database level, ETL and analytical model by following approaches like Partitioning, indexing, etc.

TECHNICAL SKILLS:

Hardware / Platforms: Windows 2003 server/XP/7.

Technology: SQL Server Int gration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services(SSAS), Power BI, Crystal reports, Informatica.

Programming Languages: C#, VB, VB.NET

Databases: SQL SERVER. Oracle

Version Control Systems: MS Visual Source Safe (VSS), TFS.

PROFESSIONAL EXPERIENCE:

Confidential, New jersey

Technology Specialist

Environment: SSIS, SSRS, SSAS, SQL SERVER

Responsibilities:

• Requirement Analysis and Preparation of Specification document (HLD,DLD)for reports
• Managed requirements and design phase towards identifying mutually agreed solutions with technical and business partners.
• Analyze & understand the requirements.
• Direct client communication.
• Data modelling.
• Creation of Confidential SQL server SQL Procedures.
• Design and development of SSIS packages.
• Design and development of SSRS Reports.
• Design and development of SSAS cubes.
• Elicit the new/Changed Requirements by coordinating with the business.
• Identify the reusable components, Database Design.
• Prepare and Review the Design artifact.
• Database modeling and Design of the DB objects.
• Conduct code and functional reviews for the team.

Technology Specialist

Environment: SSIS, SSRS, SSAS, SQL SERVER

Responsibilities:

• Analyze & understand the requirements.
• Data modelling.
• Creation of Confidential SQL server SQL Procedures.
• Design and development of SSIS packages.
• Design and development of SSRS Reports.
• Design and development of SSAS cubes.

Confidential

Senior Technical Lead

Environment: SSIS, SSRS, SSAS, SQL SERVER

Responsibilities:

• Requirement Analysis and Preparation of Specification document for reports
• Analyze & understand the requirements.
• Datamodeling.
• Creation of Confidential SQL server SQL Procedures.
• Design and development of SSIS packages.
• Design and development of SSRS Reports.
• Design and development of SSAS cubes.

Technical Lead

Environment: SQL Server, SSIS, SSRS, SSAS, C#

Responsibilities:

• Analyze & understand the requirements.
• Direct client communication.
• Datamodelling.
• Creation of Confidential SQL server SQL Procedures.
• Design and development of SSIS packages.
• Design and development of SSRS Reports.
• Design and development of SSAS cubes.
• Elicit the new/Changed Requirements by coordinating with the business.
• Identify the reusable components, Database Design.
• Prepare and Review the Design artifact.
• Conduct Code & Functional reviews for the team.
• 24*7 Support activities.
• Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment
• For accessing and translating data into understandable and usable business information using SSAS.

Technical Lead

Environment: Oracle, Informix, Netezza, UNIX, SQL, SSIS

Responsibilities:

• Requirement Analysis and Preparation of Specification document for reports
• Managed requirements and design phase towards identifying mutually agreed solutions with technical and business partners.
• Design and Development of scripts in Netezza, Informix and Oracle.
• Development of scripts in UNIX.
• Database modeling and Design of the DB objects.
• Database Performance tuning.
• Conduct code and functional reviews for the team.

Confidential

Technical Lead

Environment: Informatica, Netezza, MS-SQL Server and UNIX, SSRS

Responsibilities:

• Responsible for Requirement gathering and Analysis datamodelling
• Preparation of HLSD,HLD and Detail Design document and ETL specification document
• Creation of Confidential SQL server, Netezza scripts.
• Unit testing and SIT
• Performance Tuning
• Conduct code and functional reviews for the team.
• Extracted data from SAP and staged into a single place (ODS layer) and applied business logic to load them in the central netezza database.
• Used Informatica PowerCenter 8.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources.
• Reporting on SSRS.

Module Lead

Environment: VB 6, SQL Server 2000/2005, SSIS, SSRS

Responsibilities:

• Coordinated with the Client and gathered the complex requirements
• Involved in Requirements, Design and other phases of Project
• Developing Packages using SSIS
• Developing User reports using SSRS
• Database Maintenance
• Took the responsibility in owning most of the modules and completely involved in all the stages of Software Development Life Cycle
• Project Implementation and Support
• Sustained Process Compliance throughout the Project
• Developed, deployed, and monitored SSIS Packages.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts.

Developer

Environment: SQL Server 2000/2005, SSRS, SSIS

Responsibilities:

• Developing User reports using Crystal reports
• Database Maintenance
• Developing complex stored procedures in SQL server.
• Migration of Sql server 2000 to 2005
• Management of the Project Management tool. All ahdoc requests from managers, performance tuning, automating load process has part of this activity.
• Played different roles like Knowledge Management Prime, Configuration audits (CA), Defect Prevention (DP) and MSBI COE.
• Has been a part of Internal Quality Audit Team in my Account where the responsibilities include conducting internal audits for the rest of the projects (in our account) and thereby ensure to maintain the quality.
• Been as SME of the application and efficient to address any clarifications sought.
• Adheres to Quality Process and ensure Quality Deliverables.