PROFESSIONAL SUMMARY:

• About 11 + Years of IT experience, currently working as Senior Developer in Business Intelligence domain. I am adept at MSBI, SQL Server and have experience in doing Database and Data warehouse Development using the tools like SQL Server 2005/ 2008/2012/2014 and SSAS, SSRS and SSIS.
• Good in Dimensional Modeling, Database and data warehouse designing skills using the technologies like SSIS and SSAS
• Good in defining ETL process and designing packages using SSIS.
• Good at Creating the SSIS packages to load data from multiple sources into relational databases
• Good at the using various SSIS components or tasks to create a package to handle data flow.
• Good at custom scripting the SSIS using C# scripting
• Good in writing Complex T - SQL or Transact SQL Queries like views, Procedures, Functions Using SQL Server 2005/2008/2012.
• Good Knowledge in Data Cleansing with unknown facts or unknown dimension members using SQL Server Views/Procedures and some look up methods in ETL process.
• Good in Designing the SSAS cubes using star schema and snowflake schema, Dimension modeling, attribute relationships and create calculations using MDX
• Good at automating the OLAP process using SSIS packages with XMLA scripts
• Experience in preparing technical documents like design and SOP/MOP documents.
• Good Knowledge in writing/Designing the Excel Macros to for data retrieval from SQL/SSAS sources using VBA
• Good interactive skills with the client during con calls and to submit the current project state and asking relevant questions to capture the functionality required and clarify the issues those team has.
• Having good Knowledge in understanding the client requirements and preparing the proposals/solutions to the new enhancements.
• Unit testing to compare results between source and destination and documenting the unit test results.
• Experience in production support roles like debugging/issue fixing and data analysis.
• Sincere, enthusiastic, hardworking with excellent communication and interpersonal skills and appetite to learn new skills
• Knowledge about DBA activities like backing up and restoring the databases and job scheduling
• Good in Design and Development of reports using SSRS and Power BI
• Knowledge in Panorama/Nova view Reporting tool.
• Knowledge on Tableau 8.0
• Quick to understand the challenges and find solutions

TECHNICAL SKILLS:

Databases: SQL Server 2000/ 2005/ 2008/2012/2014

Business Intelligence Tools: SSAS, SSIS and SSRS

OLAP Querying: MDX and DMX

Reporting Tools: SSRS, Report Builder, Panorama/Nova view and Tableau 8.0,Power BI

IDEs: Visual Studio 2005 and 2008

Programming: VB and T-SQL

Server Environment: Windows 2003 and 2008

Tools: Excel Macros and OLAP Pivot tables

PROFESSIONAL EXPERIENCE:

Confidential, Miami, FL

BI Data Services Engineer

Responsibilities:

• Manage the resolution of technical defects for the BI Applications. Applications will include Microsoft SQL Server, Microsoft SSIS, Microsoft SSAS and Microsoft SSRS.
• Continuously monitor the UC4 jobs that runs more than 1000 SSIS packages that loads large volumes of Data for the database sizes ranging up to 20 TB to meet the SLA requirements.
• Promptly respond to production issues that are generated by automated notifications such as Incidents or service tickets or email alerts by UC4 Scheduling tool.
• Identify and Analyze the cause of the issue and notifying users of the status of the resolution.
• Bug fixing and Resolution for adhoc issues
• Record and document defects in an issue tracking system with the resolution steps.
• Resolve defects within the corresponding SLAs and Notify the users.
• Code defects - Notify the Assurant BI development team of the code defect. Debug and fix the defect by enhancing the SSIS packages or SSAS cubes and Reports.
• Infrastructure defects - If a defect is related to a hardware failure, notify the appropriate ACT team. When feasible, document the root cause analysis from ACT and the permanent solution implemented.
• Look for bottlenecks or optimizations in the ETL processes as directed by Assurant.
• Identify and propose opportunities for automation of repeatable manual support processes.
• Assist with query tuning and performance analysis as requested by Assurant.
• Record and document defects in an issue tracking system with the resolution steps.
• Design, develop and publish the Performance reports and dashboards using Power BI Analytics

Environment: SQL Server 2008/2012/2014 , SSIS, SSAS (tabular and MDX),SSRS,Power BI MDX,TFS, Automic UC4.

Confidential, Knoxville, TN

BI Data Developer (SSAS)

Responsibilities:

• Working as SSAS Developer in Agile/Scrum environment
• Prepare the XMLA and XML scripts to create, process and delete the partitions..
• Custom scripting using C#.net script in SSIS for XMLA queries
• Create SSIS packages /T SQL Queries to automate the cube process.
• Prepared the deployments scripts and UAT support after moving to the production.
• Done Unit Testing to compare results between source and destination and documenting the unit test results.
• Documenting the technical specifications, design and development procedures.
• Attending the periodical reviews with clients/user to discuss the issues, changes and progress of development in Daily meetings.
• Securing and maintaining the Code using SVN

Environment: SQL Server 2012, SSAS, SSIS, MDX,TFS

Confidential, Nashville, TN

Data Integration Developer (SSIS)

Responsibilities:

• Working as ETL and Report Developer using SSIS/SSRS for Confidential and Confidential .
• Involved in Requirements analysis.
• Design the ETL Solution using SSIS and Its components.
• Loading data from multiple source locations like SQL Server, SFTP and Excel and Text files.
• Custom scripting using C#.net script and VB.net script
• Preparing complex Transact SQL queries using joins and CTEs to get data from Various SQL databases.
• Connected to Vendor data sources using Win SCP SFTP tool.
• Loading the Dimension and Fact tables using different SSIS tasks like Lookup, Merge Join, and Sort etc...
• Cleansing the data in Stage tables by writing stored procedures to remove duplicates, handling the NULLS, unknown values etc...
• Written Complex T SQL queries, stored procedures, views for data cleansing and reporting
• Prepared the deployments scripts and UAT support after moving to the production.
• Done Unit Testing to compare results between source and destination and documenting the unit test results.
• Documenting the technical specifications, design and development procedures.
• Attending the periodical reviews with clients/user to discuss the issues, changes and progress of development.
• Worked in Different report formats like Tabular and Matrix various kind of reports.
• Created and deployed reports using Dynamic T SQL queries in different modes like SSDT and Report manager.
• Created Snap shot reports, Data Driven Subscriptions, Subscriptions.
• Securing and maintaining the Code using TFS

