SUMMARY:

• Twelve plus (12+) years of experience in Software Development and Database Management systems 7+years of experience in Design, Development and Support of MS SQL Server for both OLTP and OLAP Systems with .Net framework/Share Point Applications
• 5+ Years of experience in Developing and Implementing MS SQL Server Analysis Services 2012/2008 R2 (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS.
• Expert in ETL Development, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
• Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin.
• Experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
• Experience in Developing SSIS Packages to retrieve data from Oracle, SQL Server, MS-Excel and Text and migrate data to various servers
• Experience utilizing SQL, Oracle PL/SQL and SQL Loader, Microsoft DTS and T-SQL, VBScript, and Perl, DOS or
• UNIX shell scripting for manipulating large volumes of data to and from enterprise systems, as well as experience manipulating flat-files, EBCDIC to ASCII conversion, and non-relational data
• Expertise in SQL Server reporting services (SSRS) in generating complex reports: Tabular, Matrix, Cascaded, TOPN, Parameterized, Chart, Sub-reports, Drill-down, Ad hoc reports and Ad-hoc Report Models
• Expertise in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using SSRS Report Manager.
• Expert at creating High level dashboard using SSRS 2012/SSRS 2008 R2.
• Expert in creating Power Pivot Dashboard Charts and reports using Complex queries.
• Extensive experience delivering OLAP solutions by developing Dashboard Reports using SQL Server Reporting Services (SSRS).
• Participated in all phases of Software development life cycle (SDLC) with Development, Staging, Testing and Production Server in Offshore/Onsite Environments

TECHNICAL SKILLS:

Databases: MS-SQL Server 2016/2014/2012 / 2008 R2 Oracle 9i/10g, MS-Access

ETL Tools: SSAS 2016/2014/2012, SSRS 2016/2014/2012, SSIS 2016/2014/ 2012/2008, MS BI Development Studio, Toad, IBM Cognos 10, BO-Crystal reports, MS-Excel Power Pivot, WebFocus V7, BI Power View

Web Development & Scripting Languages: JavaScript, VBScript, HTML, XML, XSL, Visual Studio.NET, MS-SharePoint Portal Server / 360, MS-Share Point 2013, MS-Excel 2013/ 2010

Software Languages: .NET Framework 4.5 (ASP.NET, VB.NET, C#, ADO.NET and WEB SERVICES), ASP, Visual Basic 6.0

Methodologies & Tools: OOAD, Agile, Visual Source Safe (VSS), Team Foundation Server (TFS), TOAD

Operating Systems: Windows 8, Windows 7, Windows XP, Unix/Linux

Design Tools: MS - Visio, Erwin

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Collaborate and build effective working relationships with colleagues across technology and the business to achieve business and IT objective
• Developed and Implemented EBCDIC format files to ASCII and using XML reference from COBOL data structures
• Developed SSIS data flow task to input data from EBCDIC data files,convert and proceed with Stage and prod. data in SQL Server
• Configure SSRS Report Manager and provide authentication & authorization to various users using SSRS Report Manager
• Converted excel & access reports into SSRS 2012 Reports and Deployed in Share Point Portal Server

Confidential

BI Developer

• Creating and maintaining Facts, dimensions and provide reports to the end users through Tableau, .Net application and SSRS Report Manager.
• Designed and developed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad - hoc analytic research and automated reporting.
• Extensive Knowledge in SSAS storage and partitions Aggregations, calculation of queries with MDX, Data Mining Models, developing reports based on clients, regions and foreclosure types using MDX and SQL
• Designed and implemented Data Integration and ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Designed, Developed various client based Reports for various mortgage types in Tableau
• Designed cubes in SSAS environment using Snowflake and Star Schemas. Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts

Confidential, NYC

BI Developer

• Load data from various sources like OLEDB, flat files to SQL Server database Using ETL SSIS 2012 Packages and created data mappings to load the data from source to destination.
• Created the automated processes for the activities such as database backup processes and SSIS 2012/2008Packages run sequentially using SQL Server job process.
• Deployed ETL - SSIS 2012 Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed Complex T-SQL Queries, Views Triggers and Indexes in SQL Server 2012
• Designed and Implemented Tabular Model for Large Data Model using SSAS 2012 in SQL Server 2012
• Designed and Implemented DMX queries Larger Datasets
• Designed Complex T-SQl Queries, DMX functions, Dynamic MDX queries Designed and Implemented in SSRS 2012 and Deployed in Share point 2013
• Configure SSRS Report Manager and provide authentication & authorization to various users using SSRS Report Manager
• Converted Dynmics CRM Reports into SSRS 2012 Reports and Deployed in Share Point Portal Server
• Implemented Power View and Power Pivot in SharePoint

Environment: Microsoft SQL Server 2012/2014, SQL Server Analysis Services 2012/2014,Reporting Services 2012/2014, SQL Server Integration Services2012/2014,Oracle 11i, TOAD, Team Foundation Server, Visual Studio .NET 2012,.Net Framework 3.5/4.5,ASP.Net,C#,MS-Office 2010,MS Visio -2012,IBM Cognos 10.2,Sharepoint 2013,WebFocus V7,Power pivot, BI Power View

Confidential

BI Architect/ Solution provider

• OLAP Multidimensional Cube created using SSAS 2008 for Analyzing effecting number of Installations performed Month over Month and Reports created using SSRS 2012
• Using Cube model Analysis created and Implemented for finding the shortest and effective travel to reduce running cost and Capitalized Labor Cost Calculated using Linear Algorithm
• Complex MDX functions, Dynamic MDX queries created and Implemented along with MS - Excel Macros
• Converted Cognos8 Reports into SSRS 2008 Reports and Deployed in Share Point Portal Server
• SSRS various Reports are Developed and Deployed using SSRS 2012
• Created Complex ETL Packages & Dimensional Models using Agile Methodology

Environment: Microsoft SQL Server 2012, SQL Server Analysis Services 2012,Reporting Services 2012, SQL Server Integration Services2012,Oracle 11i, TOAD, Team Foundation Server, Visual Studio .NET 2010,.Net Framework 3.5/4.0,ASP.Net,C#,MS-Office 2010,MS Visio -2010

Confidential, NYC

Senior BI Lead Developer

• Accessed OLAP Cube Designed in SSAS 2012 for monitoring Vaccinations in various Regions around the Globe using Star Schema in Kimball Methodology using MS - Excel 2010 for Data Quality /Validation.
• Using Time Dimension, Allocation of Funds, Allotment of Funds and Expenditure is calculated in Monthly basis on Every Year
• Data Analysis and Data Quality Implemented and Recorded in Test Server and verified in Production for each dimension against measures
• Designed and Developed SSAS 2012 Cubes and building attribute relationships for the performance of Hierarchies Facts and Dimensions
• MDX Queries created for Testing to identify data for SSRS2012 Reports to Analyze Warehouse stocks/usage
• Designed Data & its Type in KPI, Aggregations & Calculated measures in SSAS 2012 Implemented MS-Excel 2010
• Using XML Task convert XML and Insert into Fact and Dimensions
• Design and deploy the SSRS 2012 Reports in Share point 2010
• Deploy SSRS 2012 Reports in MS Share Point Integrated Mode
• MDX Queries created for SSRS2012 Reports to Analyze Warehouse stocks/usage
• Involved in the assessment of customer requirements, technical feasibility documentation
• Drafted technical feasibility based on functional requirements

Environment: Microsoft SQL Server 2012/2008 R2, SQL Server Analysis Services 2012/2008,Reporting Services 2012/2008 R2, SQL Server Integration Services 2008,Oracle 10i, TOAD, Team Foundation Server, Visual Studio .NET 2008/2010,.Net Framework 3.5/4.0,ASP.Net,C#,MS-Excel 2010,MS Share Point 2010,MS PowePivot, MS-Powerview

Confidential, NYC

Senior BI Lead Developer

• Data Migration created using ETL SSIS 2008 packages
• OLAP Cube Processed using SSIS 2008 Package on a daily basis using Job scheduler
• Analyze and Implement Data Quality over Master Data and Check the Quality Data over Ralph Kimball Methodology
• Using XML Task convert XML and Insert data into SQL Server
• Reports Designed, Developed and Deployed using SSRS 2008.
• Designed Test cases for each measures against Fact and Dimensions in Star Schema - Kimball Methodology
• Using SSAS and MDX queries the Performance Based characteristics for retail shares report is generated in SSRS 2008for the past 5 years and compared with Baron and Russell Mid Cap Growth.
• Portfolio Facts and Characteristics Report is created in SSRS 2008
• Reports Data Quality Analyzed for Top ten Holdings, Performance for the Quarter (includes Total Returns, Annualized Returns, Cumulative Returns) in SSRS 2008
• Reports for TOP Contributors/Detractors for the Quarter by SUB-Industry and By Holding are generated using SSAS in SSRS 2008.
• Created and scheduled SSIS Package for Processing SSAS OLAP Cube Fact and Dimensions and Monitor Data Flow Task
• Pie Chart created for GICS Sector Breakdown in SSRS 2008 and Nevron charting
• Data Validation done in MS-Excel 2007 for Bar Chart for various Funds for Sub-Industry breakdowns, Performance for the Qtr. - Since Inception, Historical Performance Baron Versus Russell Versus S&P, Contribution% by the Each Sub-Industry created in SSRS 2008
• Comparison Value of 10K chart created in XY Scatter Area Chart and Risk Return Comparison chart is created in XY Scatter Point Chart using SSRS 2008
• Developed complex Queries and Stored procedures in T-SQL using SQL Server 2008

Environment: Visual Studio .NET 2008/2010,.Net Framework 3.5/4.0,ASP.Net,C#,MS-Excel 2007, Microsoft SQL Server 2008, SQL Server Analysis Services 2008,Reporting Services 2008,SQL Server Integration Services2008.Nevron Charting, MS Share Point 2010

Confidential, Atlanta, GA

SENIOR DEVELOPER

• Created Data Transformation tasks for SSIS in SQL Server 2005
• Designed and developed SSIS Packages to extract data from various data sources such as Access, Excel and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all
• Created Cubes and MDX queries using SSAS update/refresh cubes in regular intervals
• Using Cubes and MDX queries and for generating Monthly and Weekly Reports for Single and Multi - car Insurance and Home Insurance Business across states and agents
• Developed complex reports using SQL Server 2005 in SQL Server reporting Services 2005
• Reports created in YTD and MTD, Monthly and Weekly for Agents around US in SQL Server 2005 and SQL Server Reporting Services 2005
• Reports created for various audit and Candid Audit information revealed
• Reports Created and Data source created from MDX, OLAP and Cubes using SQL Server Analysis Services 2005
• Cubes and MDX queries created using SSAS and Reports are generated in SSRS using MDX queries
• Report Models and Ad-hoc reports are created for Candid Audit
• Design the Database Models, entities and relationships using Erwin and documented using MS-Visio

Environment: Visual Studio .NET 2005,.Net Framework 3.0/3.5,ASP.Net,C#,MS-Excel 2003, Microsoft SQL Server 2005, SQL Server Analysis Services 2005,Reporting Services 2005,SQL Server Integration Services2005,OLAP,OLTP

Confidential, Wall Street, NY

SENIOR DEVELOPER

• Created Complex queries, stored proc, views and functions in SQL Server 2005
• Developed complex reports using SQL Server 2005 in SQL Server reporting Services 2005
• Create connected web parts in Share point Portal Server 2007 collection for displaying SQL Server reporting Services 2005 Reports
• Create Global Audit Reports from MS - Excel, Asp & HTML page Reports to SQL Server 2005 and SQL Server Reporting Services 2005
• Reports created for various audit and Candid Audit information revealed
• Reports Created and Data source created from MDX, OLAP and Cubes using SQL Server Analysis Services 2005
• Cubes and MDX queries created using SSAS and Reports are generated in SSRS using MDX queries
• Report Models and Ad-hoc reports are created for Candid Audit
• Extract Data from MS-Excel, MS-Access and Text File and Load into the SQL Server 2005 using SSIS 2005
• Involved in Creating Migration of DTS Package to SSIS 2005 Package

Environment: Visual Studio .NET 2005,.Net Framework 2.0,MS-Excel 2003, Microsoft SQL Server 2005, SQL Server Analysis Services 2005,Reporting Services 2005,SQL Server Integration Services2005,Sybase,OLAP, OLTP

Confidential, NY

SENIOR DEVELOPER

• Created Complex queries, stored proc, views and functions for SQL Server 2005 for Reports
• Developed complex reports using SQL Server 2005 and SQL Server reporting Services 2005
• Convert Global Private Client Reports from MS - Excel to SQL Server 2005 and SSRS
• Reports created for Portfolio management and Portfolio products
• Data Loaded from MS-Excel and Text files to SQL Server 2005 using SQL Server Integration Services (SSIS)
• Reports created for Hedges, Derivatives and Various Sub Books and Curves
• Reports created for Various US $, Yen, Euro and Other Currencies
• Data is uploaded in Development server using SQL Server Information Services (SSIS)
• Create Cubes, MDX queries using SQL Server Analysis Services 2005
• Create packages and Data transformation scripts in SSIS
• UI Created for testing Team to test the Report created in SQL Server Reporting Services (SSRS)

Environment: Visual Studio .NET 2005,.Net Framework 2.0,MS-Excel 2003, Microsoft SQL Server 2005, SQL Analysis Services 2005,Reporting Services 2005,SQL Server Integration Services 2005

Confidential, Hopewell/Plainsboro, NJ

SENIOR DEVELOPER

• Responsible for Design and Development of web forms in ASP.Net using VB.Net in .Net Framework 2.0
• Responsible for writing stored procedures in TSQL, used Complex queries, joins and while coding the stored procedures
• Created various Ad - hoc Reports using Reporting services 2005, as part of this used complex formulas, sub reports and drill downs using Reporting services
• Developed views and stored procedures using T-Sql to create Reports in Reporting Services 2005 for:

Environment: Visual Studio .NET 2005,.Net Framework 2.0,MIIS 2003,MS-Excel 2003,Microsoft SQL Server 2005, SQL Server Analysis Services 2000,Reporting Services 2005