Maruthi S Nanduri

Herndon, VA 571-***-****

US Citizen

linkedin.com/in/maruthi-s-rao-nandury-5437941 ad0yjl@r.postjobfree.com Principal EDW Architect/ Development Lead

With a proven track record and 25+ years of experience in Enterprise Data Warehousing, Business Intelligence, and Full Stack Development. Seeking new opportunities to leverage my expertise in designing and implementing innovative data solutions. As a trusted advisor, I'm committed to delivering creative and visionary solutions to address complex business challenges. PROFESSIONAL SUMMARY

As an Enterprise Data Warehouse (EDW) architect, my role encompassed the design, development, and management of an organization’s EDW data architecture and infrastructure. Crafted Dimensional Models employing both Type I and Type II methodologies, establishing loading processes from diverse source such as RNT, Salesforce, SQL Replication, and SSIS Integrations. My work also involved applying various logics dependent on source applications and constructing intricate common dimensions that served multiple cross-functional applications.

Design and implement schema changes, manage indexes, and alter data objects to optimize performance.

Design efficient data models from a logical design based on business requirements and available use patterns.

Identify entity relationships, referential integrity constraints, and primary key structures. Perform analysis of tradeoffs between alternative schemas.

Design efficient data models from a logical design based on business requirements and available use patterns.

Advanced understanding of Data Migration/Data Warehousing/Data Mart delivery life cycle, from requirements definition to creating source to target mapping documents with transformation rules, Error handling design, data quality, design audit Balance control mechanisms to be able to automate jobs, notify proactively failures, write test cases and create templates to document all aspects of the projects throughout the lifecycle.

Troubleshoots production issues, identifying root cause and implementing sound technical resolutions in a timely manner.

Engaged in facilitating communication and collaboration between business and application development teams to pinpoint risks and issues, while also reassessing business requirements to ensure the smooth progress and timely delivery of projects.

Proficient in collaborating with business unit stakeholders to elicit and formulate comprehensive business requirements. Skilled in defining, constructing, and overseeing Minimum Viable Products (MVPs) while identifying forward-thinking solutions that proactively adapt to evolving business needs and objectives. Proficient in crafting testable system requirements, functional specifications, and test cases, and proficiently conveying these to technical teams, ensuring the resulting solution aligns with the MVPs.

Vast expertise in the entire lifecycle of Data Warehouse operations, including analysis, design, development, deployment, and ongoing maintenance. Proficient in constructing Data Marts with a foundation in diverse systems such as Salesforce CRM, Costpoint (Finance, AR, AP, HR, Revenue, Time and Expense), Softrax Billing System, BrassRing Recruiting System, Footprints Ticketing and Service Now Ticketing, RNT Customer Care, Deltek University Learning, LinkedIn Learning, Leadx, Govcon IQ, and more.

Proficient in applying a range of methodologies tailored to specific situations, including Agile, Iterative Model, Prototype, Spiral Model, and Waterfall, among others. Actively involved in all stages of the software development life cycle (SDLC), encompassing Analysis, Design, Documentation, Development, Integration, Testing, and Maintenance of software applications.

Possessing a wealth of expertise spanning every facet of ETL Development and Testing. Profound knowledge and comprehension of Enterprise-level architecture for both On-Premises and Azure cloud environments, which proves advantageous in constructing Data Warehouses. Demonstrated proficiency in designing and developing ETL processes utilizing Oracle PL/SQL, T-SQL, DTS, SSIS within SQL Server

(including 2022, 2016, and earlier versions).

Over the past 16+ years, I have fulfilled the responsibilities of a SQL Database Administrator. These tasks encompassed Version Updates and Migrations, Performance Enhancement, Code Optimization, Disaster Recovery, and Backup operations.

Data Integrations, Monitoring, Data Governance, Scalability, Metadata Management, and Data Compliance are all areas of expertise and Team Building TECHNICAL SKILLS

RDBMS SQL Server 2022/ 2016, Azure database, Oracle Business Intelligence Power BI, Cognos, QlikView, Qlik sense, Business Objects XI, Crystal Reports XI, Crystal Enterprise XI

ETL Tools Azure studio, MS Studio, PRTG, Dpa, SSIS, T-sql, SQL Power automates, dbamp, Preceda data-direct, Azure connectors, Odata, and Cast-iron.

Data Modeling Tools ER Win, Visio, and Online Tools. Methodologies Dimensional modeling (Star Schema, Snowflake Schema), ER Modeling,

