SUMMARY:

• 11+years of experience in the IT industry as BI Architect, BI Lead & MS SQL Server 2014/2012/2008/2005 Database.
• Strong Expertize in handling DWH to support company Day - to-Day Operations (from Lead Generation to Partner/Employee Payments)
• Strong Understanding of advanced Data sources like Azure, Eloqua, SiteCore, Dialer (Genesys) & PPC (Google Analytics).
• Strong Understanding of Customer Relation Management (Salesforce.com and Microsoft Dynamics CRM).
• Strong experience with Microsoft AZURE 2012/2014, Microsoft Power BI.
• Strong Understanding of ColumnStore Indexing and OLTP In-Memory 2014/2106.
• Strong Understating of Master Data Management.
• Strong experience with RDBMS, Tabular Databases and NoSQL Databases (Document db).
• Expertise in Data Analysis, Architecture and implementing Analytical Solutions
• Strong experience in MS SQL Server 2104/2012/2008/2005 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Tabular Model, SQL Server Integration Services (SSIS) and SQL Server Configuration Manager.
• Strong experience with 2014 BI Catalogs.
• Good Understanding of Software Development life cycle (SDLC - Waterfall, RUP and Agile methodologies) and Capability Maturity Model (CMM).
• Expertise in OLTP/OLAP system study, developing Database schema like Star Schema and Snowflake Schema used in multidimensional modeling.
• Strong Understating of Installing servers - SQL-db, SSRS, SSAS, Web, SSIS (batch) and implementing security.
• Expertise in writing T-SQL statements, Stored Procedures, User defined functions and Views providing efficient data retrieval and manipulation and ensuring data consistency.
• Excellent communication skills and is able to work individually and as Team Leader.
• Academically gained noledge on Portfolio and Risk Management, Option Pricing, Financial Statistics, Fund Management, Statistics, Regression, Financial Data Analysis
• Expertise on SAS, MATLAB, Mathematica and R for Data Analysis, Simulations, Bootstrapping, Portfolio/ Risk Analysis/Optimization, Time Series, and forecast volatilities, PCA

TECHNICAL SKILLS:

Programming Languages: T-SQL, SQL, MDX, DAX C, C++, HTML and VB

RDBMS: MS SQL Server 2005/2008/2012/2014, Oracle 8i/9i/10/11g.

Reporting Tools: SQL Server Reporting Services (SSRS), qlikview, Tableau

Database/ETL Tools: Vertica, SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server Business Intelligence Development Studio (BID/SSIS), SQL Server Analysis Services (SSAS), Informatica, Oracle, Sybase.

Database ModelERwin, Microsoft db project2014:

Operating Systems: Windows 95 / 98, ME, Windows NT /2k / XP/ Vista, Mac-OS.

Application Packages: MS Office (Word, Excel, Access, Power Point, Visio), DB2.

Mathematical Languages: MATLAB, R, Mathematica, SAS

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence /Data Strategy Architect

Responsibilities:

• Expertize in handling the Operational DWH that manages whole operation of company.
• Responsible to generate all the relevant data from Customer Billing to Partners & Employees compensation.
• Extensive use of SQL/SSIS/SSAS/SSRS.
• Extensive use of SSRS, DOMO and QlikView for Analytics.
• Expertize in understanding Business Model of Call Center, Lead Generation & Partner Management.
• Expertize in sourcing Data from Azure, Eloqua, SiteCore, Dialer (Genesys) & PPC (Google Analytics).
• Expertize in understanding Call Center Data (Including Agent Activity logs, Call Data etc.)
• Expertize in working Agile methodology.
• Strong understanding of DWH concepts, MSBI tools, Data Analysis, Predictions Models.
• Laureate International Universities Oct’16 - Jan’17
• Extensive use of SSIS/Tableau.
• Expertize in writing SOW’s, providing estimates, understanding requirements and project planning.
• Expertise in Analysis and POC of Salesforce.com
• Responsible for Asset migration (ETL, Cubes, Reports) to Salesforce.
• Responsible for Designing Data Model to support Reporting for CRM data.
• Responsible for Designing ETL solutions to Extract and push data from Salesforce.
• Responsible to Designing solution for Tableau.
• Expertize in Data Analysis and predictions.
• NRUCFC Mar’16 - Oct’16

BI Architect - Consultant

Confidential

Responsibilities:

• Extensive use of SSIS/SSAS/SSRS.
• Expertize in writing SOW’s, providing estimates, understanding requirements and project planning.
• Expertise in Analysis and POC of Salesforce.com and Microsoft Dynamics CRM
• Responsible for Asset migration (ETL, Cubes, Reports) to Salesforce.
• Responsible for Designing Data Model to support Reporting for CRM data.
• Responsible for Designing ETL solutions to Extract and push data from/to Salesforce.
• Responsible to Designing solution for migrating current CRM DataMart to Salesforce.
• Expertise in using SSIS catalogs for SSIS packages.
• Expertise in using Tabular Model using SSAS.
• Strong understating of Microsoft Release Management using dacpac, SSIS catalogs for deployment.
• Design solution to provide data (/reports) using various ETL(SSIS) and reporting tools (Cubes, SSRS, Tableau)
• Migrate applications to latest technologies (from 2005/2008 -> 2014)
• Installing servers from scratch - SQL, SSIS, SSRS, SSAS.
• Data Migration using optimized techniques.
• Reverse Engineer applications to provide optimized solutions.
• End to End responsible for delivering and supporting the projects.
• To lead and provide solutions to different applications Development teams.
• To provide all/any MS-BI solution across organization.
• Hewlett Packard Mar’13 - Mar’16

