• Analyze the Business Requirement Document (BRD) to design a conceptual model to be implemented with T-SQL, SSIS, SSAS and SSRS to develop a solution.• Created Stored Procedures for complex business process, SQL Agent jobs, and designed tables by following RDBMS rules.• Administered SQL Server 2008 Management Studio tools including SQL Profiler and Database Engine Tuning Advisor.• Developed and worked with design, development, implementation and support of ETL process using SSIS Packages in SQL Server 2008.• Created Incremental Data Load from various sources into SQL Server Database Engine with ETL Operations.• Created C# applications to load data from Azure storage blob to Azure SQL, to load from web API to Azure SQL and scheduled web jobs for daily loads.• Created required documentation for the changes done to the various packages and shell scripts.• Created rich dashboards utilizing power BI to identify trend and pattern from OLAP data• Worked with a combination of multiple Control Flow Tasks, Data Flow Tasks and Dataflow Transformations to build packages in SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.• Implemented major Event Handlers like On Error, On Progress and On Task Failed for SSIS Packages.• Worked with Master SSIS packages to execute a set of packages that load data from various sources onto the Data Warehouse on a timely basis.• Created required shell scripts jobs in UNIX and did end to end testing for new packages and verified the output against test cases.

• Extensively used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.• Designed complex T-SQL queries, user defined functions; stored procedures and triggers followed by thorough analysis and testing of those database objects before deployment to the production server.• Created new SSIS package to extract date from legacy to SQL Server Objects using Business Intelligence Development Studio (BIDS) and Visual studio 2008.• Created UNIX shell script to load data to tables.• Responsible for creating and changing the visualizations in Power BI reports and Dashboards per the client Requirements.• Developed the UNIX shell scripts jobs responsible for loading the data to the data warehouse tables.• Created Azure SQL DB, Azure SQL Data warehouse, Azure Analysis Services, Azure Data Factory.• 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 Environment and extracted the data using SSIS from OLTP to OLAP.• Employed many Slowly Changing Dimension methodologies to maintain and update historical data.• Implemented data warehouse design principles and best practices for maintaining dimension and fact tables.• Executing data validation stored procedures in SSIS packages in Business Intelligence Development Studio (BIDS) and performance tuning of Stored Procedures and T-SQL Queries.

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS).• Excellent report creation skills using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.• Created SQL Server Reports based on the requirements using SSRS 2008.• Worked on OLAP Data warehouse, Model, Design, and Implementation.• Used 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• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.• Created complex reports which involve more number of groupings and multi-value parameters.• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.• Giving inputs to the team.

• Interacted with the users for understanding and gathering business requirements.• Involved in the analysis, design, development, testing, deployment and user training of Analytical and transactional reporting system• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that they perform well.• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.• Managed all indexing, debugging, optimization and performance tuning using SQL Profile and SQL Server Agent.• Designed, developed, and tested stored procedures, views and complex queries for Reports distribution.• Developed database triggers and stored procedures using T-SQL cursors and tables.• Effectively used views to prevent unauthorized access.

• Created and reviewed mapping documents based on data requirements• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.• Written complex SQL queries for querying data against different data bases for data verification process.• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.• Created, maintained and analyzed wide variety of reports / Excel spreadsheets for senior management. Oversaw departmental software drive / files.• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.• Worked with SSIS system variable, passing control and audit variables between packages.• Worked on Microsoft Visual Studio 2008/2012 project environment to create dynamic metadata driven SSIS packages for source data extracts and destination system updates.• Scheduled a job in SQL Server Agent that runs on daily basis and creates a log file and maintained the Errors in Error log file.

• Convert Access databases to SQL design tables, import data and developing constraints and indexes ensuring data integrity.• Identified and analyze stakeholders and subject areas.• Participated in Business Analysis, talking to business Users and determining the entities and attributes for Data Model.• Identified and determined physical attributes and their relationships through cross-analysis of functional areas.• Identified and analyzed source data coming from Oracle, SQL server and flat files.• Extensively used ERWIN to design and restructure Logical and Physical Data Models.• Evaluated and enhanced current data model as per the requirements• Performed forward and reverse engineering, applying DDLs to database in restructuring the existing data Model using ERWIN• Performed Data profiling, Validation and Integration.• Created materialized views to improve performance and tuned the database design.• Involved in Data migration and Data distribution testing.