Sindhura.katta ac27cx@r.postjobfree.com 832-***-****

Professional Summary:

3+ years of wide-ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.

Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.

Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.

Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.

Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS)

Experience in integration of various data sources like SQL Server, Salesforce, Oracle, Access DB, DB2 and Flat File, Excel File.

Analyzing thousands of records using various excel functions like VLOOKUP and pivot tables.

Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.

Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements

Extensively worked on Control Flow Tasks such as For each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.

Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS)

Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.

Experience in debugging the SSIS packages using breakpoints and checkpoints.

Knowledge on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.

Used SQL Profiler, Execution Plans, DMV’s, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.

Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.

Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.

Experience in creating different visualizations and reports using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables in Tableau, SSRS, Power BI.

Experience in Building Reports/charts using Excel Power Pivot, Power View, Power Query, Power Map tools.

Knowledge on Tabular cubes using Power BI and implementing DAX expressions with in Power Pivot.

Worked on Power BI Desktop tools to build and customize, visualization on new or existing reports.

Experience in creating power pivot data models and integrate them with SharePoint and schedule them to refresh.

Used Tableau’s flexibility to build a tabbed application with wide range of options like quick filters, calculated fields, dynamic interaction and related action filters.

Experience in Tableau Desktop/ Tableau Server 9/8, creating highly interactive Data Visualization Dashboards using feature such as Data Blending, Extracts, Calculations, Filters, Actions, Parameters, Context Filters, Sets, Groups, Aggregate measures etc.

Mastered the ability to design and deploy rich Graphic visualizations with Drill Down menu option and Parameterized using Tableau.

Excellent skills in designing Logical and Physical Modeling using ERWIN Tool.

Experience in using Star Team and Team foundation server for source control.

Education:

Master of Science (software engineering ) University of Houston Clearlake

Bachelor of Science (computer science ) JNTU University

Technical Skills:

RDBMS/DBMS : MS-SQL Server 2014/2012/2008R2/2008/2005/2000/7.0,Oracle 8i/9i/10g, MS Access.

BI/Visualization : Tableau Desktop 7/8/9, Tableau Public 8/9, Tableau reader 8/9, Tableau Server 8/9, Power BI

Programming Languages : T-SQL, PL/SQL, XML, ASP .NET, Shell/Bash Scripting.

Database : SQL Server 2014/2012/2008R2/2008/2005/2000/7.0, Oracle 8i/9i/10g, OLTP, OLAP, MS SQL Server 2000 Enterprise, Manager, SQL Query Analyzer, Web Services, SQL Profiler, Bulk Copy Program (BCP).

BI Tools : SQL Server Business Intelligence Development Studio (BIDS) SSIS/SSRS/SSAS, SQL Server Management studio (SSMS), Visual Studio 2013/2012/2008/2005.

Version Control : GitHub, Team Foundation Server (TFS), Visual SourceSafe (VSS).

Web Servers : IIS 6.0, Apache, SharePoint & Performance Point Server.

Data modeling Tools : Erwin 7.2/4.5/4.0, MS Visio 2007/2010/2013, Rational Rose.

Design Methodology : Unified Modeling Language (UML) 1.1 using Rational Rose.

Operating Systems : Linux (Redhat-7/6/5), Windows10/8/7/Vista/NT/XP/2003/2000/98, Windows 2000 Advanced Server, Windows 2003 Enterprise Server.

Work Experience

MOODY’S Analytics -Omaha,NE (July 2017 –TillDate)

Research and Data Analyst / Data Scientist

Moody’s Analytics, helps financial professionals worldwide respond to an evolving marketplace with confidence. Provides economic research regarding risk, performance and financial modeling. The project involved in creating SSIS packages to transfer data from MYSQL to PostgreSQL

Responsibilities:

Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.

Designed and created SQL Databases, tables, indexes, and views based on user requirements.

Create joins and sub-queries for complex queries involving multiple tables

Created User Defined Functions, Stored Procedures, and Triggers.

Responsible for logical and physical data modeling, database design, data analysis, programming, documentation and implementation.

