add photo
Keerthi
nagakeerthi238@gmail.com
765-714-1908
Lafayette, IN 47996
SQL Server/Power BI Developer
8 years experience W2
0
Recommendations
Average rating
89
Profile views
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 2016/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 Server2016/ 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014/2016.
  • 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.
  • 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. Technical Skill:

Experience
Education
Master's in Computer applications
JNTU Kakinada 2009
Skills
Data Warehousing
2022
3
SQL
2022
3
SQL Server
2022
3
SSIS
2022
3
Stored Procedure
2022
3
Triggers
2022
3
BI Developer
2022
2
Business Analysis
2022
2
Data Modeling
2022
2
Erwin Data Modler
2022
2
Microsoft Excel
2022
2
MS Power BI
2022
2
MS SharePoint
2022
2
PL/SQL
2022
2
SSAS
2022
2
T-SQL
2021
2
Visual Studio
2022
2
Windows
2022
2
C#
2022
1
Data Cleansing
2021
1
Data Conversion
2021
1
Data Migration
2022
1
Data Replication
2021
1
Database Backups
2021
1
DataPower
2022
1
ETL
2022
1
FTP
2022
1
HA
2021
1
Informatica
2022
1
Informatica Powercenter
2022
1
Linux
2022
1
Mirro
2021
1
OLTP
2021
1
Oracle
2022
1
Performance Tuning
2021
1
SSRS
2019
1
UNIX
2022
1
XML
2021
1
Data Integrity
0
1
Data Marts
0
1
Snowflake
0
1
SQL Developer
0
1
TOAD
0
1