PROFESSIONAL SUMMARY:

• 8+ years of industry experience in development and implementation of business requirements with Microsoft .Net technologies, Informatica, PowerBI, SQL Server 2016/2014/ 2012/2008/2005/2000, oracle 8, angular JS, tableau, pentaho ETL, netezza and oracle 9g, 10g, 11g with front - end tools like VB.NET, C#.NET. ASP. NET, VB Script, Python, HTML, CSS, AJAX, COM, DCOM
• Performed 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.
• Have deployed cubes and have intense experience in data warehousing, data marts etc.
• 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.
• Worked with lots of data by creating spreadsheets in MS EXCEL
• Have experience working in TFS
• 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 datatypes, 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.
• Developed, monitored and deployed SSIS packages.
• 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 environments
• Excellent experience in MS Dynamics AX, Micro strategy, Reporting implementation of Crystal Reports/ SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS)
• Having Good communication and Interpersonal skills, hardworking, dedication at work and result oriented as an individual and in a team.

TECHNICAL SKILLS:

Languages: C, C++, C#, T-SQL, PL/SQL (Oracle 10g)

Business Intelligence: PowerBI, Informatica, tableau, netezza, tibco spotfire, BIDS, SSIS, SSRS and SSAS.

Operating Systems: Windows Server 2003/2008/2008 R2 and Windows XP/Vista/7.

Framework: Microsoft .NET 3.5 and 4.0, Angular JS.

Databases: SQL SERVER 2005/2008 R2/2014/2016, MS-Access, MS EXCEL, Sharepoint.

Database Tools: SQL Server Management Studio, ETL Tools, Informatica, Cosmos and OLAP.

Applications & IDE: TFS, MS Visual Studio 2008/2010, POWER BI Development Studio, Visual Basic, Linux, MAC, UNIX and Windows.

PROFESSIONAL EXPERIENCE:

Confidential, McLean, Virginia

MSBI developer SSIS, SSRS & SSAS

RESPONSIBILITIES:

• Excellent knowledge & experienced in creating databases, tables, stored procedures, DDL/DML Triggers, Views, User defined datatypes, effective functions, cursors and indexes using T-SQL.
• Demonstrable knowledgeable experience with Informatica, Oracle SQL, PL/SQL development.
• Experience working in deployment of cubes, OLAP & XMLA.
• Developed tools using python, shell scripting, XML to automate tasks.
• Well experienced in data modeling & data migration from Oracle to SQL.
• Experience working in Power BI.
• Have experience in support and maintenance of Biztalk & AX Microsoft Dynamics with implementation and involved in working with self-direct assignments using tableau.
• Involved in projects with Power BI environment and tableau.
• Create Tables, Indexes, Views, Sequences, Constraints, Synonyms and Partitions (Range and List partitions).
• Worked on SSIS Packages Documentation, source, archive, Stage path mapping.
• 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:: Informatica, 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, Mango DB.

Confidential, McLean, Virginia

SQL/MSBI DEVELOPER

RESPONSIBILITIES:

• Work closely with the Banking projects & Business analysts for requirements gathering, designing the database and creating workflow for report in BizTalk server.
• Knowledgeable experience with PL/SQL.
• Have used python scripts for automation and production tasks.
• Worked with several servers involving DB2.
• Well experience in database performance tuning.
• Well experienced in migration of large data from Oracle to SQL, experienced in transformation and loading.
• Involved in query optimization and auditing.
• Have intense experience in personalization of screens in all type of grids.
• Well experienced in data migration in cosmos.
• Developing SQL code such as writing complex queries, stored procedures etc.
• Have worked in projects involving crystal reports, micro strategy AX which involves personalization of screens.
• 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:: Informatica Power Center, KPI, Cosmos, BizTalk, tableau, 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, MangoDb.

Confidential, Florida

Business Intelligence Developer SSIS, SSRS & SSAS

RESPONSIBILITIES:

• Involved in gathering user requirements and documenting the Technical specification analysis based on functional needs.
• Involved in query optimization and developing ER models as per the requirements.
• Handling large size databases which involves migration of data from Oracle to SQL.
• Designed and developed Proof of Concepts for various BI software evaluations.
• Conducted research and made recommendations on SSIS BI products, services and standards in support of procurement and development efforts.
• Dealt with the third party vendor (4Sight) for resolving issues, finding software related bugs and gave recommendations to resolve it.
• 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 Deployments.
• Worked with SSIS, ETL for transferring and reviewing data from heterogeneous sources like Flat file, Excel, CSV and DB2.
• Used project level parameters for connection strings and other variables in order to map the Environments accordingly for Dev/QA/Prod.
• 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.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• 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, Many-to-Many Relationship, and Dimension Granularity within a Measure Group.
• Designed and developed KPIs, Aggregations and Hierarchies.
• Created complex SSAS/Mondrian cubes with multiple fact measure groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed & developed Dashboards, Score cards and (150+) reports for different departments.
• Designed Tabular reports, Cross Tab Reports, Matrix reports, List reports & parameterized reports and with different techniques like Drill down, Parameterized, Pie charts, Graphs, Linked Reports, Drill Through using Expressions, Global variables and Functions.
• Created MTD/QTD/YTD Reports for management.
• 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.

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, Data Tools (Business Intelligence Development Studio (BIDS)), T-SQL, MDX, MS Excel, Team Foundation Server (TFS), Pentaho Integrated Solutions, Pentaho Spoon for ETL, Mondrian Cubes Editor- Schema Work Bench, Pentaho Web Console.

Confidential, Florida

SQL Developer

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.
• 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.

Confidential

SQL Server Developer

RESPONSIBILITIES:

• Understanding the business requirements and designing applications to meet their needs.
• Written complex stored procedures which meet the requirements.
• Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
• Created and managed the management, marketing and sales reports by using SSRS 2005 and report manager.
• Deploying the generated reports on production server.
• Also, prepared documentation for the generated reports.

Environment:: SQL Server 2005, SSRS, SSIS, Visual Studio 2008, C#.Net

Confidential

SQL Developer /Programmer

RESPONSIBILITIES:

• Involved in writing complex T-SQL queries and Stored Procedures in SQL Server 2005 to meet the business requirements.
• Designed & developed user interfaces Web Forms using C# and ASP.NET.
• Involved in migration and transformation of data from one server to another server.
• Extensively used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.
• Developed Reports using SSRS.
• Used ADO.NET extensively for data retrieving, querying, storage and manipulation.
• Involved in Client Side validations using Validation Controls, JavaScript and VB Script.
• Created and managed the management, Purchase and Sales, Inventory reports by using SSRS 2005 and report manager.
• Deploying the generated reports on production server.

Environment:: SQL Server 2005, SSRS, ASP.NET 2.0, ADO.NET, C#.NET.