Collaborated in dramatically increasing OLTP transactions on systems handling several billion transactions weekly through the implementation of advanced database techniques such as join optimization, table structure and fragmentation analysis, bulk inserts, analysis of indexes and locks, creation of custom timers to detect bottlenecks.

Increase efficiency and reduce time and increase accuracy by using: Sorts, Filtering, and Pivot Tables, Subtotals, VLOOKUP formula functions and the impact of labor removed from the Process.

Involved in Data modeling, designing, and building relational databases. Designed logical and physical data models and created DDL scripts to create database schema and database objects.

Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MS Visio 2013.

Involved in integrating different Database Applications using SSIS packages.

Creating SSIS packages that involves migration from legacy systems to centralized Database.

Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, For each Loop Container.

Expert in using the work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications

Validate data before performing ETL transformations and load into SQL server database.

Intensively worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS 2012.

Designed and developed various analytical reports from multiple data sources by blending data from various sources on workbooks in Tableau Desktop and Power BI.

Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS2014/2012/2008,Microsoft Office, MSVISO 2013, Profiler, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server.

Think Passenger - LA California (January2016–july 2017)

BI Developer

Passenger communities enable the world's leading brands to connect, create, and communicate with key stakeholders online, on mobile and on social networks. The Project mainly involved Designing, creating, and maintaining database. It also includes developing and maintaining SSIS packages and creating reports using SSRS.

Responsibilities:

Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.

Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.

Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.

Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users

Worked on Data migration project by validating three source data row by row and field by filed

Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.

Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users

Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements.

Widely worked on Script Task and expressions such as to check file availability at the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS.

Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.

Created Rich dashboards using Tableau Desktop and prepared user stories to create compelling dashboards to deliver actionable insights.

Performed data refresh on Tableau Server on weekly, monthly and quarterly basis and ensured that the views and dashboards were accurately displaying the changes in data.

Designed and developed a business intelligence dashboards using Tableau Desktop, allowing executive management to view past, current and forecast sales data.

Created multiple Visualization reports/dashboards using Dual Axes charts, Histograms, Filled map, Bubble chart, Bar chart, Line chart, Tree map, Box and Whisker Plot, Stacked Bar etc.,

Experience with creation of users, groups, projects, workbooks and the appropriate permission sets for Tableau server logons and security checks.

Extensive experience in creating dashboards using calculations, parameters in Tableau.

Created advanced analytical dashboards using Reference Lines, Bands and Trend Lines.

Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.

Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, And Visual Studio.

Louis Berger, Hyderabad India Jan 2014- July 2014

Business Intelligent Analyst

Louis Berger (formerly known as Berger Group Holdings) is a full service engineering, architecture, planning, environmental, program and construction management and economic development firm based.

Our work includes writing store procedures, transforming data from different data sources to data ware house by design, develop and deploying different SSIS packages as well as creating reports according to the business requirement.

Responsibilities:

Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.

Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.

Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.

Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.

Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.

Calculated and analyzed basic statistics such as creating charts and pivot tables in Excel;

Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task.

Actively involved in deploying and scheduling packages.

Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.

Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.

Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.

Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.

Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.

Provided and defend conclusions and recommendations to customer based on results of analysis.

Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.

Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2012/200R2/2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.

Unilever Hyderabad India Jan 2013- December 2013

BI Data Analyst

Project description

Unilever is an Anglo-Dutch multinational consumer goods. Its products include food, beverages, cleaning agents and personal care products. This project involves Extracting data from different data sources, Analyzing and Loading the data into data warehouse. Developed and deployed new packages designing and developing various types of reports for the marketing group.

Roles & Responsibilities:

Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.

Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs as required.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

Experienced in slowly changing dimension, Data Mining, Pivot, Fuzzy lookup incremental data load packages in SSIS.

Developed, monitored and deployed SSIS packages.

Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

Responsible for fine tuning of the database, troubleshooting, memory management.

Created reports based on database usage and perform capacity planning.

Optimized stored procedures and indexed query using Index Tuning Wizard.

Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.

Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.

Environment:

SQL Server Profiler, SQL Server Management Studio, SQL Server Business Intelligence

Development Studio, SSIS, SSRS, TSQL, Visual Studio

Contact this candidate