Home

sai kiran singh Takoor - SISS , Azure, SQL server Integration

[email protected]

Location: Manvel, Texas, USA

Relocation: remote

Visa: H1B

PROFESSIONAL SUMMARY: Over 12 years of extensive experience in Microsoft BI tools (SSIS, SSRS, SSAS & Power BI) and extensively worked on SQL Server 2005/2008/2008R2/2012/2014/2016 Versions. Experience on Migrating SQL database to Azure data Lake, Azure data lake Analytics, Azure SQL Database, Data Bricks and Azure SQL Data warehouse and Controlling and granting database access and Migrating On premise databases to Azure Data lake store using Azure Data factory. Experience in Developing Spark applications using Spark - SQL in Databricks for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. Good understanding of Spark Architecture including Spark Core, Spark SQL, Data Frames, Spark Streaming, Driver Node, Worker Node, Stages, Executors and Tasks. Involved in various phases of Software Development Life Cycle (SDLC) including Analysis, Design, Testing, Implementation and Maintenance. Expertise in EDI transactions used in healthcare industry and good knowledge of HIPAA. Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2005/2008/2012 for Batch Processing using DDL, DML, DCL commands for various business applications and Data Warehousing Systems (SSRS, SSIS, SSAS). Experience in database programming in writing T-SQL Stored Procedures, Triggers, Constraints (Primary Key, Foreign Key, and Unique) Indexes and Batch Scripts using various DDL and DML commands. Very strong in writing SQL Joins, Nested Queries, Unions, Multi-table joins and experience in creating scheduling Jobs, sending Alerts. Experienced in creating SSIS packages involving ETL process, extracting data from various sources (Flat files, Excel files, Oracle, SAP, SQL Server) and loading for data warehousing using SQL Server Integration Services. Experience in creating Jobs, and Sending Alerts using SQL Mail, backups, performance issues, connectivity to databases, upgrade strategies, capacity planning. Experience in Reverse Engineering of MS Access Reports by replacing them with SSRS Reports. Experience in developing management reports by using SSRS (SQL Serving Reporting Tools). Strong experience in creating Ad Hoc Reports, parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS. Experience in migrating DTS packages, reports, and analysis services projects from SQL Server 2005 to SQL Server 2008R2, 2012, 2014 and 2016. Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS. Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector. Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements. Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts. Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI. Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server. Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI. Experience in Healthcare industry including Enrollment, Benefits, Claims, CMS data, Medicare, Medicaid & Commercial health plans data of 90 insurance providers (i.e. Humana, Aetna, Wellcare etc.,). Medical Claims experience in Process Documentation, Analysis, and Implementation in 835/837/834 processes of Medical Claims Industry from the Provider/Payer side. Worked with Claims, Members, Providers and Authorizations for loading the data into SQL server using SSIS packages. Wide experience in creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS). Worked on Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services. Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)Experience in working with large databases in SQL, Oracle, and Teradata Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure. Worked on GIT, Team Foundation Server, Visual Studio online and the application lifecycle tools associated with it. Excellent communication and inter-personal skills with the ability to develop creative solutions for challenging client needs using agile and sprint methodologies etc. EDUCATION: Bachelor of Technology from Anna University, INDIA. TECHNICAL SKILLS: Databases Azure SQL Database, Azure SQL Data warehouse, Azure SQL Managed Instance, MS SQL Server 2005/2008r2/2012/2014/2016 Database Tools Enterprise Manager, Query Analyzer, SQL Server Management Studio (SSMS), SQL Profiler, Upgrade Wizard, Database Engine Tuning Advisor, MS Access, Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT), SQL Server Analysis Services (SSAS) Reporting Tools SQL Server Reporting Services(SSRS) 2016/2012/2008/2005, Tableau, Power BI, MS Access ETL Tools Azure Data Factory(ADF), Azure Database migration service(DMS), Azure Databricks, SQL Server Integration Services (SSIS), Data Transformation Service (DTS), BCP Scripting Windows PowerShell, Schell Scripting, Transact SQL Languages T-SQL, PL/SQL, C#, ASP.Net, Scala, Spark SQL, No SQL Web Technologies Web Services, XML, HTML Operating System Windows 98 /2003/NT/XP/7, MS-DOS Applications MS Visual Studio 2010/2012/2015, MS office2003/2007/2010, XML, Visual Studio IDE Data Modelling Erwin Tool, Lucid, MS Excel Storage Azure Storage, Azure Blob Storage, Azure Data lake Storage Gen 1 Azure Cloud Azure Data Lake, Data Factory, Azure Databricks, Azure SQL Managed Instance, Azure SQL Database, Azure SQL Data warehouse, Azure Analysis Services, Azure Blob Storage, Data Migration Service, Elastic pools PROFESSIONAL EXPERIENCE: Client: Purpose Built Brands, Chicago, IL July 2022 April 2023 Role: Sr BI Engineer Responsibilities: Gathered data from various external sources into a data warehousing system (Enterprise Cube) with the help of ETL process. Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and nonproduction database code as well as T-SQL code from developers and QA Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints. Designed and developed web pages using VBScript. Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data. Developed various dashboards to know the school climate, school safety, risk factors, and risk behaviors. Build GSHS Reports in Power BI from scratch. Developed various solution driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, Scatter Plots in Power BI. Created dashboard for school system financial information which includes revenue and expenditure by district. Developed custom Georgia district map visual , the SVG is written inline within a Bootstrap 2 container. Written some Java script plugin that makes the polygons work like hyperlinks. Used various sources to pull data into Power BI such as SQL Server, oracle. Involved in installation of Power BI Report Server . Developed reports to visually explore data and create an interactive report Excel and Power BI. Using a query editor in Power BI performed certain operations like fetching data from different file. Created groups, content packs. Created the KPI to show the difference between actual and forecast data. Working with import and direct query, creating custom table in the Power BI. Merge queries and append queries, remove columns and split columns, choosing required columns in the data. By using Power BI desktop connected to various data sources, working with different visualizations. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging Created several user roles and groups to the end - user and provided row level security to them. Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service. Worked on importing custom visualizations. Worked with table and matrix visuals, worked with different level of filters like report level, visual level filters, page level filters. Environment: MS SQL Server 2012/2014/2016, SSIS/SSRS/SSAS, Query Analyzer, T-SQL, Windows Server 20016, SharePoint server, SQL Profiler, DAX, MS Excel 2010, MS Word 2010, Power point 2010, PowerBI, TFS, XML, Waterfall, Power Pivot, VB.NET, Pivot Chart. Client: Kaiser Permanente January 2021 July 2022 Role: Azure BI Engineer Responsibilities: Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes. Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation, and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. Responsible for estimating the cluster size, monitoring, and troubleshooting of the Spark data bricks cluster. Import data from different data sources to create Power BI reports and Dashboards. Experience in developing Reports, Charts, Dashboards using Power BI Desktop and manage security based on requirements Transform, define, navigate the data from data source and performed merge and append queries using Power Query. Implemented complex query techniques of passing Multi-Valued parameters and cascading parameters in MDX. Performed different types of context like Row context, filter context and query context using Power BI Desktop Performed transformations like Pivoting, Unpivoting and Splitting of the columns using Power Query. Performed Query Folding using Power Query to filter data in the data source server. Created measures, calculated columns, relationships and performed time series analysis using DAX in Power BI Published reports and visualizations to Power BI Service and thereby created dashboards. Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc. Worked with both live and import data into Power BI for creating reports. Experienced in performance tuning of Spark Applications for setting right Batch Interval time, correct level of Parallelism and memory tuning. Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity. Hands-on experience on developing SQL Scripts for automation purpose. Created Build and Release for multiple projects (modules) in production environment using Visual Studio Team Services (VSTS). Environment: Azure SQL Database, Power BI, Azure Data Factory (ADF), Azure DataBricks. MS SQL Server 2016, SSIS/SSRS/SSAS, Query Analyzer, T-SQL, Client: Focus Solutions - Healthcare September 2020 December 2020 Role: Azure BI Engineer Responsibilities: Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes. Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. Responsible for estimating the cluster size, monitoring and troubleshooting of the Spark databricks cluster. Experienced in performance tuning of Spark Applications for setting right Batch Interval time, correct level of Parallelism and memory tuning. To meet specific business requirements wrote UDF s in Scala and Pyspark. Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity. Hands-on experience on developing SQL Scripts for automation purpose. Created Build and Release for multiple projects (modules) in production environment using Visual Studio Team Services (VSTS). Environment: Azure SQL Database, Power BI, Azure Data Factory (ADF), Azure DataBricks. MS SQL Server 2016, SSIS/SSRS/SSAS, Query Analyzer, T-SQL, Client: Signify Health, Dallas, TX October 2018 August 2022 Role: Sr BI Developer Responsibilities: Analyze, design and build Modern data solutions using Azure PaaS service to support visualization of data. Understand current Production state of application and determine the impact of new implementation on existing business processes. Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure. Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB). Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL. Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS. Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment. Migrate data from traditional database systems to Azure databases. Designs Logical and Physical Data Model for Staging, DWH and Data Mart layer. Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2). Extract Transform and Load data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks. Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards. Developed various Scala classes using IntelliJ, Scala and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns. To meet specific business requirements wrote UDF s in Scala and Spark SQL. Developed JSON Scripts for deploying the Pipeline in Azure Data Factory (ADF) that process the data using the Sql Activity. Implemented ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR. Worked on Power BI and prepared dashboards using Tableau to make it more attractive. Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel. Building KPI reports for the cubes and optimizing the reports. Experienced in Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services. Involved in Analyzing, designing, building , testing of OLAP cubes with SSAS 2016 and in adding calculations using DAX. Experience in using XMLA protocol for SQL Server Analysis Services 2016 for interaction between client application and instance of Analysis Services. Involved in partitioning of cubes to increase the performance of cubes (SSAS). Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using DAX and SQL. Created calculated measures using DAX implementing business requirement. Worked on Star and snow flake schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database. Designed aggregations and pre-calculations in SSAS. Highly responsible for development and management of SSAS, SSRS and SSIS projects. Environment: Azure SQL Database, Azure SQL Managed Instance, Power BI, Azure Data Factory(ADF), Azure DataBricks. MS SQL Server 2016, SSIS/SSRS/SSAS, Query Analyzer, T-SQL, Windows Server 20016, SharePoint server, SQL Profiler, DAX, Teradata, SQL Profiler, MS Excel 2010, MS Word 2010, Power point 2010. Client: IntrinsiQ Specialty Solutions, AmerisourceBergen, Frisco, TX May 2018 September 2018 Role: Sr Database Developer Responsibilities: Interact with Development Teams and Managers to analyze end-to-end business needs. Extracting data from live systems and transforming data for use in a Data Warehouse. Extract data from EMR system and loaded into ODS and Data warehouse. Implemented Incremental loads to transfer data from OLTP to data warehouses using Control flow and Data flow tasks. Enforced data consistency by Debugged SSIS Packages using Data Viewers, Breakpoints and check points. Designed ETL packages with Error Handling, Package Configuration and SSIS Logging. Deployed SSIS Packages and scheduled the jobs in various environments by configuring it. Created stored procedures and performed index analysis for slow performing reports to bring down the report rendering time. Generated new reports, maintained existing reports, optimize performance tuning for the existing reports which took longer time to generate. Used Team Foundation Server (TFS) for all code and deployment source, extensively worked with TFS to keep track of all changes made in the project. Wrote T-SQL queries in creating Stored Procedures, indexes, functions, tables, views and other SQL joins and statements according to requirement. Responsible for building reports in Power BI from the Scratch. Designed, Developed, Tested, Published and maintained PowerBI Functional reports, Dashboards based on user requirements. Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests. Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries. Published reports and dashboards designed in PowerBI utilizing PowerBI services and shared it across through Microsoft Office 365. Maintained existing PowerBI reports and dashboards and made changes onto the same as per new and changing business requirements. Environment: T-SQL, MS SQL Server 2016/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Team Foundation Server(TFS), SharePoint, MS Excel, Microsoft Windows Server 2012/2016, PowerBI, MySQL, MS Excel, T-SQL. Client: US Anesthesia Partners, Dallas, TX July 2017 April 2018 Role: Sr. SQL BI Developer/SSIS/SSRS/SSAS/Power BI Responsibilities: Work closely with business users to congregate and comprehend requirements. Analyzed data contained in the corporate database and identify data integrity issues with existing and proposed systems. Optimized the stored procedures which are using cursors and increased the performance. Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database. Designed and worked on Extraction, Transformation, and Loading (ETL) process by pulling up a large volume of data from various data sources using SSIS. Extensively used SSIS transformations such as Lookup, Derived Column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send mail task etc. Designed SSIS packages for tracking the Audit time in multiple databases in multiple servers and worked on data flow task, Script component, OLEDB command, derived column, data conversion. Identified the potential Issues that occur during the package execution by redirecting the rows from source component to Error Output. Designed SSAS Tabular model for summary reports. Effectively used various properties in SSIS package to improve the performance. Worked on event handlers to prevent the error in propagating to rest of package, worked on native and custom logging. Worked on Datamart Project for Reporting purposes and also worked on Data Gaps for which we need the elements which are not available in the existing data warehouse for creating new reports. Created different chart reports helped in analyzing perform counters using SSRS. Developed drill down, drill through, cascaded and parameterized reports using SSRS and developed Excel pivot chart reports and pivot tables. Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drill down, drill through, sub-reports, navigation reports (Hyperlink) etc. Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS. Created customized reports using various chart types like Text Tables, Bar, Pie, Tree Maps, Heat Maps, Line Charts, Pivot Tables, Combination Charts in Excel, and Tableau. Migrate existing data into the Power BI. Created reports in Power BI preview portal utilizing the SSAS Tabular. Published Power BI Desktop reports created in Report view to the Power BI service. Transformed and combined the data using Query Editor in the Power BI. Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc. Worked with both live and import data into Power BI for creating reports. Managed relationship between tables in Power BI using star schema. Used different type of slicers available in Power BI for creating reports. Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS). Worked on building PowerPivot DAX reports from SSAS Tabular Cubes. Coordinating post-implementation events such as testing. Provide software product design and developed a technical roadmap for the solution through the project lifecycle and beyond. Development experience with RDBMS such as SQL Server and DBMS such as Geneva. Environment: T-SQL, MS SQL Server 2016/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) 2014/2010, Tableau, Visual Studio 2012, 2015, Business Intelligence Development Studio (BIDS), Team Foundation Server(TFS), SharePoint, MS Excel, Microsoft Windows Server 2012/2016, MS Access. Client: Wyndham, Orlando, FL July 2016 June 2017 Role: Sr. SQL BI Developer Roles & Responsibilities: Interacted with customers to analyze business needs. Provide software product design and developed a technical roadmap for the solution through the project lifecycle and beyond. Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program. Involved in high-level architectural design discussions for designing the MDF (Metadata framework) tables which store the business and patient data. Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database and checked constraints to maintain data integrity. Used T-SQL queries to insert the complete file information and layout to MDF tables. Designed SSIS packages to transfer the data from flat files, Access database and Excel documents to the Staging Area in SQL Server 2012. Worked on for each loop containers, sequence containers and used various tasks like Execute SQL task which calls stored procedures and takes parameters, Script component task for reading the file and removing trailer records. Created source, stage and archive folders as per the requirements using expressions in file system task. Developed master package which calls the child packages and loads the files to stage and history tables in GDW. Implemented and enhanced existing reports like Group by, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters. Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues Matrix Reports and Charts. Identified and defined the Datasets for the report generation and wrote the queries for the drill down reports, sub-reports. Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model. Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models. Created different chart reports helped in analyzing perform counters using SSRS. Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server. Created various visualizations and reports using Power BI. Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports. Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval. Created report snapshots to improve the performance of SSRS. Designed cubes with star schema using SQL Server Analysis Services (SSAS). Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube. Coordinating post-implementation events such as testing. Environment: T-SQL, MS SQL Server 2014/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Visual Studio 2012,2013, Power BI, Business Intelligence Development Studio (BIDS), Team Foundation Server(TFS), SharePoint, Erwin, MS Excel, Microsoft Windows Server 2012. Client: Duquesne Light, Pittsburgh, PA Jan 2015 - June 2016 Role: Sr. SQL BI Developer Roles & Responsibilities: Worked in AGILE methodology in the development of Database Objects in SQL Server 2005/2008/ 2008 R2/2012. Developed SQL scripts to Insert, Update, Delete and Merge data in the database tables along with SQL joins. Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions. Dynamically supported business users for given requirements and developed the reports accordingly. Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements. Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries Created Cross-Tab, Drill-down, and Sub-Report using RDL. Promoted RDLs to Reporting Service Server. Designed SSIS packages to transfer the data from DB2, flat files and Excel documents to the Staging Area in SQL Server 2012. Used SQL Server Destination in Data flow to improve a superior performance change in Replications. Developed SSIS Packages using Look Up Values & implementing rules provided by Business in the mapping document. Used SSIS Variables for storing the values, which are used in various components of Data Flow Task. Created package configuration in XML and used them to deploy packages into SQL server. Monitoring SSIS packages, Stored Procedures running in Agent job and support the Production Team. Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs. Developed many asp.net web applications using SQL Server and C#, to provide solutions for companywide needs. Daily support of system wide replication tasks including monitoring, alerting, and problem resolution Published dashboards on an intranet site using SharePoint Server. Environment: T-SQL, MS SQL Server 2008R2/2008 and 2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), SQL Profiler, Team Foundation Server, MS Excel, Windows XP. Client: Centene Health Care St. Louis, MO July 2014 Dec 2014 Role: MSBI Developer Responsibilities: Closely worked with end-users to analyze, understand and gather report requirements. Worked effectively on SQL Profiler, Index Tuning Wizard, Estimated Query Plan to optimize the performance tuning of SQL Queries. Wrote and executed complex T-SQL queries using SQL Management Studio for backend data validation testing. Developed and created the new database objects like tables, views, index, stored procedures and functions, advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers. Migrated all DTS packages to SL Server Integration Services (SSIS) and modified the package according to the advanced features of SQL Server Integration Services. Extraction, Transformation and Loading (ETL) process by pulling a large volume of data from various data sources using SSIS. Used SSIS to implement the Slowly Changing Dimensions, to maintain Historical Data in Data Warehouse. Developed reports using SSRS, used table control, matrix control for cross tab reports. Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder. Developed several details and summary reports including line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS. Worked on ADO.Net to access data from the database. Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent. Handled issues like data correction and resolved error handling. Environment: Microsoft SQL Server 2008 R2 Enterprise Edition, SSIS, SSRS, C#, Share Point Windows Server, Windows 7/XP, Visual Studio 2010 & TFS. Client: State Bank of India Hyderabad, India Dec 2012 June 2013 Role: SQL / ETL Developer Responsibilities: Creation, manipulation and supporting the SQL Server databases. Generated and debugged complex stored procedures and functions for performance tuning and optimization. Involved in creating SQL reports, data extraction and data loading scripts for different databases and schemas. Created complex functions, stored procedures for complex sub-queries and views based on the business requirements. Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity. Build efficient SSIS packages for processing fact and dimension tables with complex transform. Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like Oracle. Design new SSIS packages as per needs and resolve the problems. Created SSIS package to get data from different sources, consolidate and merge into one single source. Worked closely with business users in defining and documenting reporting requirements to design, develop and maintain SQL Server 2008 reporting services (SSRS). Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval. Coordinated with source system owners, day-to-day ETL progress monitoring, Data warehouse target schema design (Star Schema) and maintenance. Environment: MS SQL Server 2005, SQL Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008, Windows 2007 Enterprise, MS Office2007. Client: Hindustan Unilever Limited Bangalore, India Oct 2011 Nov 2012 Role: Database Developer Roles & Responsibilities: Coded Stored Procedures, functions, and triggers at a high level. Fine Tuned the SQL queries using hints for maximum efficiency and performance. Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Created/reallocated database objects on appropriate Filegroups to ease maintenance and improve data access performance. Closely worked with the end users to analyze, understand and gather report requirements. Participated in User Acceptance Testing for different modules. Implementing user training and providing technical support. Prepared proper backup and recovery plans. Merging data into a single server for achieving better control, consistency & security of data. Worked on the Logical and Physical design of database for projects on basis of user requirements. Extraction, transformation, and loading (ETL) process by pulling a large volume of data from various data sources using SSIS. Extensively used SQL Server Reporting services and report builder model to generate custom reports. Wrote and executed complex T-SQL queries using SQL Management Studio for backend data validation testing. DBA activities like creating users, roles and granting and revoking privileges. Environment: MS SQL Server 2005, T-SQL, SQL Windows Server 2003, and MS Access and Excel, SSIS, SSRS. Keywords: csharp quality analyst business intelligence database active directory information technology microsoft procedural language Florida Illinois Missouri Pennsylvania Texas