Data Analyst Sql

Srihari Tallapaneni 615-***-**** / ***.***********@*****.***

Summary:

Over 12+ years of Worked on Business/Data analysis, ETL process, Reporting services, Database Design and Data modeling.

Worked on Database Design, implementation, management and data warehousing using Oracle 8i/9i/10g/11g, Sybase, MS SQL Server and ETL Tools.

Worked on working with distinct phases of Software Development Life Cycle (SDLC) in Waterfall and Agile methodology.

Worked on gathering user requirements and generate Business Requirement Document (BRD) and Functional Requirement Document (FRD), maintaining Data Dictionary and Meta Data.

Worked on data profiling and creating source to target mapping documents.

Worked on functional testing, integration testing, regression testing, black box testing, GUI testing, back-end testing and browser compatibility testing.

Created databases, users, tables, triggers, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.

Good at Designing complex Informatica mappings and re-usable transformations to facilitate incremental and initial data loads.

Skilled in working with software testing tools such as HP ALM for test cases, defect tracking and requirement mapping.

Skilled at writing User Stories and Functional Specifications Documents.

Worked on data profiling and creating source to target mapping documents.

Worked on creating validation strategy and validation plan documents.

Worked on Release/Change/Configuration Management process while working on planning and deploying changes in production environment after coordinating with developers in different region.

Worked on Oracle PL/SQL including writing queries, stored procedures, functions, packages and triggers.

Worked on Query Optimization, Debugging and Tuning for improving performance of applications.

Expertise in oracle data pump – expdp, impdp, export, import and SQL*Loader utilities.

Worked on using job scheduling tools – Control-M, Autosys and Tidal

Excellent knowledge and working Worked on with validation strategies, validation planning, validation scripts and validation results analysis.

Expertise in complete lifecycle Implementation of Business Intelligence with Star and Snow flake Schemas. Thorough knowledge of Data modeling concepts including Dimensional Modeling.

Worked on designing and development of Data Warehouse/Data Mart Analysis.

Worked on code migrations/deployment for testing/production environments.

Worked on preparing documentation at various stages of system life cycle, which involves functional specification, user Manual and technical review.

Proficient in using Linux, UNIX commands and Shell Scripting.

Worked on loading data using NZLOAD, NZSQL, NZadmin utilities.

Experienced in full Software Development Lifecycle (SDLC), project management methodologies – Waterfall/Agile/Scrum and ITIL processes.

Excellent Team Member and Team leader with excellent interpersonal skills and is highly dedicated and experienced.

Certifications:

Certified in National Stock Exchange in Financial Markets (NCFM)

Managerial Excellence Program (MEP) from Duke University, USA

Education: MS in Software Systems, BITS, Pilani, India

Technical Skills

Operating Systems: Linux, UNIX, windows 95/98/NT 4.0/XP

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, HTML, XML

RDBMS: Oracle10g/11g, SQL Server, Netezza, Sybase, DB2

Administration Utilities: Export, Import, Data Pump, SQL*Loader, NZload, NZsql

Tools: Informatica, TOAD, Optim, PowerShell, Control-M, Autosys, Quality Center, Crystal Reports, Hyperion Essbase, HDFS,Hive, Erwin, Visio, Ab initio, WinSQL, Forms, Reports, V.B6.0, CVS, Eclipse, Splunk, AppDynamics, Dynatrace

Web Related: VBscript, SOAP, IIS4.0, Web Logic, XSL, Java, WSDL

Domain Knowledge: Finance, Trading, Compliance, Risk, Telecom, Health Care Manufacturing, and Enterprise Performance Management.

Fannie Mae, VA Nov, 2017 – Till Date Sr.Data Analyst

FNM Multibond Bond Administration is Fannie Mae’s Multifamily Mortage Business security administration system. It manages bond issuance, payments and trasmit payment information. EDI,eServicing,SLA applications closely integrated with KPMG MBS system. KPMG MBS will send bond issuance for FNM MBS loans. EDI application maintains bond issuance,account,customent and security administration details.eServicing application maintains issuance statue,customer and account statuses information.

Responsibilities:

Working on data analysis on loans and bond issuance modules.

Created validation planning documents and validation scripts using SQL.

Developed queries for weekly/monthly reports and adhoc reports (SQL or PL/SQL scripts running in Unix System) to extract data from database.

Worked on Production issues: debugging and fixing errors, tuning SQL queries, checking indexes usage.

Worked on Database bookmarks and DB restore using Delphix application.

Worked with TIBCO administrators to setup HAWK monitoring rules for Inbound and Outbound endpoint URL’s EDI,eServicing and SLA applications.

Worked on PL/SQL performance tuning of stored procedures and tables for better performance on reporting and updates.

Environment: Oracle 11g (SQL, PL/SQL), TOAD, Delphix, Unix, JIRA, SOAP, WSDL, TIBCO, GEMS, XML,HDFS,Hive,Autosys, Visio, Erwin

Credit Suisse, NY Jun, 2013 –Oct, 2017

Sr.Data Analyst

Private Banking - Trade Applications

Charles River Investment Management Solution (Charles River IMS) automates front and middle office investment management functions for buy-side firms in the institutional asset and fund management, private wealth, alternative investments.

QTE is a Trade Booking Platform used by the Equities Trading Desk to assign executed trades to accounts and transmit them to Pershing. The remainder of the trades is manually booked in QTE by the trading desk. Once these trades are booked, they are sent to Pershing in Real-time.

Protegent Surveillance provides a platform which addresses compliance, surveillance and suitability needs of financial service organizations. Protegent Surveillance analyzes trade, account, position and client data, to support review of transactions, accounts and client holdings.

