VEERAIAH UPPUTURI

Professional Summary

Over **+ years of experience specializing in Data Warehouse Technologies, SQL Administrator (Application Support/Production Support),BI Developer, Database Engineering, Data modeling, Production Support, Application Performance Tuning, Clustering (HA), DR strategies; providing administrative expertise in supporting Microsoft SQL Server databases (SQL Server 2005/SQL Server 2008 R2, SQL Server 2012/2014/2016).

Experience in ETL architecture, design and development using industry standard ETL tools such as Informatica/SSIS.

Performed a key role ensuring applications met and exceeded established goals and user requirements.

Created valuable solutions through DBA best practice methodologies, delivering uniform database standards, guidelines, procedures and processes.

Involved in Partitioning for increase in Performance and availability of data.

Over 9+ years of experience in design and development of web-based applications and software applications with database tuning and performance improvement.

Hands-on experience with Failover Clustering, Replication, Database Performance and Tuning, Conversions, Migrations and Upgrades, DB Disaster Recovery planning, SQL Server Integration Services, SQL Server and Sybase Replication, Analysis Services, SQL Profiler, Reporting Services, and Performance Monitoring.

Experience in ETL architecture, design and development using industry standard ETL tools.

Excellent 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.

Expert 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.

Knowledge of Fixed Income Markets and working experience with Market Data. Knowledge of Advent Geneva accounting system.

Experience in design, development and administration of Data Warehouse by using SSIS, SSRS and SSAS tools.

Expert in designing complex reports 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.

Knowledge of agile software development practices and release management.

Perform data migration from on premises environments into AWS.

knowledge of Amazon Kinesis, AWS Athena, AWS Lambda, Amazon Simple Queue Service (Amazon SQS), Amazon Simple Notification Service (Amazon SNS), and Amazon Simple Workflow Service (Amazon SWF).

Technical Skills

ERP : People Soft (9.0/8.8/7.5) EPM/Finance/HRMS.

Databases : MS SQL Server 2005/2008R2/2012/2014/2016, Oracle 8i/9i/11g, PostgreSQL

ETL/BI Tools : SSIS, SSRS, SSAS, Informatica, Crystal.

Programming Languages : Java, C, C++, J2EE, PL/SQL, HTML, PHP, JavaScript, CSS, Python 3.0

Platforms : Red Hat Linux, UNIX, Windows2000/XP, Windows NT 4.0, Windows 2003.

Web Servers : Apache 2.0, IIS 5.0 and 6.0.

Work Experience / Project Experience

Fidelity Investments, NJ Jan’ 10 to till date

Fortira, Inc.

Principal Software Engineer

Responsibilities:

Work with Business users to come up with High Level Design and Requirements for the application.

Involved in design and development of Kirby Home Dashboard for external Hedge fund clients where clients can see their Portfolio Balances, Accounting/Custody positions/transactions.

Designed and Developed Risk Analytics, Positions reports for external users/end users.

Involved in Analysis, Design and Development of Kirby Home Dashboard which shows client positions (Market Values and Cash), Cash Projections and Performance indicators.

Involved in Analysis, Design and development of Portal Admin Tool used to process subscriptions to send position/Tax lot/cash extracts external clients.

Designed and Developed ETL mappings and SSIS Packages to load data from multiple upstream systems like RWS, FBSI, PBW and Geneva.

Created complex stored procs for Trade Processing, Option Assignments and Accruals repots for external clients.

Designed and Developed Margin Attribution and Margin Attribution by Security reports for external clients.

Fine-tuned the complex queries and stored procedures so that reports and data processing will be done quickly.

Perform ETL operations including client feeds, Warehouse loads and data extraction.

Developed Positions, Transactions and Accruals client facing Reports as per business requirements.

T-SQL, triggers, stored procedure programming for new database logical data models, physical architectures, data analysis, ETL and data cleansing.

SQL Query Optimization and Tuning with extensive usage of index hints, force plans and batching.

Analyzing the input data from the source and loading the data to destination tables by creating the (ETL) SSIS packages for different business logics using Control flow, data flow, and transformation like lookup, join, Merger, conditional split and handling the rejection of rows.

Developed SQL Server 2008 Integration services packages as part of ETL activity for prime services teams in the Finance Group.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Development of scripts and Control-M jobs to support batch as well as real time execution.

Solely responsible for data migration from legacy system, historical data cleanup and rebuild.

Setup of new UAT environments and integration with other existing systems.

Performed unit testing, system testing and integration testing.

Developed Informatica mappings to extract data from Legacy systems into Prime One and DataMart.

Developed complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Sub Reports embedded into Main Reports.

Environment: Linux, Windows 2003 Server, J2EE, Perl, Control-M, Visual Studio 2008 R2/2016, MicroStrategy 9, MS SQL Server 2005/2008 R2, Sybase IQ 12.x, SSIS, SSAS, Git 2.21.

AMR Trading, NY Feb’ 09 to Dec’ 09

