SUMMARY

• Over 8+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like financial services, Health Care, Pharmaceuticals and Constructions.
• Involved in various stages of Report Developments including Data analysis, Report designing, development, enhancements and testing of Reports.
• Experience in RDBMS Concepts, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER - diagrams using tools like MS Visio.
• Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design based on the requirements.
• Experience in designing, creating, maintaining, and deploying form reports, tabular reports, drilldown reports, drill through reports, ad hoc reports, multicolumn reports, matrix, and charts using Tableau.
• Experience in developing Dashboards, Parameterized Reports, linked reports and Sub reports using SQL Server Reporting Services and Tableau
• Worked on the designing of custom objects, custom fields, role based Report layouts, custom Tabs, custom reports, report folders, report extractions to various formats, Snapshots, Dashboards and various other components as per the client’s report requirements.
• Designed reporting objects and implemented various advanced fields like checklist, Custom Formula Fields, Field Dependencies, Validation Rules and Work Flows according to reports requirements.
• Experience in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, and Bulk Insert utilities.
• Experience in writing Complex T-SQL queries, dynamic-queries, sub-queries and complex joins, Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2005/2008/2012 .
• Highly Experienced in creating Views, Triggers, Functions, Batch Scripts and stored procedures consumed at various stages of migration/cleansing process, reports or data validation.
• Experience in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).
• Hands on experience in transformation of heterogeneous data sources into a variety of SSIS transformations and good knowledge in applying ETL concepts.
• Work experience on error handling at different levels of SSIS packages like control flow level and data flow level.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages, Performance Tuning in SSIS packages by using transformations.
• Lead both on-site and off-shore team to develop, test and deliver the clients enterprise data requirements.
• Strong team player with excellent communication, analytical, interpersonal and writing skills, committed, result oriented, hard working with a quest and zeal to learn new technologies.

TECHNICAL SKILLS

BI & DW Tools: SSIS, SSAS, SSRS, Tableau 8.2/9, Crystal Reports, Google Analytics, Business Objects

ERP: MS Dynamics Axapta 2009 - Financials (Microsoft Certified)

Databases: SQL Server 2000, 2005/2008/2012 , MS-Access, Teradata, DB2

Programming: SQL, T-SQL, Visual Basic, Visual C++, Power Builder

Web: Html, CSS

Operating System: Windows 2000/XP/Vista/8, Ubuntu, Mac OSX

Creative Tools: Visio, Visual Studio, Adobe Photoshop, MS Office Suite, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, CA

SQL BI Developer/Lead

Responsibilities:

• Experienced in complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.
• Designed and developed weekly, monthly, quarterly and yearly reports to the Federal Government.
• Involved in creation of data modeling techniques and set up SQL Server configuration settings.
• Maintained the OLAP cubes for accurate reporting.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets f data using SSAS and used Multi - Dimensional Expression (MDX) to access them.
• Coordinated with DBA in creating and managing tables, indexes, triggers etc. Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in Data migration, development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2008/2008 R2, SSAS, T-SQL, SQL Profiler, SSIS, SSRS

Confidential, Shelbyville, TN

Lead SQL BI Developer

Responsibilities:

• Gathered reporting requirements and identified critical functional modules for report design and required data analysis.
• Created detailed reports for the end users to help them decide which area needs to be taken care by showing demographic information based on various parameters.
• Generated periodic reports based on the financial analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operationalDrill-throughandDrill-downreports usingSSRS
• Developed different kind of reports such aSub Reports,Charts,Matrix reports,Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved withQuery Optimizationto increase the performance of the Report.
• Developed Reports for business end users usingReport Builderwith updating Statistics.
• Involved in Analyzing, designing, building &, testing ofSSRS reports using OLAP cubesas data source with MDX queries.
• Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.
• Created parameterized and adhoc reports using Report builder for the Manufacturing and financial departments.
• Deployed SSRS reports in multiple environments like report server, Share point folders etc.,
• Extracted data using Query Analyzer and SSIS packages.
• Optimized queries tuned and monitored server performance to run the SSRS reports efficiently.
• Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.

Environment: SQL, SSRS, SSAS, MDX, SQL Server 2008/2012, Crystal Reports, Oracle, MS Excel

Confidential, Irvine, CA

Tableau/MSBI Developer

Responsibilities:

• Gathered business requirements and identified critical functional modules for report design and required data analysis.
• Created reports using Tableau like Drill-Down, Drill-Through, Filters, Parameters and Cross Tabs etc.
• Interact with Business Users, Database team to know their requirement in developing and updating reports in order to meet the end users reporting goals.
• Developed interactive Dashboards Using Tableau reporting tools.
• Created and deployed Dashboards by connecting discrete data sources systems like Excel, Access and XML database using SSIS with different transformations to cleanse the data and used various functionalities available in Tableau based on client’s requirements.
• Used Alerts, KPIs to highlight data wherever required in business reports and prompt in deliverables.
• Maintained and migrated OLAP cubes for accurate reporting in Tableau
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data using SSAS and used Multi-Dimensional Expression (MDX) to access them.
• Experienced in SSAS tabular models and DAX queries to generate reports in power pivot modes in MS Excel files.
• Involved in comparing, validating and migrating the reports in different Environments including Tableau server administration.
• Stored procedures scripts tuning and understanding Joins, views, functions etc. for resolving report data requirements.
• Involved in creation of custom fields, field dependencies, tabs of the reports.
• Involved in all the phases of projects from report design level to technical implementation phase and includes client support as well.
• Developed Tableau KT plans, materials and documentation for business users and keep the documents up-to-date.

