SUMMARY

• Around 11 years of total IT experience
• Around 11 years of Microsoft Business Intelligence Experience (MS BI)
• Extensive experienced In database modeling, design, data integration and Migration
• Extensive Data Transformation experience using SSIS and reporting Services using SSRS
• Extensive scripting & reporting experience using VBA, MS Access & Excel Macros
• Around 11 years of rich experience in Requirement Analysis, Design, Development & Implementation, Testing & Deployment and Production support/Maintenance Activities of complete software development life cycle (SDLC) in field of Desktop Applications, Microsoft web and client/server technologies
• Worked extensively on Data warehousing and Client Server applications using SQL Server Integration Services (SSIS), SQL Reporting Services (SSRS) and SQL Server Analysis Services (SSAS), SQL Server 2014/2012/2008 / R2/2005/2000/ and .NET Framework
• Experienced in VBA (Excel Macros, MS - Access), .NET (C#) and MIS Finance Systems
• Expert level knowledge of RDBS and SQL relationships, Excel 2010 and 2013 especially Pivot tables(Power pivots, Power query and closely work with Dashboard reports).
• Mocked the required reports ( by visualizing and Exploring the data) for day-to- day review ofthe supplier data using Power BI
• Created interactive dashboards and reports with visualization using Power BI by pulling thedata from SQL server and Excel spread sheets.
• Good experience on Asset Management Financial Products and TLM PLM Financial System products for Reconciliation.
• Experienced in Management Information System reports.
• Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2012/2014.
• Experience inDisaster Recovery Planning, Execution and Testing at remote side.
• Experience in using SQL Server Tools like DTS,Import/Export Wizard, SQL Server Enterprise Manager, SQL ProfilerandSQL Query Analyzer.
• Migration experience fromMS SQL Server 2000toMS SQL Server 2005/2008,MS SQL Server 2005toMS SQL Server 2008.
• Master in performing administrative tasks: database files management,backup/restore, security management,Database Mirroring, data integrationandsynchronization.
• Extensive use of DTS/SSIS in SQL Server, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managing server and clients.
• Good knowledge of Relational Database Management Systems (RDBMS) with experience in Database Design, Development, Data model analysis & Data migration using MS SQL Server 2000/05/08/12
• In-depth knowledge in various RDBMS concepts like Database,Table,Table Normalization, writing complex Database Queries, Stored procedures, Triggers, Cursors in MS SQL Server
• Strong experience in DDL, DML, T-SQL, views, functions and packages
• Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database
• Expert level skills on T-SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2005/2008/R2/2012/2014
• Experience in creating Reports, Jobs, Alerts, SQL Mail Agent and Scheduling SSIS Packages
• Good experience and understanding of database design, relational integrity constraints, OLTP, OLAP, Cubes and normalizations
• Supported team in resolving SQL Reporting services and ETL related issues
• Good experience with SQL Server 2005/2008/R2/2000, SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS (SQL Server Analysis Services)
• Expert in preparing all types of reports using SSRS
• Familiar with Complex Reporting Requirements - Complex Drill - Through, charts, Discontinuous Cross Tabs and Summary Reports. Experience in dimensional modeling using Star Schema and Snow-Flake Schema, Data Analysis providing Business Intelligence solutions
• Dedicated Team Player with high tolerance & patience level, humorous nature and good in communication & Interpersonal skills
• Capable of performing under minimal supervision, multi-tasking, meet deadlines as an individual contributor and a committed team player
• Good Experience in Implementing Transactions etc.,
• Good Experience in building Package deployment and package Configuration
• Exceptional ability to adapt to latest technologies, perseverance, innovative and organized
• Organized approach to solve problem with good decision- making skills

TECHNICAL SKILLS

BI Data Warehouse Tools: SSIS, SSRS, SSAS (Integration, Reporting and Analysis) Tools

Databases: MS SQL Server 2014/ 2012/2008 R 2/2008/2005/2000

Languages: T-SQL, VBA (Excel macros, MS-Access), C#, ASP.Net,ADO.Net, PL/SQL, Visual Basic 6.0

Reporting/ETL: SSRS, SSIS, SSAS, Power BI (Power Pivot, Query and view)

Platforms/OS: Windows XP, Windows 7, Windows 2000/NT/XP/2003/2008

Others: BIDS, Visual Studio.Net 2005/2008, MS-Office 2010/2008/2005/2003/99

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Sr SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Created complex SSIS packages, SSRS reports, Stored Procedures and Functions, Views, Indexes which
• Worked on millions of data and did Data profiling and analysis and built business logic and gathered
• Requirements before the project.Data Migration involved in moving of .DAT files (98 segments) and loading those files into SQL serverTables using Archive, Delete and Insert logic in the stored procedures.
• Created Success and fall out SSRS reports which will have count of providers before and after loads.
• Worked on C# code to build logic to check whether source files exists before the process starts.
• Experienced in checking the code in Sub Versions and TFS.
• Created Technical Design & Support documents on the data migration projects on each task to describe the process.
• Worked on Oracle SQL Developer and TOAD to pull the data from Oracle environment.
• Worked on Oracle database to pull data from Oracle to SQL Server using SSIS and Oracle packages andMicrosoft Attunity drivers.
• Worked on Data Movement and similar technologies in the migration projects. Such as Power Pivot 2013, 2010, SSRS, groups, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Creating different Parameterized Reports (SSRS 2014/2012) like standard parameter reports,
• Cascading parameter reports which consist of report Criteria in various reports to make minimize the report Creating Power Pivot, Power query, Analysis, View in Excel 2013.
• Mocked the required reports ( by visualizing and Exploring the data) for day-to- day review ofThe supplier data using Power BI
• Responsible for SharePoint and Dashboard reports and prepared user stories to create compelling dashboards to deliver actionable insights Tracked and reported the data using excel spread sheets and Spark line graphs for individua
• Users and presented the overall data using PowerPoint slides designed with charts.
• Data analysis and Reporting - Visualize, summarize and communicate discoveries to the stakeholders, using BI Reporting tools such as Tableau, Power BI and Excel Pivots.
• Execution time and to limit the no of records required.
• Developing SSIS packages to generate different types of flat file reports like fixed width file, pipe delimited file and CSV files.
• Responsible to build State Reports for different Markets and ADHOC reports as per request.
• Documented Back out Implementation Plan, Created CMD files and Created Subscriptions to Provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Defect Tracking and report the project status to client.
• Involved in query tuning for increasing the query performance.
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
• Used Pivot tables to provide structured Reports like monthly, weekly.
• Temp Tables are used for reduce the number of rows for joins, to aggregate data from different sources for different reports.
• Actively involved in creation of required database, modified tables, triggers, and procedures to clean andValidate the data to meet the specifications.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Build test scenarios and test cases (negative / positive) to validate expected outcome.
• Actively Involved in Testing and Debugging the Stored Procedures and T-SQL.
• Developed reports from SSAS cube with measure and dimension, configured attributes of dimension table with hierarchy relationships,
• Modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions
• Create SSAS Tabular Model and SSAS Cube Model and support the existing database components
• Build reports from Analysis Services cube using MDX query designer

Environment: MS SQL Server 2014/2012/2008 R2/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Dot net C#, Power BI (Power Pivot, Query and view)

Confidential, Virginia Beach, VA

Sr. SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Actively involved in gathering and analyzing the user requirements.
• Creating complex stored procedures, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Generating multiple enterprise reports from SQL Server Database (OLTP) including various reporting features
• Such as Power Pivot 2013, 2010, SSRS, groups, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Creating different Parameterized Reports (SSRS 2005/2008/2008 R2) like standard parameter reports,
• Cascading parameter reports which consist of report Criteria in various reports to make minimize the report Creating Power Pivot, Power query, Analysis, View in Excel 2013.
• Mocked the required reports ( by visualizing and Exploring the data) for day-to- day review ofThe supplier data using Power BI
• Responsible for SharePoint and Dashboard reports and prepared user stories to create compelling dashboards to deliver actionable insights Tracked and reported the data using excel spread sheets and Spark line graphs for individual
• Users and presented the overall data using PowerPoint slides designed with charts.
• Data analysis and Reporting - Visualize, summarize and communicate discoveries to the stakeholders, using BI Reporting tools such as Tableau, Power BI and Excel Pivots.
• Execution time and to limit the no of records required.
• Developing SSIS packages to generate different types of flat file reports like fixed width file, pipe delimited file and CSV files.
• Responsible to build State Reports for different Markets and ADHOC reports as per request.
• Documented Back out Implementation Plan, Created CMD files and Created Subscriptions to Provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Defect Tracking and report the project status to client.
• Involved in query tuning for increasing the query performance.
• Used complex queries to pull data from excel as well as other databases to the table that has been designed schema.
• Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Build test scenarios and test cases (negative / positive) to validate expected outcome.
• Actively Involved in Testing and Debugging the Stored Procedures and T-SQL.
• Developed reports from SSAS cube with measure and dimension, configured attributes of dimension table with hierarchy relationships,
• Modified cube and dimensions, deployed KPIs on SSRS and created different metrics, added new measure groups and dimensions
• Create SSAS Tabular Model and SSAS Cube Model and support the existing database components
• Build reports from Analysis Services cube using MDX query designer

Environment: MS SQL Server 2012/2008R2/2008, SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), Dot net C#, Power BI (Power Pivot, Query and view)