Business Intelligence Solutions, Inc.

BI Developer/ Administrator

Responsibilities:

Responsible for all ETL operations within the Engineering group including client feeds, warehouse loads, and data extraction.

Manage a team of database developers to support the Business Intelligence and data services needs of the enterprise.

Loaded the flat files data to database tables (SQL server 2008) by developing SSIS package and created the relationship between the fact and dimensions.

Provide Database Architecting/Modeling of the next gen version of the existing financial applications, work with the business analysts and the financial analysts.

Analyzing the input data from the source and loading the data to destination tables by creating the (ETL) SSIS packages for different business logics using Control flow, data flow, and transformation like lookup, join, Merger, conditional split and handling the rejection of rows.

Experience in working share point server to maintain the documents, updating the document library creating.

T-SQL, triggers, stored procedure programming for new database logical data models, physical architectures, data analysis, ETL and data cleansing.

SQL Server Reporting Services (SSRS) development/administration for Finance and Marketing groups.

Develop SQL Server 2005 Integration services packages as part of ETL activity for capital markets and budgeting teams in the Finance Group.

Provide Development/DBA Support for business-critical modules being a part of Database Group.

Provided complex stored procedures with critical business rules embedded.

Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution using SQL Server Query Analyzer, SQL Profiler and Performance metrics.

Responsible for production releases, implementation plans.

Provided code for User defined functions and dynamic queries for reporting in SSRS.

Designed and coded SSIS packages for various business units as part of the application.

Assist Development/QA group building/evaluating the environments.

Provided OLAP support involved in building cubes for the business units, coding stored procedures for transformations and data pump activities from operational source systems using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2005/2008, T-SQL, Excel, Windows 2003 Server, .NET 3.0, WPF 3.0, Business Intelligence Development Studio, Crystal reports XI.

Abercrombie& Fitch – Columbus, OH Jan’ 08 to Jan’ 09

Business Intelligence Solutions, Inc.

BI Developer/ Administrator

Responsibilities:

Provide Development/DBA Support for business-critical modules being a part of Database Group.

SQL Server 2005 database upgrades and migration of existing environments to SQL 2005.

Provide Database Architecting/Modeling of the next gen version of the existing financial applications, work with the business analysts and the financial analysts.

T-SQL, triggers, stored procedure programming for new database logical data models, physical architectures, data analysis, ETL and data cleansing.

SQL Server Reporting Services (SSRS) development/administration for Finance and Marketing groups.

Develop SQL Server 2005 Integration services packages as part of ETL activity for capital markets and budgeting teams in the Finance Group.

Analyzing the input data from the source and loading the data to destination tables by creating the (ETL) SSIS packages for different business logics using Control flow, data flow, and transformation like lookup, join, Merger, conditional split and handling the rejection of rows.

Provided complex stored procedures with critical business rules embedded.

Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution using SQL Server Query Analyzer, SQL Profiler and Performance metrics.

Provided SQL code for auditing and security features.

Responsible for production releases, implementation plans.

Revise existing Disaster recovery plans and implement new standards and procedures.

Provided code for User defined functions and dynamic queries for reporting in SSRS.

Analysis of new tools for performance and backups of SQL Server.

Designed and coded SSIS packages for various business units as part of the application.

Assist Development/QA group building/evaluating the environments.

Implemented SQL Safe suite for SQL compressed backups, SQL monitoring.

Implemented SQL Server 2000 and SQL 2005 Cluster SQL 2005 replication.

Provided OLAP support involved in building cubes for the business units, coding stored procedures for transformations and data pump activities from operational source systems using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2000, SQL Server 2005, T-SQL, Excel, Windows 2003 Server, Business Intelligence Development Studio, Crystal reports XI.

Nationwide Insurance Aug’ 06 – Dec’ 07

Business Intelligence Solutions India Ltd.

Informatica ETL Developer

Responsibilities:

Developed ETL Maps for to bring the data from Kalido Master Data Management System to the PeopleSoft applications Financials and EPM.

Developed ETL maps to load the data from Transactional systems such as Policy Maintenance system and other financial transactions to Tera Data Warehouse.

Created Repository using Repository Manager and created folders for each source system so that the related maps and objects together.

Used most of the Transformations such as Expressions, Aggregator, Normalizer, Filters, Update Strategy, and Splitters.

Developed complicated maps for bringing the data into the complicated tables from banking transaction systems.

Developed Maps to move the data in and out of Data Warehouse to all the applications in financial warehouse. Data has moved between PeopleSoft Financials, Data Warehouse, Hyperion Applications, and PeopleSoft EPM.

Developed Mission critical and complex ETL Maps derive the driver data from statistical accounts and transactions booked with multi-dimensional counts and weightings.

Developed maps to create financial metric as a financial data mart for the purpose of multi-dimensional reporting for management and legal reporting.

Created Sessions and Workflows to run the maps and workflows from the session manager. Also created scripts to integrate and schedule the jobs from Maestro Scheduling Tool.