Restricted Stock system is used to submit requests of Sale, Loan, and 105B1 plans. When a client requests to sell securities, the relationship manager (RM) enters the request of sale in R-Stock, which gets sent to the Legal and Compliance Department.

Responsibilities:

Worked on data profiling using various relational and DW database systems.

Created validation planning documents and validation scripts using SQL.

Created detailed data mapping specification documents to create mappings.

Effectively interacted with Business Analysts and Data Modelers and defined Mapping documents and Design process for various Sources and Targets.

Gathered user requirements, analyzed and designed software solution based on the requirements.

Involved in creating database objects like tables, views, procedures, triggers, functions using T-SQL to provide definition, structure and to maintain data efficiently.

Worked on perform complex data analysis in trading applications mainly Charles River development, Trade book application, Restricted Stock and Protegent Surveillance applications.

Expertise in diagnose root cause, problem solving and identify solution alternatives for various kinds of business scenarios.

Supported different stored procedures in Sybase, Oracle and SQL Server for Data Warehouse Phase II project

Worked with different teams to coordinate disaster recovery/database backup and archiving of critical data.

Participated in PL/SQL, TSQL performance tuning of stored procedures and tables for better performance on reporting and updates

Worked closely with the UAT team for QC/JIRA resolution and bug fixes

Used Informatica Power Center Workflow Manager for session management, database connection management and scheduling of jobs to be run in the batch process

Worked on weekends for the ongoing release and prepared documentation for execution and rollback plans in production

Working with other DEV teams and infrastructure team providing oversight and input for engineering strategy. Worked closely with infrastructure team in monitoring critical alerts in production environment.

Worked on generating build scripts and generating the release notes during a production release.

Environment: Oracle 11g (SQL, PL/SQL), Informatica, Sybase, SQL Server, Control-M, Quality Center, SVN, TOAD, Linux,Perl, HDFS,Hive, Python,Netx360.

BNY Mellon, NJ Aug 2011 - May 2013

Developer/Sr.Data Analyst

Albridge Wealth Reporting: Albridge provides enterprise wealth management services that deliver an accurate, single view of all of their clients' assets. Albridge Wealth Reporting provides a variety of customizable client reports that cover performance, asset allocation, holdings, transactions, benchmarking, cost basis and more.

Responsibilities:

Worked on data profiling using various relational and DW database systems.

Created validation planning documents and validation scripts using SQL.

Created detailed data mapping specification documents to create mappings.

Developed different batch scripts for testing feed versioning and running the batch job in controlled fashion.

Version Control and Release Management for all codes deployed in production and QA environment

Took active part in Communication/Notifications of Active Production Issues

Coordinate with vendors to restore service and identify root cause during critical outages

Worked in creating different JIRA's and assigning it to required teams and coordinating the release procedure

Following change management and compliance process for production deployment

Responsible for migration of database objects and data into different environments.

Environment: SQL, PL/SQL, Informatica 9.0.1, Optim9.1, SVN, Autosys, TOAD, UNIX

Time Warner Cable, Charlotte, NC Jul 2010 - Aug 2011

Sr. Data Analyst

Billing System Events (BSE): Time Warner Cable uses different billing systems – ICOM, CSG depending on the region to bill for different services of TWC.

CVC (Customer Value Creation) and Hawaii Integration: TWC uses Oceanic billing system in Hawaii division. Oceanic billing system is integrated with customer value creation enterprise module, to synchronize and track Hawaii customer data and product data at enterprise level.

Responsibilities:

Worked on analyze customer data to understand customer behavior, preferences and trends – Customer, Product and Subscription modules.

Worked on data profiling using various relational and DW database systems.

Worked on creating validation strategy, validation plans and validation scripts to validate different events and writing validation scripts using SQL.

Created detailed data mapping specification documents to create mappings.

Environment: SQL, PL/SQL, Informatica, Netezza, Autosys, TOAD, UNIX, Informatica, Cognos

State Of Tennessee -Health Dept., Nashville, TN Mar 2009 - Jul 2010

Sr.Developer /Analyst

Provider Claim processing application (PCP): The system is used by around 6000 providers from Tennessee to submit healthcare claims for mentally challenged 1300 service recipients from across the Tennessee.

July Mandate: The system is used by the Central Office’s Denied Claims Group. The web-based system facilitates search of denied claims coming back from TennCare.

COSMOS Application: COSMOS stands for Client Oriented Survey Management Operating System.

Responsibilities:

Worked on PL/SQL Procedures, Functions and Packages using PL/SQL to implement business rules which will create cost plans, keep track of providers billing, claims submitted to TennCare.

Worked on maintaining HIPAA compliance guidelines for all database related information.

Environment: SQL, PL/SQL, TOAD, Informatica, SQL*Loader, UNIX, Erwin, Crystal Reports

Nissan North America Inc., Nashville, TN Sep 2006 - Feb 2009

Sr.Developer

NNA Finance Application: NNA RDW, GDW Hyperion Finance Application for doing budget, forecast based on the actual expenses of Nissan North America.

Responsibilities:

Worked on preparing and reviewing detailed design documents

Worked on 24*7 support for this application and Co-Ordination with Off-shore teams.

Environment: SQL, PL/SQL, Informatica 6.5, Hyperion Essbase, Planning DB2 and UNIX.

Merrill Lynch, India(Offshore) Aug 2003 - May 2006

Developer

Travel Entertainment Accounts Maintenance (TEAM): TEAM is a system available for usage by the appropriate cost centers of the client. The client has a well-defined procedure through which it is possible for the members of particular cost centers to apply for AMEX cards.

Responsibilities:

Worked on writing PL/SQL stored procedures.

Environment: Oracle9i (SQL, PL/SQL), ASP.NET, XML, VB.NET, VSS, TOAD

Contact this candidate