BI Architect - Consultant

Confidential Houston, TX.

Responsibilities:

• Extensive use of SSIS/SSAS/SSRS/Vertica/Web reporting.
• Expertise in using Tabular Model using SSAS.
• Expertise in Analysis and POC of Salesforce.com and Microsoft Dynamics CRM
• Responsible for Asset migration (ETL, Cubes, Reports) to Salesforce.com.
• End to End responsible for delivering and supporting the projects.
• Design solution to provide data (/reports) using various ETL(SSIS, Map-reduce) and reporting tools (Cubes, SSRS, Tableau, Qlikview)
• Migrate applications to latest technologies (from 2005/2008 -> 2012)
• Installing servers from scratch - SQL, SSIS, SSRS, SSAS.
• Data Migration using optimized techniques
• User Migration using correct AD/ED group and user profiles.
• Reverse Engineer applications to provide optimized solutions
• To lead and provide solutions to different applications Development teams (strength > 15)
• To provide all/any MS-BI issues across the organization (strength > 100)
• Thomson Reuters Mar’12 - Mar’13

BI Architect - Consultant

Confidential, MN.

Responsibilities:

• Extensive use of SSIS for Extracting Data from different feeds.
• Massaging the data according the Data base and Cube structure.
• Designing OLAP cubes SQL server 2008 R2 using SSAS for all departments within the company: HR, Finance, and Legal etc.
• Strong SSAS noledge, which includes: Optimization, Dimension Usage, Calculations, KPI’s, Actions, Processing Options, Storage Modes, Roles etc.
• Optimizing cubes using partitioning, aggregations and perspectives.
• Designing SSRS reports on cube (using MDX) or Data ware houses.
• Designing Dashboards on SharePoint sites using MDX.
• Extensively used SQL and MDX queries for Excel Reporting.
• Designed Report Models based on Business Requirements to support Business Analysis.
• Responsible for TFS reporting (Bug Reporting, Burn-up Reports, Deploy Reports etc.)
• Responsible for tuning/Optimizing SSRS reports and stored procedures/SQL queries.
• Invista Mar 11 - Mar’12

BI Architect - Consultant

Confidential, DE

Responsibilities:

• Designing OLAP cubes SQL server 2008 using SSAS.
• Designing OLAP Cubes for HR to optimize return on investment (ROI) on its human capital, Analyze performance within the company.
• Designing SSIS packages to pull the relevant data into Data warehouse.
• Automating the SSIS packages to downstream data from various Rapid-marts.
• Using Looping structures in SSIS to populate the referential data and Fact Data for Cubes.
• Implementing Extensive Tracking of SSIS jobs to Track errors/success.
• Designing SSRS and Excel reports using stored procedures and cubes.
• Handling multiple parameters of different types in SSRS reports.
• Implementing calculated measures and KPI’s in SSAS cubes.
• Responsible for discussing Business requirements with End users and Business groups.
• Good noledge of MDX and TFS.

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

Business Analytics/OLAP/Reporting Lead - Consultant

Confidential, VA.

Responsibilities:

• Designing OLAP cubes SQL server 2008 using SSAS.
• Applying analytics to the data warehouse to introduce new dimensions and measures for generating reports.
• Defining Business rules for categorizing the data to defining various dimensions.
• Designing drill down and dynamic SSRS reports according to Business requirements.
• Extensive use of SSIS to transfer data between various databases.

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

Confidential, VA

BI Lead- Consultant

Responsibilities:

• Organize meeting to estimate project cost, discuss requirements and present analytical reports.
• Responsible for all ETL operations within the Engineering group including client feeds, warehouse loads, and data extraction.
• Design MOLAP/ROLAP cubes on Teradata Database using SSAS.
• Responsible for developing physical and logical design of database, incorporating new business requirements, and implemented the new design into SQL Server.
• Validate the facts and dimension data using Excel before processing the Cubes.
• Apply analytics to the data warehouse to introduce new dimensions and measures.
• Define Business rules for categorizing the data to defining various dimensions.
• Optimize cubes and Tables using partitioning to shorten processing time and improve Drill through detail query performance.
• Design OLAP/Ad-hoc reports for business users using SSRS.
• Create multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts.
• Develop and deliver dynamic reporting solutions using SQL Reporting Services (SSRS)
• Design, deploy and maintain various SSRS Reports in SQL Server 2005.
• Design complex and Efficient ETL process to load data from different sources like text file, excel or various database.

Environment: SQL Server 2005/08, SSAS, SSIS, SSRS, Teradata, MS Access, XP.

Confidential, VA

BI Developer - Consultant

Responsibilities:

• Designed ETL packages to load data from different data ware houses and migrated it to text files.
• Used various data flow and control flow items for the ETL.
• Wrote highly complicated and optimized stored procedures which were used for main extraction.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Analyzed the Extracted data is according to the requirement.
• Wrote and discussed Analysis reports with Clients.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Responsible for Configuring, tuning, and optimizing SQL Server 2008.

Environment: SQL Server 2005, Query Analyzer, SSIS, Flat files and XP.

Confidential

SQL Developer

Responsibilities:

• UpgradedSQL Server 7.0to SQL Server 2000 and migrated data from old systems to new systems.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Actively involved in Normalization & De-normalization of database.
• Designed DDL and DML for MS SQL Server 2000.
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed the database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.
• Create joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.
• Configuring, tuning, and optimizing SQL Server 2000.

Environment: SQL Server 2000, SQL Server 7.0, Windows XP.