SUMMARY:

• 7+ years of industry experience in development and implementation of business requirements with Microsoft .Net technologies, PowerBI, SQL Server 2016/2014/ 2012/2008/2005/2000, oracle 8, tableau, pentaho ETL, netezza, talend and with front - end tools like VB.NET, VB Scripting.
• Prformed the role of BizTalk, Technology Analyst, Sr. MSBI Consultant/Sr. SQL developer/Programmer as well as database administrator.
• Experience in database programming and optimization ETL strategies using SSIS/SSRS/SSAS & DB2. Capable to developing/supporting Power BI, Business /Web Application using Visual Basic, Database designing using SQL Server 2000/2005/2008.
• Expertise in Requirement analysis, Database design, Data modeling (Erwin) and complete software lifecycle.
• Experience in Extraction, Transformation and Loading (ETL) in SQL Server database. Experience in supporting multiple production database servers. Experienced in designing relationship database using entity relationship diagrams.
• Expert in creating complex stored procedures, and queries for the application team and for the end users based on the business requirements.
• Expert in T-SQL PL/ SQL coding, testing functions, ad-hoc SQL queries, views, triggers, cursors, data types, indexes, and system tables.
• Knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analytics Services (SSAS).
• Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined data types, effective functions, cursors and indexes using T-SQL.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services ( SSIS ), Log Shipping, DTS, Bulk Insert and BCP.
• Experience in T-SQL, SSIS, SSRS, BI suite, Reporting and Analytics and knowledge in OLAP
• Excellent experience in migrating DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2008, 2014, SSIS packages.
• Experience in MS SQL Server Installation, Configuration, Performance Tuning, client/server connectivity, building servers, trouble shooting, clustering, query optimization, back-up/recovery, running Database Consistency Checks using DBCC and troubleshooting on large databases and maintaining, supporting, monitoring production and test environment
• Excellent experience in MS Dynamics AX, Micro strategy, Reporting implementation of Crystal Reports/ SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)

TECHNICAL SKILLS:

• Python
• C/ C++/ C#
• T-SQL
• Power-BI
• Informatica
• Tibco Spotfire
• Tableau
• Netezza
• BIDS
• SSIS
• Angular JS
• MS-Access
• SSRS and SSAS
• MS EXCEL
• SharePoint
• ETL Tools
• Informatica
• TFS
• SQL SERVER 2005/2008 R2/2014/2016
• PL/SQL (Oracle 12C)
• Microsoft .NET 3.5 and 4.0
• SQL Server Management Studio
• Cosmos and OLAP
• MS Visual Studio 2008/2010
• POWER BI Development Studio
• Visual Basic
• Linux/UNIX.

PROFESSIONAL EXPERIENCE:

MSBI developer

Confidential - Fairfax, VA

Responsibilities:

• Database design and development on MS SQL 2008.
• Development using MS SQL Reporting services, SSIS/DTS packages and SSAS Tabular/Cubes.
• Preparing system design documentation.
• Responsible for designing and creating a staging database for temporary processing of data, consolidating data and loading data to central repository using SQL Server Integration Services (SSIS).
• Created stored procedures to load data using incremental loading techniques.
• Involved in applying data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using SQL Server Profiler and Index Tuning Wizard.
• Filtered data from Transient Stage to EDW by using complex T-SQL statements in Execute SQL Query Task and in Transformations and implemented various Constraints and Triggers for data consistency and to preserve data integrity.
• Writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and SQLCMD.
• Used data conversion tasks in SSIS to load the data from flat file to SQL Server database.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed, monitored and deployed SSIS packages.
• Created document for Self-Service Deployment and Execution process for SSIS packages.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.

Environment: PL/SQL, SQL Server 2016/2014/2012/2008/2005 R2, 2012, SSAS, SSIS, SSRS, Windows Server 2008 R2, Visual Studio 2010, C#.Net, Oracle 9i, 11g, Teradata, TFS, Crystal Reports, AngularJS, Micro strategy, MS Dynamics AX, UNIX, LINUX, Azure, Mongo DB.

MSBI Developer

Confidential - McLean, VA

Responsibilities:

