SUMMARY

• 9 + years experience in the IT industry as BI Architect, BI Lead & MS SQL Server 2012/2008/2005 Database Developer.
• Expertise in Data Analysis, Architecture and implementing Analytical Solutions
• Strong experience in MS SQL Server 2012/2008/2005 with Business Intelligence in SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS) and SQL Server Configuration Manager.
• 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 knowledge 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, C, C++, HTML and VB

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

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

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).

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, Houston, TX

BI Architect - Consultant

Responsibilities:

• Extensive use of SSIS/SSAS/SSRS/Vertica/Web reporting.
• 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)

Confidential, Eagan, MN

BI Architect - Consultant

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 knowledge, 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.

Confidential, Wilmington, DE

BI Architect - Consultant

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 knowledge of MDX and TFS.

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

Confidential

Business Analytics/OLAP/Reporting Lead - Consultant

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.