Languages SQL Server, Azure, Oracle (Forms and Reports) Scripting Languages Power shells, Command line, UNIX shell scripts Operating System Unix and Windows.

EMPLOYMENT HISTORY

Deltek, Inc. Herndon VA Jun 2008 – Till Date

Technical Lead (Systems Engineer III)

Deltek, Inc. is the leading provider of enterprise applications software built specifically for project-focused businesses.

Role/Responsibilities:

Leading the Team Direct reporting team and Guide Distributed Reporting teams.

Involved in building EDW Architecture in Deltek (Enterprise Data Warehousing). Worked with Management and Development teams on designed various fact, Dimension and Bridge tables. We implemented the Star Scheme with various ETL strategies, EDW maintain the history data from various source systems.

Worked closely with end-users, Reporting team and management to design various reports. Documented the gathered specifications into requirements and developed reports to provide detailed, statistical information for the RNT, Sales Force, Softrax and Costpoint applications.

Working on reports based on Power BI, Cognos Cubes, Packages, tables, views and stored procedures.

Extensively worked on T-SQL, stored procedures, functions to extract and transform the data from source to staging and loading to the Target database. Built over Period based on time and resources. Full load, incremental loading, Time sensitivity based.

Used the SSIS, Tsql, Replications and some 3rd party tools (dbamp, data direct, API etc..), CastIron, AWS s3, ftp SharePoint for Data loads.

Security Methods: Used Staging servers, TDE, Masking data, File encryptions, FTP, Segmentation and Access levels, Row level security.

Involving in ETL development by using SSIS package to extract data from different data sources (Flat files, Oracle, and MS SQL Server) and AWS, Azure Loading the Transformed Data into Data warehouse destination Data base.

Integrating Enterprise Data warehouse with RNT, Sales Force, Softrax and Costpoint Applications. Environment: Cognos, Power BI, Qliksense, QlikView, SQL SERVER 2016/ 2023 (Tsql, SSIS) Deltek, Inc. Herndon VA Nov 2007 – Jun 2008

Business Intelligence Consultant

• Loading data from Various sources and ETL development in T-sql

• Involved in Maintenance of Cubes and Drill through reports. Involved in development of Cognos Report Studio reports.

• Extensively worked on T-SQL, PL/SQL packages, stored procedures, functions to extract and transform the data from source to staging and loading to the Target database.

• Used the SSIS, DTS tool for SQL Server for Data loads. Environment: Cognos 8.3 /7.4, SQL SERVER 2005/2000, Oracle 10i/9i Corporate Executive Board, Washington D.C Mar 2003 - Nov 2007 Business Intelligence Consultant

• EDW architecture in CEB, emphasizing the Star Schema model with Type 2 dimensions.

• Designing reports, administering user groups, and resolving complex issues related to ETL processes.

• Build cross applications i.e., EDW with Siebel CRM, Lawson HRMS, Great Plans Finance, and web applications.

Environment: BOXI R2, SQL SERVER 2005/2000, Siebel 7.5 Tools, Siebel CRM, Oracle 9i, Business Objects 5.1.6, Web Intelligence (2.7, 6.1a), Business View Manager, BCA, CMS, CCM, and CMC Consultant Jan 2000 - Mar 2003

• Client: Verizon, Maryland

o Business Objects Consultant

o Designing and implementing Universes and reports in Business Objects. o User Administration, Universe connections, domains and actively participated in performance tuning.

• Nextel Communications, Virginia

o Consulting Engineer, Data Warehouse Reporting

o Designing data marts, implementing a Star Schema, and developing PL/SQL stored procedures. o Creating Universes and reports for Nextel Data Warehouse and implementing security using BO Supervisor.

• Tourism Center, Iran (offshore)

o Project Lead

o Designing data marts, implementing a Star Schema, and developing PL/SQL stored procedures. o Created complex canned reports and facilitated production deployment.

• Quest Syscon International / Strabus Software Solutions 1997-2000 o Associate Project Manager

o Clients, including Hinduja Hospitals - India, Y.K. Almoayyed, and Gargash Group - Dubai, on Enterprise Resource Planning (ERP) projects.

o Technical lead, leading the requirement collection, analysis, design, customization, and coding of ERP modules.

o Expertise extensive PL/SQL backend programming, including packages, procedures, and triggers, and I played a crucial role in performance tuning and security management. Education: Bachelor of Science and Mathematics, Andhra University, India.

Contact this candidate