Environment: SQL Server 2005/2008, SSAS, SSIS, SSRS and Visual studio 2013, MS Excel.

Confidential, Detroit, MI

Sr SQL Developer/ Lead (SQL Server 2012)

Responsibilities:

• Working as SQL Server Developer for SPD and RTD2 applications
• Migrating MS Access Tables and Queries to SQL Server using SSMA.
• Creating the Stored procedures in SQL Server for the queries used in MS Access using some parameters to remove the code duplication.
• Creating Pass through queries using ODBC connection to communicate between SQL Server and MS Access.
• Creating Linked Excel files to load data from Excel to MS Access.
• Fine Tuning the SQL Server Stored procedures to get better I/O between MS access and SQL Server.
• Modifying the VBA code MS access to connect to SQL Server.
• UAT Support and Warranty support after moving to the production.
• Documenting the technical specifications, design and development procedures.
• Preparing the deployment scripts and process of deployment and documenting.
• Attending the periodical reviews with clients/user to discuss the issues, changes and progress of development.

Environment: SQL Server 2012, MS Access 2007, VBA and Excel.

Confidential, Overland Park, KS

Tech Lead/ Sr Developer (SSAS/SSIS/SSRS)

Responsibilities:

• Working as an SSAS (multi-dimensional and Tabular) /SSIS Lead and developer for multiple vendor projects. participating in Requirements discussion to understand the requirements to design the OLAP Structure
• Identifying the new dimensions, attributes and defining the hierarchies by studying the requirements.
• Identifying the Fact tables and measure groups. Designing the schema for the cube.
• Creating dimensions and cubes.
• Modifying the cubes like adding calculations and changing the measure properties for enhancements.
• Adding the new calculations to the cube using MDX and DAX( Calculated measures/Calculated Dimensions members)
• Modifying and deploying the cubes as per business need using Deployment wizard.
• Reviewing the current process flow and upcoming changes with the clients on conference calls.
• Periodic review and documenting the changes.
• Defining and documenting the SOP for support process.
• Creating and deploying the SSIS packages to process the cubes in various process options using XMLA.
• Cube Optimization like partitioning the cubes and defining the process criteria.
• Implementing the high availability activities like Synchronization and scheduled processing.
• Creating SSIS packages using Data Flow and Control flow tasks to load data from Flat files/other Ole DB Sources.
• Loading Dimension data using Look ups and Merging transformations.
• Cleansing the data using Lookups/Derived Column/ Conditional Split other transformations to avoid loading unknown or invalid facts/dimension members.
• Custom scripting using C#.net script and VB.net script
• Written Complex T SQL or Transact SQL queries, stored procedures, views for data cleansing and reporting
• Unit testing to compare results between source and destination and documenting the unit test results.
• UAT Support and Warranty support after moving to the production.
• Documenting the technical specifications, design and development procedures.
• Preparing the deployment scripts and process of deployment and documenting.
• Attending the periodical reviews with clients/user to discuss the issues, changes and progress of development.
• Worked on creating different reports like Table or Matrix using SSRS.
• Worked on Data Analysis for Issue debugging and Resolution and also for complex querying. Good Understanding of source and Target data mappings.
• Created various reports like Drill down, Drill through, Static, Sub reports. Deploying the reports.
• Creating Subscriptions to the reports using Report Manager
• Guiding and role playing as mentor in the team.
• Coordinate with On site for issues and clarifications.
• Securing or maintain the code and scripts using VSS and subversion
• Mentoring the Team for issue fixing and status reporting.

Environment: SQL Server 2005/2008, SSAS, SSIS, SSRS and Panorama Nova view, Visual studio 2008, MS Excel Pivot.

Confidential, Parsippany, NJ

Data warehouse developer and Production Support Engineer

Responsibilities:

• Involved in Mart and Stage databases designing using SQL Server
• Creating the OLAP cubes to view data at dimension level.
• Involved in design and development of DTS packages to pull data from flat file/JDE source to mart.
• Involved in writing the excel macros for Input, master and Security data loaders with necessary validations using VBA
• Providing the access to the users.
• Documenting the technical flow and Defining the support process
• Unit testing and test results .
• Providing Level 3 and Leve4 support.
• Coordinate with On-site team to fix the production issues

Environment: SQL Server 2000, DTS, MSOLAP, MRS, VB and Excel Macros, Windows 2003

Confidential, Parsippany, NJ

Responsibilities:

• Involved in designing Mart and Stage databases designing using SQL Server
• Creation of DTS packages to load data from JDE and flat file sources.
• Involved in the technical documentation of the project flow
• Defining dimension hierarchies and creating OLAP cubes.
• Documenting the technical flow of the project and defining the support process.
• Developing and enhancing the performance of the application
• Attending priority meetings with the clients and understanding the upcoming business needs
• To provide 24x6 production support for over 7 SQL Servers instances with 64 databases with sizes ranging from 25 GB to 60 GB to achieve maximum performance and up time in production environment
• Bug fixing and Patch Implementation
• Coordinate with On-site team to fix the production issues

Environment: SQL Server 2000, DTS, MSOLAP, MRS, VB and Excel Macros, Windows 2003