Anusha Dibbur Narasimhamurthy

469-***-****, ad3idd@r.postjobfree.com

SQL BI Developer / Data Analyst/ Business Analyst

8+ Years of IT Experience as SQL Developer and Business Intelligence Technologies with expertise in ETL process, SSIS, SSRS, and SSAS.

Experience as a data analyst in Supply Chain Management, Drug diversion, and Facets provider data

Source to target mapping using Excel and IBM Fast track tool. Analysis of the source data, analyzing the logic, coming up with the transformations, and passing it to the developers to use as a reference of the business logic and requirements

Experience in Data Modeling, data mapping in legacy systems and source-to-target mapping (Logical and Physical Design of Databases), Normalization, and building Referential Integrity Constraints.

Strong working experience in SQL Server and T-SQL in constructing triggers, tables (DDL), Joins, cursors, user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.

Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling, and other database-related activities.

Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert and Change Data Capture

Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations, and Parallel processing

Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.

Experience in deploying created reports in various sources like Web browser, XML and PDF.

Very well aware of the changes made to Configuration files and deployment models and other changes in SQL Server 2012. Used TFS for version control and project tracking.

Experience in deploying packages to Integration Services Catalog in SQL Server 2012

Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.

Work with DBAs on Production issues and provide resolution.

A thorough professional with a proactive attitude, out-of-the-box thinking, and generating new ideas.

A keen communicator with the ability to relate to people across all levels in the organization.

Participated and contributed to code reviews

Have worked in SDLC, rapid development/ agile model- with everyday scrums and 3 weekly sprint deliverables.

TECHNICAL SKILLS

BI Tools

SQL SERVER 2012/2014/ 2016/2019 SSIS, SSAS, SSRS,

Languages

C#, VB.NET, C, T-SQL, SQL, PL/SQL, Visual Basic 6.0, VBA, HTML, VB Script, .NET script

RDBMS

MS-Access, Oracle 8i/9i, MS SQL Server, MS-Access, MySQL

Operating Systems

Microsoft Windows Server 2019,2016, 2012

Application Package

MS Office Suite, Visio, IBM Stack

Analytical Tools

SAS, R, MS-Excel (VBA), SPSS, Spotfire, Tableau, IBM Info analyzer, IBM Fast track, IBM Data Stage, Rapid SQL, AQT, HP Quality Center, TFS, Crystal reports, GitHub

EDUCATION

Masters of Commerce, India, Tumkur

CAREER RECITAL

Data Analyst/ Business Analyst SEP 2022 to DEC 2022

MultiEdge Inc, Irving, TX

Ryder Inc.

Responsibilities:

Worked as a data analyst and SSIS Developer for Facets Provider data

Understanding the data model, data profiling, de-duplication of data, data mapping, Source Target mapping, look-ups, and transformations in Excel, working with the development team to meet business requirements and logic. Master Data Management and Data Governance and coordinating with the users to gather business requirements

Writing source queries to pull data from Oracle Facets source for SSIS package. Parallel processing in sequence containers, e-mail notifications, row count verification, creating package level variables, data conversion task, executing SQL task for stored procedures, DML Changes Updating parameters, indexing properties, evaluating expressions, creating variables to hold source queries, creating dynamic queries and aggregating tables, running packages in dev, QA and Prod, executing script task with stored procedures. Experience in configuring, deploying, and scheduling packages

Creating tilde delimited extract files for users. Used Ultra edit to test extract files.

Data validation, tracking, and documenting changes, using TFS Unit testing and user Acceptance testing to check extract files. Assisted in migration to SQL Server 2014.

Environment: SSIS, SQL Server 2012/2016/2019, Oracle, Agile, GitHub

SQL Developer/ Data Analyst/ Process Analyst SEP 2017 -JUN 2021

Fugo Creative Pvt Ltd, India, Tumkur

Responsibilities:

Formulated and documented ETL process design based on business requirements from customers and system specifications including source-to-target mapping and transformation.

Involved in business analysis, data profiling, data mapping, and technical design sessions with business and technical staff to develop dimensional models, requirements documents, MDM, update changes, and ETL specifications: Slowly changing dimensions, junk, and degenerate dimensions.

Processed bridge tables, aggregate tables, and surrogate keys and worked on full and incremental loads

Worked on Performance Tuning, and SSIS packages error handling.

Created database objects like Procedures, Functions, Triggers, Indexes, DML changes on tables

Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities, row count, sorting, notifications, security

Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages. Running packages in all environments

Worked with various SSIS control flow tasks and data transformation tasks like Data conversion, Derived Column, Look-up, Fuzzy Look-up, script task, Conditional Split, etc. as part of ETL. Worked with Change Data Capture Task

Worked extensively with SSIS to import, export, and transform the data from Oracle, XML, and text files

Debugged stored procedures to optimize Stored Procedures

Modified star schema and identified the requirement of snowflake schema in the design

Extensively used Merge command as an alternative to small SSIS packages in dimension and fact load

Deployed SSIS packages with minimal changes using XML configuration files. Used transformations like derived column, row count, send email task, script task with .NET and VB for notifications and security

Migrated packages from legacy systems (DTS-SSIS) and deployed the packages across Dev/UAT/Prod environments.

Created and scheduled packages using incremental load and SCD. Developed and Extended SSAS Cubes, Dimensions and data source views, Data Mining Models, and Deploying and Processing SSAS objects.

Identified the requirement of partitioning the cube for better query performance

Loaded fact and dimension tables as part of a modified data warehouse solution

Built an Analysis Services database on an already existing data warehouse solution

Created measures, measure groups, dimensions, and multi-dimensional cubes

Worked on backup of cubes, aggregations, and dimension-level security of cubes

Created SSRS Reports: involving a variety of features like Charts, Filters, Sub-Reports, drill-down, Drill-Through, Multi-valued parameters Tablix control. Created Dynamic CRM reports and was also involved in Dashboard reporting, SharePoint with Power View tool, TFS, etc.

Involved in Unit testing and user Acceptance testing to check whether the data is loading into the target, which was extracted from source systems

Environment: SQL Server 2012/2014/2016, SQL Server 2008R2, SSIS, SSRS, SSAS, .NET script, Agile, Crystal reports

Contact this candidate