Developed Parameter passing mechanism during run time about source and target variables also the other run time parameters of the session and workflow.

Created Repository backups and developed Migration strategy of maps, sessions between different instances of development life cycles.

Developed customizations to keep Nationwide Control Tables from Data Governance maintained in Kalido as a Master Data Management

Developed Tables, Pages and Components to maintain control data in ERP (Financials). This control tables reference tables for the chart fields in GL.

Developed Tables, Pages, Components and ETL maps to load and maintain the data in EPM Financial Warehouse.

Developed Application Engine programs to load the data into the GL Interface table to generate Journal Lines by Journal Generator. The data was coming from different business units in P&C business of Nationwide such as Nationwide Insurance, Independent Channel, Farmland, THI and Scottsdale.

Developed customizations required for NF Life and Annuity business unit integration with Enterprise GL.

Configured the Meta Data in EPM as required for the custom Tables created in order to use those tables in Allocation Manager and Data Mapper tools. Meta data objects such as (Record Meta Data, Table Map, Data Map, Filters, Constraints and Allocation Rules).

Developed custom File Layouts to load the data into the tables using application engine program including validation to the reference/prompt tables as a part of referential integrity.

Developed Component Interfaces to add new Meta data into EPM or Updating Meta Data from spread sheets or files in order to add or change the business rules in EPM.

Environment: Informatica Power Center, Designer, Repository Manager, Session Manager, PeopleSoft 8.x, EPM 8.x, Informatica, Oracle 9i, Application Engine, Component Interface, File Layout, PS Query, Workflow, SQR, Crystal Reports 8.5, Windows 2000 and UNIX.

Client: Largest European Retail and Investment Bank. Nov’ 05 – Jul’ 06

Business Intelligence Solutions India Ltd.

BI Developer PeopleSoft EPM Implementation-Offsite Team

Responsibilities:

Developed ETL Maps to bring the banking transactional data from different systems into the PeopleSoft EPM tables.

Created number of tables to store Facilities, Loans, Money Market Instruments, Futures, Physicals, Options, Bonds, Collaterals, Settlements, Equities, Securities, and Assets.

Involved extensively in EPM implementation to bring the Banking Transactional data from the systems ACBS, IBS, Devon, CAMRA, READQ, ARTS and SVP.

Created Sessions and Workflows to run the maps and workflows from the session manager. Also created scripts to integrate and schedule the jobs from PeopleSoft Process Scheduler.

Created Repository backups and developed Migration strategy of maps, sessions between different instances of development life cycles.

Developed complicated maps coming from ARTS sources system equity finance transactions, the file layouts are in XML format and Flat files.

Developed standard interface template to bring the data in different file layouts, formats with different delimiters, developed maps to provide this flexibility to handle all kinds of files.

Created Different types of data connections and to set the parameters at session/workflow level so that the map run time will pick up all the parameters and nothing to hard code in Maps and Sessions.

Created Tables, Pages and Components to develop BIS tools to develop a tool in order to calculate various feeds for Basel II implementation.

Developed various possessing maps using Application Engine and BIS tools to complete a code block mapping rules for creating instrument level ledger.

Developed reconciliation and drill back capability between instrument level codes block ledger with PeopleSoft Summary Ledger.

Configured PeopleSoft Meta Data for tree flattening and de-Normalizing and Data Mart Build process.

Environment: Informatica Power Center versions from 6.0 and 7.0, along with PeopleSoft 8.x EPM 8.x, Erwin 3.5, Sybase, Oracle 9i, Process Scheduler & Application Engine, Application Designer, Application Engine, Component Interface, File Layout, PS Query, Work Flow, SQR, Crystal Reports 8.5,Windows 2000,TOAD 7.3.

MebroSoft Solutions Pvt.Ltd (Hyderabad, India) Jan’ 05-Oct’ 05

Client: Visaka Industries

Software Developer

MebroSoft is a global management Consultancy, technology services and outsourcing company. Committed to delivering innovation, MebroSoft collaborates with its clients to help them become high-performance businesses and governments. With deep industry and business process expertise, broad global resources and a proven track record, MebroSoft can mobilize the right people, skills and technologies to help clients improve their performance. As a developer I was responsible for developing, testing and maintaining software programs and database.

Responsibilities:

Created database objects through development, testing, and production environments

Design and development of forms and reports.

Developed the Stored procedures, Triggers, Packages as per Requirement.

Unit test case preparation and testing.

Created new data models for specific purposes.

Involved in maintenance and support of business applications/clients.

Installed programming restricting user actions.

Communicated to full time computer operators with tape backups and problem resolution.

Participated in system construction, analysis, testing, and implementation.

Responsible for the testing and debugging of programs.

Environment: Developer 2000, Oracle 8i, SQL Loader, PL/SQL, UNIX, Windows NT.

Educational Qualifications

Bachelors in Computer Science and Information Technology, JNT University, India.

Certifications

Microsoft SQL Server 2005 – Implementation and Maintenance.

Contact this candidate