Confidential, Columbus, OH

Senior SSIS/SSRS/VBA Developer

Responsibilities:

• Worked with Business Analysts to understand the requirements and designing and implementing the database schema.
• Maintaining/Supporting Data Warehouse to retrieve and analyze data in Staging and Production Environment
• Monitoredthe complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments usingSQLServer 2005/2000.
• Involved inDatabase Backupandrecovery.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Implemented high availability on the various servers usingreplication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Expert inanalyzing, designing, developing, installing, configuringanddeployingMS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Created Data Model or the Management Information System Team using Erwin.
• Designed packages Using Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task.
• Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling SSIS Packages and reports.
• Created and Scheduled SQL jobs to run SSIS packages into the data warehouse on a daily basis
• Experienced in various RDBMS concepts like Database,Table,Table Normalization, writing complex Database Queries, Transact-SQL (stored procedures, views, triggers, sub-queries, joins and Cursors) in MS SQL Server
• Worked on Table Partitioning to load current and historical data.
• Created and Managed Views, Indexes, Procedures, and Maintained Referential Integrity
• Created Clustered and Non-Clustered Indexes for Query Optimization and also involved in Database Tuning
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP), andSQL Server Integration Services(SSIS) (2005/2008).
• Loaded flat files (4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.
• Loading & Maintaining data in a centralized repository for various financial reports on business performance that were used for Management Reporting
• Aided in development and management of Access database solutions using SQL Server, including VBA (Excel Macros, MS-Access), .net (C#, Asp.net), SSIS, SSRS reports.
• Interacting with business analysts and developers in identifying the requirements
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Configured Dimensional modeling for End-User from Hierarchy perspectives.
• Convert existing manual Excel and Access datasets/reports into Analysis Services solutions
• Created several Dashboards and Scorecards and designed and built OLAP cubes to meet reporting needs.
• Provide Business Intelligence solutions to enable more effective strategic and operational insights and decision-making
• Created dashboard of key metrics utilizing Power BI and Tableau to provide project managers with a oneStop shop for managing projects; track produced and backlog revenue against plan, measure gap to plan.
• Creating Power Pivot, Power query, Analysis, View in Excel 2013. Responsible for SharePoint and
• Dashboard reports and prepared user stories to create compelling dashboards to deliver actionable insights.
• Created reports using SSRS i.e., Parameterized, Drill Down, Drill Through, Sub Reports, Charts, Table,Matrix and Charts
• Responsible for Deploying reports to Report Manager and Troubleshooting for any error occurs in execution
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Scheduled the reports to run on daily, weekly basis in the report Manager.
• Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.
• Conduct Business Systems Analysis to assess business models and their integration with technology
• Implemented complex business requirement for generating weekly, monthly Dashboards in backend using Efficient Stored Procedures and flexible functions, and facilitated easy implementation to the front end application
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also sent email to analysts to review in Excel Sheet
• Created the reports using Excel (Macros) and MS-Access Database (VBA)
• Assisted with automation of finance department’s manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy
• Created the reports using Qlik view

Environment: Microsoft BIDS, SQL Server, SSIS, SSRS, SSAS, VBA (Excel Macros, MS Access), .NET(C#), Power BI (Power Pivot, Query and view)

Confidential, Sacramento, CA

SSIS/SSRS Developer

Responsibilities:

• Supporting/Maintaining and Developing Data Warehouse to retrieve and analyze data in Staging and Production Environment
• Configuring, tuning and optimizing SQL Server 2000.
• Administrator tasks like managing users, roles and permissions.
• Involved in complete database design including conceptual, logical and physical models.
• Performance testing on stored procedures, indexes, and triggers.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups forSQL and Oracle Databases.
• Maintained high availability of databases usingDatabase MirroringandLog Shipping.
• Designed packages Using Control Flow Tasks like for Loop Container, For Each Loop Container, Sequential Container, Execute SQL Task, and Data Flow Task.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations in providingLogging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports usingSQL Server Reporting Services, Crystal Reports, and MS Excel Power View.
• Created Event Handlers for the Packages Using Event Handler Tab for Error Handling.
• Created Configurations to change the package properties dynamically.
• Maintained log information in SQL table to tracking Errors and recording package execution status.
• Build and Deployed packages to SQL server and Scheduling Packages for Intra Day and End of Day execution.
• As per requirements developed the reports in the form of Matrix, Table and Chart using SQL Server 2005 Reporting Services.
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports and Parameterized Reports.
• Development of reports using different SSRS Functionalities like sort prompts and cascading parameters, Multi Value Parameters.
• Experience in solving Real Time issues withIndex fragmentation, DBCC checks, Query Tuning, ErrorandEvent Handling.
• Implemented replication in SQL Server for managing and scaling databases in an enterprise environment.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Run Import/Export wizard to provide Excel files to Managers for particular reports.
• Used SQL Server Analysis Services (SSAS) to design cubes for summary reports.
• Scheduled Reports Weekly and Monthly basis as per the Client Requirements.
• Created the reports using Excel (Macros) and MS Access database (VBA).

Environment: Microsoft BIDS, SQL Server, SSIS, SSRS 2008 R2. VBA (Excel Macros, MS-Access), .NET(C#)

Confidential

Software Engineer

Responsibilities:

• Responsible for all project lifecycle phases, from specifications and coding through deployment, testing, debugging, documentation, and maintenance.
• Used business requirements and functional specifications to generate logical data models
• Worked on complete SDLC from Extraction, Transformation and Loading of data.
• Responsible for the design, development and implementation of mappings /transformations based on source-to-target specifications, defining ETL (extract, transform, load) development standards and conventions
• Used Import/Export Wizard. To quickly move data into or out of SQL Server from or to a variety of sources, including text files and other SQL Server instances.
• Dropped and recreated the indexes on tables for performance improvements. Used Index tuning wizard for tuning of indexes.
• Primarily responsible for developing database solutions that provide the business with the information needed to make daily operating and strategic decisions. Perform data modeling activities, application performance tuningand code reviews.
• Implemented various high availability options for SQL server 2005/2008 includingreplication.
• Tested point in time recovery of the production 2008 databases using the traditionalbackup/restoretechnique.
• Setup replication for high availability.
• Understanding and Profiling the Client Database, and documented requirement specifications.
• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Requirements gathering and preparing the specifications for the client according to the application requirements.
• Verifying the data sent from the customer to check if it is as per the application requirements or not.
• Involved in writing the stored procedures, Triggers and User Defined functions in SQL Server for Data Validation and Data Loading.
• Implemented an Automated ETL Solution which will automatically load the data from source files to SQL Server database tables.
• Scheduling and Monitoring the ETL Packages for daily load in SQL Server job Agent.

Environment: Microsoft BIDS, SQL Server, SSIS, SSRS 2008 R2. VBA (Excel Macros, MS-Access), .NET(C#)

Confidential

Software Engineer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.
• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.
• Scheduled and executed SSIS Packages using SQL Server Agent.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.
• Created the reports using Excel(Macros) and MSAccess database(Vba) .
• Writing server side scripting using C#.Net.
• Involved in user interface design using ASP.Net web forms.
• Created Sitemap using HTML, DHTML, JavaScript
• Extensively involved in Bug fixes and Enhancements
• Designed and implemented Data access layer using ADO.NET to connect and retrieve or manipulate database
• Presented designs and concepts to Clients and the Management for review
• Programming & Troubleshooting for errors in database connectivity with MS SQL server