Environment: SSIS, SSAS, SSRS, Tableau, SQL Server 2008/2012, Crystal Reports, Google Analytics, MS Excel, MS Visio

Confidential, Elverta, CA

Tableau/MSBI Developer

Responsibilities:

• Interact with Business Users to understand requirements in developing and updating reports in order to meet the reporting goals.
• Developed various operational Drill-through and Drill-down reports using SSRS and tableau.
• Developed different kind of reports available in SSRS & Tableau such a Sub Reports, Charts, Matrix reports, Linked reports etc.,
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Developed interactive Dashboards Using DESKI, WEBI, Xcelsius and SSRS tools depending upon the reporting requirements.
• Published Reports on the web using Crystal Reports Enterprise Wizard and CMC.
• Created Dashboards by connecting discrete data sources systems like MS Excel, XML database and using various functionalities available in SSRS and Tableau based on client’s requirement.
• Used Alerts to highlight columns based business reports and prompts to deliverables.
• Involved in comparing, validating and migrating the reports in different Environments.
• Fine tuning T-SQL procedures by understanding Joins, indexes and scripts for resolving report requirements.
• Involved in creation of custom fields, field dependencies and tabs of the reports.
• Involved in all the phases of project from functional report design to technical implementations and support.
• Modify the existing report and security management of the report and deployed as per the report requirements.

Environment: Tableau, SSIS, SSRS, SSAS, Business Objects, Crystal Reports, SQL Server 2008/2012, Teradata, MS-Access

Confidential, Green Bay, WI

Tableau/ MSBI Developer

Responsibilities:

• Understood an existing system and designed modifications to the system to support new requirements.
• Involved in requirements gathering, analysis, design, development, deployment and user training.
• Created complex formulae in Tableau crystal reports using different type of variables likes report variable and group variable wherever it is required in the report.
• Designed, developed and tested processes which include the creation of SQL views, scripts, stored procedures whenever required.
• Involved in writing Custom Functions to be used with other Functions.
• Designed, developed and tested processes which include the automation of SQL views, scripts, stored procedures using SQL Server Agent.
• Tuned and optimized SQL statements, stored procedures and views using SQL server Profiler.
• Wrote complex SQL queries and could quickly understand requirements for complex queries while creating SSRS crystal reports.
• Configured, patched, tested, and maintained SQL Server database instances.

Environment: Tableau, Crystal Reports, MS SQL Server 2008/2012, SSRS, Oracle 8i, T-SQL, SSIS, MS Excel

Confidential, Austin, TX

MSBI Developer

Responsibilities:

• Experienced in complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.
• Designed and developedmonthly, quarterly and yearly reports at branch and bank level.
• Involved in creation of data modeling techniques and set up SQL Server configuration settings.
• Analyzed complex queries and tune the same to optimize application and system performance.
• Coordinated with DBA in creating and managing tables, indexes, triggers etc.,
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.
• Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.
• Optimized long running Stored Procedures and Queries for effective data retrieval.
• Involved in Data migration, development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2005/2008/2012 , T-SQL, SQL Profiler, SSIS, SSRS, MS Visio, MS Excel

Confidential, Winchester, TN

SQL BI Developer

Responsibilities:

• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.
• Involved in Extract, Transform and Load (ETL) process framework for the large amount of data.
• Developed SSIS packages using different types of containers to optimize the performance of the packages.
• ETL development using T-SQL programming, scripts, stored procedures and views.
• Experience with ER and Dimensional modeling to define the data management.
• Involved in Performance tuning and Query Optimization whenever it required.
• Created multiple MDX query, views and complex queries against cubes to develop multi-functionality using SSRS.
• Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SSIS in SQL Server to overcome transformation constraints.
• Responsible for developing source to target mappings.
• Involved in user interface design and developed scripts to support client business needs.
• Worked with business analyst to understand business processes, gather and document project requirements and transformed them into functional and non-functional specifications for BI reports and applications.

Environment: SQL Server 2008R2, MS Visio, VB, MS office, MS BIDS, T-SQL, SQL Profiler, SQL Server Agents in SSMS, DB2, Access, MS Excel

Confidential

SQL Server Developer

Responsibilities:

• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.
• Experienced in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers along with in- depth knowledge in query optimization & performance tuning.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Created Indexes based on requirements like Clustered index, Non-clustered to increase the query performance.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard
• Performed daily tasks including backup and restore data by using SSMS tools like SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.

Environment: SQL, SQL Server Management Studio 2005/2008, SQL Server Profiler, SQL Server Agent