Raviteja Popuri

About Raviteja Popuri

Enthusiastic to seek and learn new things. Energetic to accomplish the tasks in time. I am an Software Professional Currently working as Senior SQL Server BI/ETL Developer at NRUCFC.\"Individuals play the game, but teams beat the odds.\" This motto is what I believe in and which gives me the real edge.Having 14+ years of Professional IT experience as Microsoft SQL Server BI/ETL Developer/DBA in diverse Sectors like Federal Government/Insurance/Healthcare and Experience in Software Development Life Cycle (SDLC) phases like Requirement Gathering, Analysis, Design, Development, Integration and Testing, Implementation and Production support- A thorough knowledge of the Software Development Life Cycle (SDLC) and specialized in SCRUM/Agile and traditional waterfall methodologiesProgramming Languages- C, T-SQL, MDX,PL/SQL, Power Shell, COBOLRDBMS- SQL Server 2014, 2012, 2008, MS-Access, DB2.Version Controlling Tools- Team Foundation Server(TFS), Serena PVCS Version Manager, Tortoise SVNSQL Server Tools- SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, Business Intelligence Development Studio, Data Transformation Services, Data Quality Services, SharePoint ServerData Modeling Tools- ERWIN 4.0,\\7.2,Visio 2003\\2010Reporting /Data Visualization Tools- SSRS, Power BI Operating System- Windows Windows Server 2003, Windows NT, Windows XP/Vista/7/10Methodologies- Logical and Physical Database Design, Star Schema, Snow Flake Model, UML, Database Design and NormalizationScheduling Tools- SQL Server Agent, Control-M,AutosysData Engineering Tools- Azure- Data Factories, DataBricks, Datalake, Synapse DWH, Snowflake, PySpark, Azure Storage Explorer

Experience

1. Lead Sql Server Bi Etl Developer Data Modeler at Nrucfc, Dulles Va

   Corporate Brokers

   Mar 2016 — Present · Dulles, VA, US

   Working as a SQL Server DWH/BI Developer in NRUCFC, Dulles VA, which is a non-profit finance cooperative created and owned by America’s electric cooperative network. With approximately $24 billion in assets, NRUCFC is committed to providing unparalleled industry expertise, flexibility and responsiveness to serve the needs of its member-owners. Working as a Microsoft BI tech lead for the team named LOP- Loan Origination Process where I created a new Staging layer called CFC_Staging and loads data into CFC_Staging from a newly created loan processing OLTP system called Cassiopeia. Data is being pulled into CFC_Staging from Cassiopeia using SSIS and this CFC_Staging is used to generate reports using SSRS. This data from CFC_Staging is also fed into the downstream applications like EIS, LAPRO, REPO using SSIS. Delivered financial reports for areas spanning through GL ledger accounting, financial facility, loans and other financial products. Environment: MS SQL Server-2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, DAX, MDX, Multi-Dimensional Model, Tabular Model, Power BI, Power Pivot, Visual Studio 2013,SharePoint 2013, TFS-Team Foundation Server Version Manager, ER-Studio, SQL Agent, Razor SQL, Office-2013, MS Excel, Cassiopeia Financials, ETL Framework with custom Logging.

Education

• Acharya Nagarjuna University

  Bachelor of Technology (B.Tech.), Chemical Engineering

  2004 — 2008

Skills

• Db2
• Ssas
• Etl Testing
• Jira
• Control M
• T-Sql
• Erwin
• Autosys
• Sql
• Data Modeling
• Databases
• Software Development Life Cycle (Sdlc)
• Team Foundation Server (Tfs)
• Extract, Transform, Load (Etl)
• Performance Tuning
• Transact-Sql (T-Sql)
• Pl/Sql
• Agile Methodologies
• Oracle
• Tabular Model
• Multidimensional Expressions (Mdx)
• Etl
• Microsoft Sql Server
• Tfs
• Ibm Db2
• Ssrs
• Unit Testing
• Power Bi
• Data Warehousing
• Xml
• Database Design
• Sql Server Integration Services (Ssis)
• Sql Server Reporting Services (Ssrs)
• Power Pivot
• Ssis