• Demonstrable knowledgeable experience with Informatica, Oracle SQL, PL/SQL development.
• Developed tools using python, shell scripting, XML to automate tasks.
• Involved in projects with Power BI environment and tableau, also done ETL using Talend.
• Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• Created several SSIS schedule tasks and monitored those tasks regularly.
• Developed SSIS packages using different types of Error Handling for various events.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Handled Performance Tuning and Optimization of SSIS packages.
• Develop Exception handling process and audit process for each ETL package
• Developing SQL code such as writing complex queries, stored procedures, user defined function etc.
• Monitor and SQL profiler and tuned queries and procedures to boost database performance
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, SCD to load data into Database.
• Involved in creating proxy accounts and Scheduling Jobs to execute SSIS packages.
• Responsible for creating database objects like table, Views, Store Procedure, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Created and managed Interactivity Financials SSRS reports (Parameterized, Linked, Drilldown, Drill through reports

Environment: PL/SQL, SQL Server 2016/2014/2012/2008/2005 R2, 2012, SSAS, SSIS, SSRS, Windows Server 2008 R2, Visual Studio 2010, C#.Net, Oracle 9i, 11g, Teradata, TFS, Crystal Reports, AngularJS, Micro strategy, MS Dynamics AX, UNIX, LINUX, Azure, Mongo DB.

SQL/MSBI Developer

Confidential - McLean, VA

Responsibilities:

• Work closely with the Banking projects & Business analysts for requirements gathering, designing the database and creating workflow for report in BizTalk server.
• Involved in query optimization and auditing. Developing SQL code such as writing complex queries, stored procedures etc.
• Responsible for creating database objects like Indexes, Table, Views, Store Procedure using T-SQL to provide structure to store data and to maintain database efficiently.
• Being active part of Database designing team, to identify integrity constraints for data integrity like Referential integrity using primary key and foreign keys relationships
• Creating Packages on SSIS by using different data Transformations like Derived Column, Lookup, Conditional Split, Script, Merge Join, Sort and Execute SQL Task, Script Component Task to load data into Database.
• Designed the staging database in order to extract and load the data from various sources optimally
• Develop Exception handling process and audit process for each ETL package.
• Created types of SSRS report (Parameterized, Linked, Drilldown, Drill through, Customized, dashboards, graphics) in SharePoint environment.
• Analyzing financial reporting data with the existing Data Warehouse system environment. Exporting data load from landing area to Tabular Mode environment in SQL Server 2012
• Developed detail and summary Financials reports, line and pie chart, trend analysis reports and sub reports according to business requirement using Power View /Pivot Table, Report builder and SSRS and Tableau & sharepoint.
• Developed detail and summary Quality and Test Result reports, line and pie chart and sub reports according to business requirement using Report builder, tableau and SSRS
• Involved in creating proxy accounts and Scheduling Jobs using SQL Agent to execute SSIS packages.
• Extensively worked on Consuming Web Services using SSIS Script Task.
• Create Scheduling for Database Backup and SSIS packages

Environment: Tibco Spotfire, KPI, Cosmos, BizTalk, tableau, Talend, Power BI, SQL Server 2014, 2012, SSRS, SSIS, Visual Studio 2010, C#.Net, Windows Server 2008R2, MS Tabular Model, DAX, SSAS, Power Pivot, Tableau, Web Services, Crystal Reports, Micro strategy, MS Dynamics AX 2012 R2, UNIX, LINUX, Azure, MongoDB.

Business Intelligence Developer

Confidential, Florida

Responsibilities:

• Handling large size databases which involve migration of data from Oracle to SQL.
• Worked with different business users in setting up data marts based on their Analysis/Reporting needs.
• Developed SQL scripts /libraries for various data loads and validation for both OLTP and OLAP systems.
• Created complex Stored Procedures, Triggers and User Defined Functions to support the front-end applications.
• Created and altered Databases, Tables, Views, Indexes and Constraints with business rules using T-SQL across all SDLC environments.
• Used Temporary tables, Table variables and Common Table Expressions (CTE's) depending on the requirements.
• Worked on Performance tuning, query optimization and execution plan of queries for better performance.
• Performed Code reviews for Production Deployment
• Worked with SSIS, ETL for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV and DB2.
• Used Cache Transforms for the Lookups especially while loading the Dimensions.
• Implemented SSIS features for Incremental Data Loads, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Extensively used SSIS for Transformations, Aggregations and Lookups.
• Followed standards & Naming Conventions while creating Packages and applied the best practices for efficiency and performance of the Packages.
• Debugged the SSIS errors by configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fixed the errors.
• Created Complex SSIS Packages using various data transformations like Conditional Splits, For Each loop, Multi cast, Fuzzy grouping etc.
• Worked on Dimensional Modeling in defining Relationships between Dimensions and Measure Groups like Fact Relationship,

Environment: MS SQL Server 2012/2008/2005/2000, Visual Studio, SQL Server Reporting Services (SSRS /2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server.

SQL Developer

Confidential

Responsibilities:

• Study and understand the requirements of the information required by company's Procurement.
• Migration of large scale databases from oracle to Sql.
• Troubleshooting and debugging queries.
• Designed Ad-Hoc reports as per the client requirements using PowerPivot.
• Involved in supporting more than 80+ Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Performed training for new employees about the MSBI tools especially SSRS and helped them to learn the tools.
• Support handling SQL tasks by collaborating with the team members.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Writing and Debugging T-SQL, stored procedures, Views and User Defined Functions.
• Data migration (import & export - BCP) from Text to SQL Server.
• Error handling using Try-Catch Block.
• Normalization and De-Normalization of tables.
• Developed Backup and Restore scripts for SQL Server 2005.
• Installed and Configured SQL Server 2005 with latest service packs.
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Written T-SQL queries for the retrieval of the data.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration

Environment:: SQL Server, T-SQL, Enterprise manager, VBS, MS Office & Windows 2K platform, DAX, SSAS, Power Pivot, Tableau, Web Services, Crystal Reports, Micro strategy.