• To identify market trends and business opportunities designed and developed a Mock Amazon DB in SQL Server using SQL and Python Scikit with 30 million customer records.• Highlighted defects, changes, and issues in reports generated using Tableau and Microsoft’s SSRS for Sales Team, thus improving their strategies and operations.• Developed Distributed Database, to back-up all child databases to a single master database using linked server so the master’s database is up-to-date with all the changes made in the child databases.

• A Business Intelligence Developer and Data Analyst in Production, Development and Staging Environments for Data-ware housing projects, which uses data coming from source AS400 and middleware.• Solved Real Time issues with Index fragmentation, DBCC checks, Query Tuning, Error and Event Handling.• Experienced in programming tasks-Stored Procedures, Triggers, and Cursors using SQL Server 2012/2014 with T-SQL.• Working knowledge of .Net Framework 3.5 (VB.NET and C#.NET), IIS Web Server.• Responsible for creating a SSIS Packages for relational Database and SSAS Cubes for Dimensional data using SQL server Data Tools to fetch Data from sources which was AS400 DB2.• Developed, Monitored, Extract and Transformed data using DTS/SSIS, Import Export Wizard, and Bulk Insert for preparing data reports for client project name: Data-wise application.• Administrated SSIS packages by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages that help to get rid of overhead on Databases, which are used by client facing applications.• Created Data-wise reporting application, which includes following reports such as Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and other Sub Reports.• Sound Experience and understanding of SSAS, OLAP cube and Architecture.• Written expressions and fine-tune a report query so that precise data were fetch while getting a report from the applications.• Developed Data-feed using Double-take share tools, which reduce the application availability issue during the time of monthly patches on servers.• Well versed in Performance Point Server 2007. Designed Dashboards, Scorecards and reports using multiple KPI’s, OLAP charts and SSRS Reports.• Knowledge in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage.