Harika Vallala

Summary

• 4+ years of strong MS SQL Server BI Developer experience with expertise in MS SQL Server 2016/2014/2012/2008 suite of products like SSIS, SSRS and SSAS. • Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2014/2012/2008, Visual Studio 2013,2010 Microsoft Access 2007-97, SQL Databases. • Highly proficient in the use of T-SQL and ETL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins. • Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014. • Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies. • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical. • Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications. • Very good experience in Oracle tools like SQL*Plus, SQL*Loader, SQL Developer using TOAD in secure databases. • Very good knowledge of SQL, PL/SQL especially writing queries with Joins, Sub-Queries, Rollups, Cubes, Set Operators. • Extensive experience in using Oracle seeded packages like DBMS_OUTPUT, DBMS_SCHEDULER, UTL_FILE, DBMS_SQL and DBMS_STATS. • Expertise in handling errors using Exceptions with RAISE application clause. • Extracted data using SSIS from OLTP (Tabular) to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view. • Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, Packages, joins and indexes in database. • Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement. • Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS). • Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts. • Have basic knowledge on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and XML Source Qualifier. • Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure.

Connections