Home

Ghanashyam Putta - Certified Sr. MSBI (SSIS, SSRS, SSAS) / Data Analyst / Power BI/ SQL BI / Tableau Developer

[email protected]

Location: Memphis, Tennessee, USA

Relocation: Yes

Visa: H1B

Ghanashyam Putta Certified Sr. MSBI (SSIS, SSRS, SSAS) / Data Analyst / Power BI/ SQL BI / Tableau Developer +1 (703)-689-9945 * 142 [email protected] Memphis, TN Yes H1B SUMMARY Certified Sr. MSBI developer with 9+ years of IT experience in Database Development of SQL Server and Oracle and providing Business Intelligence solutions using Microsoft BI Stack (SSIS, SSRS, SSAS-Multidimensional Cube, Tabular Models, Power BI, Excel-Power Pivot, Power Query) of SQL Server. Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2008/2012/2014/2016/2017/2019. Extensive experience in working with Tableau, OBIEE, Siebel Analytics, SAP Hana, EBS Oracle R12 and Informatica. Extensive experience in implementing Microsoft BI/Azure BI solutions like Azure Data Factory, Power BI, Azure Databricks, Azure Analysis Services, SQL Server Integration Services, SQL Server Reporting Services and Tableau. Experienced in Star Schema and Snowflake Data Modeling Techniques as well as following Bill Inmon and Ralph Kimball principles in Managing Data marts and EDW Environments. Excellent experience in writing T SQL Queries using various objects like views, tables, Joins, Sub Queries, triggers, CTE's, stored procedures, and other advanced SQL concepts. Expertise in Developing and Tuning T- SQL, Oracle PL/ SQL Complex Queries, Stored Procedures, Packages, User Defined Functions, Triggers, Cursors, Views, Indexed Views , Materialized views and error handling techniques. Extensively worked on SSIS to automate ETL Loads / Processes by using Control Flow items (for Loop, execute package, script task, send mail task, etc.,) and SSIS Data Flow items. Experience in creating configuration files to deploy the SSIS packages across all environments. Skilled in SSIS error and event handling: precedence Constraints, Break Points, check points and applying different logging mechanisms. Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports Using Microsoft SSRS and experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems. Worked on SSAS ( SQL Server Analysis Services) to build analytical cubes on Multi-Dimensional and Tabular Models and exposed data for Ad-Hoc Reporting for the end User. Well versed in using multi-dimensional expression (MDX) queries, Mathematical formulas, and User-Defined Functions (UDF) for developing reports from Multi-Dimensional OLAP Cubes. Developed Python script to for processing large data sets and also to extract data from different files. Worked On R Data Wrangling Techniques using R functions and R libraries like Data.table, Tidyverse, dplyr, purr, readxl, broom, lubridate etc. libraries and developed RMarkdown Reports also leveraged them into flexdashboards for more interactivity of statistical Analysis and had scheduled the PDF RMarkdown Reports using RConnect in weekly and Monthly Basis for end users to consume those Reports. Strong experience in creating DAX queries to build formulas and expressions in Microsoft SQL Server Analysis Services, Power Pivot in Excel, and Power BI Desktop. Have an in-depth knowledge of agile, Kanban working environment and have good understanding of Software Development Life Cycle (SDLC) methodologies and principles. Technical Skills: Languages: Java, VB.net, C#, SQL, PL/ SQL, XML, HTML, Python Database & Business Intelligence Tools: MS SQL Server (2008 R2/2012, 2016, 2017/2019), MS-Access, Oracle 9i,10g,11g,12c,18c, SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Reporting Services (SSRS), DB2, Teradata, BI Stack (Power pivot, Power query, Power map), Power BI desktop/cloud, Tableau, OBIEE, Cognos, Business Objects, Azure Data Factory (ADF), Azure Databricks, U-SQL, Azure Analysis Services(SSAS), Databricks Delta(Delta Lake),Azure Data Lake Analytics, Azure Data Lake Store (ADLS), Microsoft Flow,Scala, MDX, DAX, XMLA, Power Query (M Language). ETL Tools: DTS, SSIS (SQL Server Integration Services), Informatica, COMOS. Reporting Packages: SQL Server Reporting Services, MS Office. Quest Internet Tools: IIS, FTP, TCP/IP, SFTP, WinSCP Data Modeling Tools: Ms Visio, Erwin, Toad Data Modeler and SQL Developer Data Modeler. Methodologies: Agile, Scrum, Jira, RUP and Waterfall Education: Masters in Information Technology Management. Cambell sVille university Kentucky Bachelor of Technology JNTU Professional Experience: Data Analyst/BI Developer Client: Stratas Foods, Memphis Dec 2022 to Till Date Responsibilities: Convert 100+ reports that are delivered from IBM through batch jobs or posted in a DocDirect portal (Excel). These reports are transactional data in various parts of the business. The team is working on a project that does the Extract, Transform and Load for these reports into their SQL Server. Experience in using SSIS tools like import and export Wizard, Package Installation, and SSIS Package Designer. Experience in Importing/Exporting data between different sources like Oracle/Access/Excel etc, using SSIS/DTS utility. Review and validate statistics and reports with business units. Help to derive insights and recommendations that will increase the quality of user s experiences. Writing SQL scripts to consolidate data into reports and Knowledge, manage communication and stakeholder expectations. Using Powerbi to create complex reports, dashboards, workbooks, datasets, getting data from various data sources, including those that require writing query using the blank query function. Writing Power Query M formulae language, using measures to create reports, and publish the excel documents in a manner that allow continued manipulation of the data. Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard. Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. BI Gateway for SSAS Live connection and Direct Query. Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models. Developed and published reports and dashboards using Power BI and written effective DAX formulas and expressions. Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports and Dashboards. Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders. Implementing SSRS solutions, used dashboards and gauges to enhance for the business users. Environment: MS SQL Server 2016, SSIS, SSRS, MS-Office, Visual Studio 2015, TSQL, Microsoft Teams, Power BI Desktop and Report Server on Azure Cloud, C#.net, MS Visio, MS Outlook, PowerShell, SQl DB, ORACLE DB. Data Analyst/BI Developer Client: ELAVON, Atlanta Feb 2022 to Nov 2022 Responsibilities: Understand the business functions, identify the KPIs and goals based on business needs that need to be tracked and reported. Transform the business requirements into technical requirements and design documents. Extract and analyze data generated by user activity on web applications. Report findings with data visualizations that are easy to understand. Suggest technical configurations on the web analytics tool for aptly tracking features on applications. Explore and make recommendations for tools and strategies that improve increase the efficiency and capabilities of our analytics processes. Experience in using SSIS tools like import and export Wizard, Package Installation, and SSIS Package Designer. Experience in Importing/Exporting data between different sources like Oracle/Access/Excel etc, using SSIS/DTS utility. Review and validate statistics and reports with business units. Help to derive insights and recommendations that will increase the quality of user s experiences. Coordinate with product software engineers on the application updates and evaluate how to integrate that with the web analytics tool. Invovled in the logical and physical data models of databases and prepared test cases for existing solution and new solution to validate the solution met requirements. Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL profiler, Index tuning Wizard and SQL Query Analyzer in MS SQL Server 2019. Writing SQL scripts to consolidate data into reports and Knowledge, manage communication and stakeholder expectations. Daily ADHOC reports as requested in the company portals which are raised by the business users. Gathering information from the business users regarding a new project regarding the development of new application. Created DAX queries to generate computed columns in PowerBI, also applied DAX calculated measures and columns. Develop forecasting report using R and python scrip in Power BI. Good Knowledge in insatalling and configured Enterprise gateway in PowerBI service. Prepared the complete Data Mapping for all the migrated jobs using SSIS. Expereinced on how to publish, schedule reports and Dashboards to meet business requirements. Worked on all kind of report such as Yearly, Quaterly, Monthly and Daily. Creating PowerBi Dashboard in accordance to the business user requirements. Understand the business functions, identify the KPI s and goal based on business needs that need to be tracked and reported. Transform the business requirements into technical requirements and design documents. Environment: MS SQL Server 2016, SSIS, SSRS, MS-Office, Visual Studio 2015, TSQL, Microsoft Teams, Power BI Desktop and Report Server on Azure Cloud, C#.net, Python, R, MS Visio, MS Outlook, PowerShell, SQl DB, ORACLE DB and PostGreSQL DB. SQL /Power BI Developer Client: State of Nevada, Carson City, Nevada November 2020 to Feb 2022 Responsibilities: The Nevada Division of public and Behavioral Health s Bureau of Health Care Quality and Compliance s Federal database for licensed facility inspections and regulatory compliance transition from ODBC and ANSI SQL connection, to one that uses API and JSON formatted PostGreSQL connection. Power BI Administration activities including Capacity Creation and Management, Deployment Pipeline creation, Data Connection creation and update, User and Group access provisioning. Daily extractionsm transforms and Loading (ETL) operations from the federal data source to the state facility licensed database and need to be retooled to function in the new system using the PowerBi Mscripting language and other Microsoft languages as needed. Expertise in full life cycle Business Intelligence implementations and have a understanding of all the aspects of an implementation project usng OBIEE 10.1.3.x/SIEBEL analytics 7.x. Expertise in design and development of three layers(Physical/Business Model and Mapping/ Presentation) of an OBIEE Metadata Repository using Oracle Bi administration Tool. Training the reporting making staff in the above procedures and usage of the PowerBi. Using Powerbi to create complex reports, dashboards, workbooks, datasets, getting data from various data sources, including those that require writing query using the blank query function. Writing Power Query M formulae language, using measures to create reports, and publish the excel documents in a manner that allow continued manipulation of the data. Proficient ininstallation, configuration and administration of the OBIEE platform. Pulling data automatically from one database into another database using the PowerBi based on established rules/criteria without having data dumped into a SFTP Server. Involved in designing new Modern Enterprise Data Warehouse Architecture using Azure platform and using Azure Analysis Services as Ad-hoc reporting Solution and Data visualizations through Power Bi on-Premises Report Server as well as Power Bi Cloud Services. Hands-On experience upgrading PowerBi Clusters and standalone Gateway Servers and PowerBi Report Server, PowerBi Premium, and PRO capacity experience. PowerBi gatewat Installation, Configuration, setup and design, seciruty, configuration updates. Experience with extensions, add-on, SQl Server, SAP BW/HANA connectivity. Created some complex DAX expressions in creating calculated columns and Measures for the Power BI Dashboards to transform the unstructured data in needed form for the business users to make use of them. Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL profiler. Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard. Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance. Environment: MS SQL Server 2016, SSIS, SSRS, MS-Office, Visual Studio 2015, TSQL, Microsoft Teams, Power BI Desktop and Report Server on Azure Cloud, C#.net, MS Visio, MS Outlook, PowerShell, SQl DB, ORACLE DB and PostGreSQL DB. SQL /Power BI Developer Client: Sears Holdings LLC, Chicago, IL September 2019 to October 2020 Responsibilities: Worked with the Project Manager and Business Analyst to understand the business requirement and involved in planning, defining and designing data based on business requirements. Worked with the data modeling product support team on tool features, functionality and maintainance. Designing and developing the SSIS batches for loading data from OLTP system, DSR (Staging Database) to Data Warehouse. Responsible for creating database objects using DDL commands like tables, Store Procedures, Triggers, Functions, CTE, Sub Query etc. using T-SQL to provide structure to store data and to maintain database efficiently. Create views to reduce complexity of the end user and create index to optimize performance of TSQL queries. Used PL/SQL Database trigger for making history of insertion, updating, deletion and all kind of Audit routines. Integrate various legacy data Sources like legacy unidata into SQL normalized form for clean instances of Data elements, Oracle database, third party data through web services into one centralized Data warehouse in Azure SQl Dataware house using ETL Techniques and designed SSIS Frame works along with data architect for continuous flow of data. Created PowerBI Dashboard sourcing the data from Azure Cosmos DB and to secure it with hierarchal Row Level Security for the end users to consume the interactive PowerBI Reports as well as dashboards. Have Successfully Migrated Existing Denizen canned Reports, to PowerBI Reports in On-Premises Report Services for business users to enhance the usability of reports. Defined report layout including report parameters and wrote queries fro drill down reports using SSRS. Create parameterized, Drill down and Drill through reports in MS SQL environment using SSRS. Designed SSIS Packages to transfer data from flat files to SQL Server Using Business Intelligent Development Studio. Extensively used SSIS transformations such as LookUp, Derived column, Data conversion, aggregate,Conditional split, Task, script task and Send email Task Etc. Create documents for all Store Procedures, SSIS packages and SSRS Reports have been developed. Used Executed Plan, SQL Profiler and Database Engine Tunning Advisor to optimize quieries and enhance the performance of databases. Responsible for analyzing requirements and developing the SSRS reports by using TeraData, SQL queries, views and macros. Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL profiler. Analyzing the key business needs and incorporating Predictive Analytics like K-Means Clustering algorithms in order to predict the financial sales for sales department. Worked on SSIS Packages in cleansing unstructured And Missing Data from Legacy Systems to new EDW Environment in Package Deployment Model. Performed the Slowly Changing Dimensions Using Hash byte Techniques for Better Performance of SSIS Packages and for parallel Loading of Data. Created PowerBI Dashboards Consuming Azure Cosmos DB and Converting the unstructured data into Consumable way to present it to the end users. Used M language in Power Query to transform the data as per business requirement. Utilized R and Python for developing visualizations in Power BI. Environment: MS SQL Server 2016, SSIS, SSRS, MS-Office, Visual Studio 2015, TSQL, Microsoft Teams, Power BI Desktop and Report Server on Azure Cloud, Salesforce, Power BI Desktop, M Language, Python, TFS, XML, VB.net, C#.net, MS Visio, MS Outlook, PowerShell and Agile. SQL/Power BI Developer Client: Huntington National Bank, Columbus, Ohio October 2018 to August 2019 Responsibilities: Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development and testing. Helped in the design of the Architecture of the Data Mart and in performance tuning of its database. Involved in designing new Modern Enterprise Data Warehouse Architecture using Azure platform and using Azure Analysis Services as Ad-hoc reporting Solution and Data visualizations through Power Bi on-Premises Report Server as well as Power Bi Cloud Services. Used PL/SQL Database trigger for making history of insertion, updating, deletion and all kind of Audit routines. Created PowerBI Dashboard sourcing the data from Azure Cosmos DB and to secure it with hierarchal Row Level Security for the end users to consume the interactive PowerBI Reports as well as dashboards. Have Successfully Migrated Existing Denizen canned Reports, to PowerBI Reports in On-Premises Report Services for business users to enhance the usability of reports. Analyzing the key business needs and incorporating Predictive Analytics like K-Means Clustering algorithms in order to predict the financial sales for sales department. Performance tuned the existing stored procedures in order to reduce the existing Query times. Worked on fixing Bugs in the existing SSIS Packages and made improvements to get down the run time of the SSIS Package. Created SSIS packages using SSIS Designer for export heterogeneous data from OLE DB Source( Oracle), Excel spreadsheet to SQL Server. Worked on SSIS packages, DTS import/Export for transferring data from Database (Oracle and Text format data) to SQL Server. Created adhoc reports to users in Tableau by connecting various data sources Generated tableau dashboards for sales with forecast and reference lines. User Java Script API to customize the views, selects, filters, date and time. Creating and maintaining PowerBI Reports and Dashboards and embedding them inside on premises Organizational apps for the larger audience to view them. Worked on SSIS Packages in cleansing unstructured And Missing Data from Legacy Systems to new EDW Environment in Package Deployment Model. Installation and upgrading Cognos 10 environment. -test reports in analysis studios for upgrading it to cognos 10.1 - Design, Develop, Build and Support metadata/ Models and cubes in powerplay and Microsoft SSAS - Attended training in Congos 10.1 and developed POC for Cognos 10.1 suite, involved in the installing and configuring the environment. Environment: MS SQL Server 2016, SSIS, SSRS, MS-Office, Visual Studio 2015, TSQL, Microsoft Teams, Tableau, Power BI Desktop and Report Server on Azure Cloud, TFS, XML, VB.net, C#.net, MS Visio, MS Outlook, PowerShell and Agile. MSBI/Power BI Developer Client: Asurion, Nashville, TN October 2017 to October 2018 Responsibilities: Involved in designing new architecture for the new SQL server Data base for Mobile Application to use for the end users based on legacy data bases from various sources such as oracle, MS access, Dazzler Db also CSV files. Integrate various legacy data Sources like MS Access, Spreadsheets, Oracle database, and third party data through web services into one centralized Data warehouse in Azure SQL Data warehouse using ETL Techniques and designed SSIS Frame works along with data architect for continuous flow of data. Have created new data mapping document for implementing a DataMart to get into the analysis server for reporting as well as Ad-hoc reporting purposes from Power BI. Had been a team member in creating data governance for PowerBI cloud solutions across the TVA enterprise wide collaboration with business users. Created Complex Parameterized Stored Procedures in order to transform data from different Legacy oracle databases and integrating the data for reporting Solutions. Using PL/SQL partitioned Tables using Range Partitioning, List Partitioning and are created local Indexes to increase the performance and to make the database objects more manageable. Have Worked on Statistical Analysis Reports which involves Performing Hypothesis testing of data samples in Microsoft SQl server-2016 with R (in-built)services and had created the reports Power BI Service with R visuals Created PowerBI Reports which involves Linear regression Models (Predictive models) for Data from Web API integrations. Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing). Created detailed periodic status reports for senior management to keep them on process of Implementation. Created Complex ETL Operations using script components and also using stored procedures in process of getting legacy data into new database by creating logic to validate the data before loading to the new tables and delete the duplicate data using SQL Server Integration Services tool (SSIS). Created/Modified Stored Procedures, functions, Triggers and Power shell commands as per the requirement. Developing the Data model in the form of star schema inside Tabular SQL Server Analysis Services for Ad-hoc reporting purpose for end users to have in and be able to create their own Self BI Reports. Create, maintain, and optimize stored procedures, database and ETL processes. Interact with report owners to establish/clarify their requirements and develop report specifications. Develops SQL Server Integration Services (SSIS) packages extracting data through ETL techniques using the SSIS tool and maintain auditing log information while the packages are scheduled to run every night. Resolve end user issues through collaboration with IT and Operations. Created some complex DAX expressions in creating calculated columns and Measures for the Power BI Dashboards to transform the unstructured data in needed form for the business users to make use of them. Environment: SQL Server 2016, MSBI Tools, T-SQL, .Net, Microsoft Visual Studio, Team Foundation Server, Power BI Report Server, Power BI Premium Workspaces, Server Management Studio, SQL Profiler, Tableau, SSDT, Microsoft Azure, Actuate Reports. SQLBI (SSIS/SSRS/SSAS)/Power BI Developer Client: Sun Trust Bank, Inc, Atlanta, GA July 2016 to September 2017 Responsibilities: Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views. Interacted with the business users for understanding the business requirements and the existing system. Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers. Created complex SQL stored procedures, Triggers, Functions, Views, Indexes in SQL Server 2014. Created the views in the intake-database for the MS Sales hierarchies to be use in the store procedures in staging database. Created Records, Tables, Objects, Collections (Nested tablesand Varrays) and Error handling with PL/SQL. Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases. Created many complexes Query's and used them in Power BI Reports directly to generate reports on the fly. Designed SQL SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all. Used One Drive for storing different versions of Power BI report. Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps. Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports and added the refresh time for each tile in the dashboard. Used JIRA for Version Control needs, task check-ins. Responsible for complete maintenance and delivery of scheduled releases. Environment: MS SQL Server 2014/2008 R2, SSIS 2008/2014, SSRS 2008, Visual Studio 2013/2008, Business object crystal report 2008, Tableau, Power BI Desktop and Report Server on Azure Cloud, TFS, MS Office 2010/2007, XML, VB.net, C#.net, MS Visio, MS Outlook, PowerShell, BizTalk Server 2010/2013, CA Agile Central. SQLBI (SSIS/SSRS/SSAS)/Power BI/Tableau Developer Client- The Home Depot, Atlanta, GA August 2014 to Nov 2015 Responsibilities: Involved in planning, defining and designing data based on business requirement and provided documentation for further reference. Involved in installation and configuration of MS SQL Server. Involved in designing database and perform forward engineering, from conceptual data model to Logical and physical data model using Erwin data modeler tool. Created new databases and objects such as tables, stored procedures, constraints, and indexes to maintain referential integrity of data. Developed PL/SQL Procedures and database triggers for the validation of input data and to implement business rules. Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS. Validated the ETL Scripts in the Target Database (MS SQL Server) for creating the cube before migrating it to Oracle. Used Team Foundation Server (TFS) to check in and check out the changes made to code. Involved Data modelling and Formalized Database design including creating Tables, Indexes, and Enforcing Data Integrity. Developed packages to handle data cleansing, loading multiple files and executing tasks multiple times (using For Each Loop). Modified the Existing SSIS Packages and added more audits and alerts in case of package failure. Analyzed the source data and handled efficiently by modifying the data types. Designed, developed and deployed SSRS reports that include; parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reports. Created and Deployed reports to Report Manager and Troubleshooting for any error occur in execution. Developed complex stored procedures using T- SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS). Used Power BI Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports. Created Linked Servers to connect OLE DB data sources and providers. Fine-tuned SQL queries for maximum efficiency and performance. Provided documentation for all kinds of reports and SSIS packages. Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance. Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2010, SSRS, Tableau, SharePoint, SQL Server Management Studio (SSMS), MS Excel, Windows XP/7. SQLBI (SSIS/SSRS/SSAS)/Tableau Developer Client: Deloitte, India January 2013 -August 2014 Responsibilities: Extensively worked on Data modeling, data analysis, reporting, and SQL development. Developed SQL queries with Multi-table joins, Group functions, Sub queries and T-SQL stored procedures, User defined functions (UDFs) for data analysis. Created and modified the indexes on the tables and views for the improvement in the performance of SQL Stored procedures. Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using PL/SQL in Development and Production environment for Oracle 10g and was involved with the Performance tuning, Optimization of queries and standardization of the code. Design and document the Error-handling strategy in the ETL load process using Event handlers. Consistently use this error handling techniques in all the mappings. Designed new dynamic SSIS Packages to transfer data between servers, load data into Database and tuned the existing packages. Developed modular ETL applications which enable the flow of data between data sources using SSIS. Environment: MS SQL Server 2012, 2008 R2/2008, SQL Server Integration Services (SSIS), Tableau, Business Intelligence Development Studio (BIDS), T-SQL, SQL Server Agent, Java, C#, DB2, Visual Studio 2008/2005, XML, XSLT, MS Office and Visual source safe, Requisite Pro, TFS, MS Excel, and MS Visio. SQL/ Tableau Developer Client: EY (Ernst & Young), India March 2012 to January 2013 Responsibilities: Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application Developed Physical data models and created DML scripts to create database schema and database objects. Created complex Views, Stored Procedures, Triggers, Functions, Indexes, Tables, SQL joins and other T- SQL code to implement business rules for Tableau reports and SSRS reports. Implemented different types of constraints on tables for consistency. Environment: MS SQL Server-2008/2010, Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, Tableau, VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#. NET, ProClarity Analysis, Microsoft Visual Studio 2010 Keywords: csharp business intelligence database active directory rlang information technology business works trade national microsoft procedural language California Georgia Illinois Tennessee