 Involved in analyzing business requirements and understanding the functional work flow of information from source systems to destination systems. Designed automated scripts in T-SQL and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.  Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.  Experience in building BI applications in Cloud Environments Microsoft Azure. Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.  Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.  Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.  Developing a scalable architecture for staging and loading data using SQL Server database.

 Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.  Involved in creating multiple parameterized stored procedures which were used by the reports to get the data. Created SQL scripts for tuning and scheduling. Performed data conversion from flat file into normalized data structure Written with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2012/2014 Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation. Created Subscriptions for the users to deliver the reports in a timely manner. Experienced in developing stored procedure driven reports, building custom application on reports, formula Writing/editing in reports, Report Administration and performance tuning of reports.  Created and modified SQL*Plus, PL/SQL and SQL*Loader scripts for data conversions. Wrote SQL, PL/SQL, SQL*Plus programs required to retrieve data using cursors and exception handling and Designed Data Modeling, Design Specifications and to analyze Dependencies. Develop complex MDX (Multidimensional Expressions), Stored procedures, Function table and views to generate various Drill-through, Drill-down reports, with Dynamic grouping capability, Parameterized dynamic Dashboard/Scorecard and link and pass the selected parameter values it to its sub-reports using SSRS. Performed Negative testing and Out- of- box scenario testing based on BRD (Business requirement document) and FRD (functional requirement document). Installation, Upgrade and Migration of SQL Server 2014, 2012 2008 R2 and 2008  Worked on XML along with PL/SQL to develop and modify web forms.

 Created and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and technical specifications.  Developed Logical and physical data model using ERWIN and mapped the data into database objects. Wrote different T-SQL scripts for automated execution of the tasks. Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task. Extensively used SSIS to move data from heterogeneous data sources Oracle and SQL Server 2008 to SQL Server 2012.  Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit and Data Conversion etc. Worked with different Control Flow elements like For Loop Container, For each Loop Container etc. Scheduled the SSIS packages to run at different intervals to load the data into SQL Server. Involved in Maintenance and Deployment of SSIS Packages. Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS). Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS. Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and P

 Worked with business stakeholders, application developers, and productions teams and across functional units to identify business needs and discuss solution options Gathered requirements from business users Actively participated in interaction with users and technical managers to understand the requirements of the system Monitored the data ware house structure and developed it using the Erwin tool Generated server side PL/SQL scripts for data manipulation and validation and created various snapshots and Materialized views for remote instances. Providing solutions to improve the existing processes and production support for various batch processes and also Created the schedule for newly incorporated batch programs and processes. Wrote DDL, DML scripts for Schema, Table space and Cluster creation and alteration. Generated Daily, Weekly, and Monthly Reports as per the customer requirements using subscriptions and Created Tabular Reports, Cross Tab Reports, Sub Reports.  Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using For Each Loop Container, Execute Package task, Execute SQL Task, Sent Mail task, Lookup, Fuzzy Lookup, Derived Columns, Condition Split, CDC Control Task, CDC Splitter, CDC Source and Slowly Changing Dimension. Implemented Event Handlers and Error Handling in SSIS packages Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job.

 Developed stored procedures, functions and database triggers. Maintained referential integrity and implemented complex business logic. Involved in installation and configuration of SQL server 2008 with latest service packs. Worked with SQL profiler for troubleshooting, monitoring and optimization of SQL Server and Non- Production database code as well as T-SQL code from developers and QA.  Collaborated and coordinated with business analysts to gather requirements for implementing data mart. Created required SQL procedures, functions, triggers, and views to supports OLTP and ETL application.  Created/Updated database objects like tables, views, stored procedures, function, packages