PROFESSIONAL SUMMARY:

• Enterprising MSc Professional offering a distinguished career of over 12 Years with insightful exposure across designing and implementing Business Intelligence, Architecture Designing, Data Warehouse and ERP solutions.
• Domain Knowledge of Telecom, Health Care, Billing and Retail.
• Proficient in Designing Business Intelligence Architecture using SQL Server 2008/2012, SSIS, SSRS, SSAS, Share Point Server 2010, Performance Point Services 2010 and Crystal Report. Good hands - on experience in SQL Server 2008 Business Intelligence.
• Expert level skills on Confidential -SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2008/2012.
• Good experience with SQL Server 2008/2012, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services).
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
• Delivered solution-oriented complex reports using Report Studio and development of ad-hoc reporting interfaces using Query Studio and analysis of reports from cube packages using Analysis Studio.
• Strong and In-depth knowledge on SQL Server 2008/2012 Database. Strong understanding about Database infrastructure. In-depth knowledge and hand-on experience on Database Objects like stored procedure, functions, Trigger, strong query design and optimization.
• Good technology exposure on Microsoft .Net technology with C# and VB.Net
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
• Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages.
• In-depth knowledge in Data warehousing, Business Intelligence and Master data management, Proficient in designing and implementing large scale of Data warehousing solution as well as Business Intelligence solution.
• Good understanding on Data warehouse Top-Down ( Corporate Information Factory" (CIF) and Bottom-Up (Ralph Kimball) approach.
• In-depth knowledge and practical experience in Information Systems Management, Database Administration coupled with technical expertise in implementation, operations and support of critical business solutions using IT as a tool.
• Expert in SQL Server 2008 & Business Intelligence and .NET 3.5
• Hands on experience (Expert) in Reporting Services and Analytical Services.
• Hands on experience (Intermediate) in SQL Server Integration services.
• Proficient is designing Business Intelligence Application/Portal using Microsoft Share Point Server 2010 With Performance Point Server, Microsoft Reporting Services and Microsoft Business Score Card Manager.
• In-depth knowledge of SharePoint 2010 with contains management, Shared services, Document management, Business Intelligence, Reporting services integration, Workflow and central administrator.
• Strong analytical, problem troubleshooting/solving skills, self-starter.
• Good understanding of Software Development Life Cycle (SDLC), Object Oriented Programming principles and experience on UML modeling tools.

TECHNICAL SKILLS:

BI Tools: SQL Server Analysis Services 2008/2012, Integration Services, Reporting Services, Crystal Report 10, Share point Server 2010, Informatica 8.0

Languages: C Sharp, VB.Net, VB6.0

Internet/ Distributed Technologies: ASP.Net, JavaScript, AJAX, Web Services, WCF, LINQ

Microsoft Technologies: Framework 1.1/3.0/3.5, Windows Service, SQL Server Reporting Services (SSRS), Integration Services (SSIS), SQL Server Analysis Services (SSAS)

Database: Oracle 8i, MS: Access 97, MS SQL Server 2008/2012, Teradata

Servers: IIS 5.1 and 6.0

Markup Languages: HTML, DHTML and XML

IDE: Microsoft Visual Studio 20

Tools: MS Visual Source Safe 6.0 and Team Foundation Server

Design Tools: UML, MS Visio

Operating Systems: Windows XP/Vista and Windows Server 2008

Methodology: Agile

Reporting Tools: SQL Reporting Services 2008/2012, SAP Business Objects

PROFESSIONAL EXPERIENCE:

Confidential, Tennessee

Solution Architect

Responsibilities:

• Gather requirements from the business users, and design a database with the compatible structure and data types of the vendor Facility.
• Design ETL architecture and create highly complex SQL Server Integration Services packages that load data from various sources into the production servers and to consequently create data extracts to be fed into the Hospital management systems.
• Creation of new procedures and UDFs to validate the business rules and deliver reports with a Key progress indicator for marketing department.
• Enhancement and troubleshooting of the developed code for performance and run times and also Audit trailing of the databases from the Source systems to the Data ware house.
• Conduct meetings with the SMEs Confidential Community Health Systems to assist them in the streamlining and data management processes and to roll out reports to validate the business logic.
• Create new complex stored procedures, queries, functions, triggers, Common table expressions to capture the production data accurately and assist the end users to recognize process bottle necks.
• Automate packages, Visual Basic scripts and stored procedures to run on a scheduled basis to keep track of the production numbers Confidential the end of the specified period.
• Perform rigorous tuning in SQL Server, and modify and create new indexes, database statistics and hints.
• Create highly critical data mapping, technical and process documentation of the data load process from various facilities into the Data ware house.
• Assist the team in Data recovery of the critical clinical data feeds when any of the SQL server processes fails, which directly affects the business.

Technologies:

• Server: SQL Server Integration Services 2012
• Operating System - Windows 7 Enterprise
• Languages - C#, VB.Net
• DBMS - Teradata, Existing Databases.

Confidential

Solution Architect

Responsibilities:

• Analyze, develop, manage and maintain financial reports that assist the business and the end users in their decision making process.
• Gather requirements from the business users, create technical and functional specification documents.
• Design and review the structure to improvise the maintenance of the data bases.
• Provide highly critical production support and perform unit testing and assist Quality assurance team in test cases.
• Develop queries, stored procedures in MS SQL Server to reduce crystal report processing time and enhance the efficiency of performance.
• Involved in the customization, alteration and development of existing tables, views, indexes, stored procedures (in MS SQL Server) to better suit the reporting requirements and needs.
• Create SSIS package to extract data from sources like Oracle, Xml, CSV and load into SQL data bases
• Manage all indexing, debugging, optimization and performance tuning.
• Create/modify SQL Joins and other Confidential -SQL code to implement business rules.
• Write complex Confidential -SQL code to enhance the performance of reports and the end user and business user experience.
• Monitor, automate and manage the month end processes that are highly critical for assessing the financial performance of the organization.

Technologies:

• Server: Reporting & Integration Services 2008
• Operating System - Windows 7 Enterprise
• Languages - C#, VB.Net
• DBMS - SQL Server 2008, Existing Data warehouse.

Confidential

Project Manager

Responsibilities:

• Design technical architecture based on detailed requirements.
• Design Dimensional Model and ETL process.
• Design ODS and Data Mart. Data Mart will be based on Client requirements.
• Work directly with business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Design, develop, debug and test data warehouse.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Define and deploy BI improvement opportunities and streamline the business intelligence processes.
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability.
• Creation of business reports, Dashboard reports, and also the maintenance of web reports.
• Designing the archicture for data warehousing solutions.
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.
• Conversant with the software processes and methodologies (ITIL)

Technologies:

• Server: SQL Server Reporting Services, Analysis Services
• Operating System - Windows Server 2008
• DBMS: Existing Data Warehouse, Flat Files, Excel.

Confidential, Atlanta

Tech Lead

Responsibilities:

• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Multidimensional cubes design, develop, debug and test.
• Writing SSIS package from transfer data from legacy system to data warehouse.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
• Define and deploy BI improvement opportunities and streamline the business intelligence processes.
• Creation of business reports, Dashboard reports, and also the maintenance of web reports using MS Reporting services 2008.
• Create detail design, work on development and perform code reviews.
• Analysis & implementation of better performance strategies.
• Conversant with the software processes and methodologies (Agile, scrum etc)
• Designed presentation layer in SharePoint 2010 using Performance Point Services.

Technologies:

• Server: IIS, Analysis Services, Reporting Services, Integration Services, SharePoint 2010 Programming - SQL, C#, VB.NET
• Operating System - Windows Server 2008
• DBMS: SQL Server, Oracle, MS Access, Excel.

Confidential

Business Intelligence - Tech Lead

Responsibilities:

• Develop technical architecture based on detailed requirements
• Validate the technical feasibility of business requirements.
• Infrastructure, architecture and environment evaluation.
• Multidimensional cubes design and develop using SSAS.
• Dimensional Modeling, ETL, OLAP, Reporting and Active Batch Monitoring/Scheduling.
• Interfaces with Business users and Technical SMEs to clarify requirements, review design, test case and UAT and deployment.
• Devising the Report delivery mechanisms
• Design fact and dimension tables.
• Creation DTS Packages and SSIS Packages using SQL Server.
• Ensures deliverables meet Quality standards
• Performed Functional testing, GUI testing, System testing and Database testing.
• Regression testing, Integration testing, Re-testing, Ad-hoc testing and Web services testing.

Technologies:

• Server: IIS, Analysis Services, Reporting Services, WSS3.0
• Programming - VB.NET
• Operating System - Windows Server 2003
• Configuration Management - MS Visual Source Safe
• DBMS: SQL Server, MS Access, Excel.

Confidential

Sr. Technical Associate - Report Developer

Responsibilities:

• Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
• Writing Lotus Notes agents, ActiveX script for pulling data from Lotus Notes db.
• Designing and Implementing the ETL processes.
• Creation of Canned reports, Cube-Based Reports, Report Models for Ad-Hoc.
• Using Reporting Services Capabilities and 3rd party tools accordingly to build Dashboards.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite folks and leading and mentoring the offshore team.
• Creation parameterize reports using filter and search conditions.
• Travel to various locations to train people in new project specific technologies.

Technologies:

• Server: IIS, Analysis Services, Reporting Services
• Programming - C#, ASP.NET
• Operating System - Windows Server 2003
• Configuration Management - IBM Visual Source Safe
• DBMS: SQL Server, MS Access, Excel, Lotus Notes Database

Confidential

Team Lead

Responsibilities:

• Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
• Writing scripts, Stored Procedure, Triggers to extracts the data from various data sources.
• Designing and Implementing the ETL processes using Informatica 7.1
• Provide support 24*7 for the application in the high pressure environment.
• Creation of reports, Cube-Based Reports, Report Models for Ad-Hoc
• Using Reporting Services Capabilities and 3rd party tools accordingly to build Dashboards.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite folks and leading and mentoring the offshore team.

Technologies:

Server: IIS, Analysis Services, Reporting Services

Operating System - Unix

ETL Tool - Informatica 7.1

Data Source - XML Files, Flat data files

DBMS - Oracle 10g