Data Manager

Sharath Kumar Sriram

832-***-**** ******************@*****.***

**** ***** ****, *******, ** 22031

PROFILE SNAPSHOT:

An Innovative thinker with extensive experience designing, coding, testing and supporting next generation database solution possessing 6 plus years of experience

Working experience in Banking Domain, Telecom Domain worked on Agile and Waterfall methodologies

Skilled in designing and implementing complete life cycle, client servers and database applications with various development tools and languages

Experienced in Installing, Upgrading and Configuring of Oracle, Microsoft SQL Server and other Databases

Extensive knowledge on multiple platforms - Windows, UNIX and Linux

Extensive experience and actively involved in Requirements gathering, Analysis, Design, Coding and Code Reviews, Unit and Integration Testing. Good understanding of data warehouse and mining concepts

Excellent communication skills, problem solving, ability to learn and adapt quickly to the emerging new technologies and experience in Development environment, Implementation and Production support

Good exposure in analyzing data in highly crowded data sources in data warehouses. Good knowledge of Ralph Kimball Data warehouse concepts and implementation experience

Experience with Python scripting for Data Analysis, hands on experience with python packages like Pandas, NumPy, CSV etc. and experience using Python environments(2.7 and 3) with Anaconda

Proficiency in Data Modeling using Star/Snowflake Schema, OLAP/ROLAP tools, Fact and Dimensions tables, Physical and logical data modeling

Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries

Expert in integration and transforming of various data sources from Databases like MS Access, Oracle, DB2, SQL Server and formats like flat-files, XML, etc.

Proficient in using ETL tools like Informatica (Power Center) Designer, Repository Manager, Administration console and Workflow Manager

Capability to schedule Informatica jobs using Informatica, Windows scheduler and with Unix

Good experience on Trouble Shooting, Configuration and Operational Issues. Documented technical documents SKILL SET:

Programming Languages : Core JAVA, SQL, PLSQL, T-SQL Web Designing : HTML, CSS, XML, ASP .NET, JAVASCRIPT Databases : MS SQL Server, ORACLE 9i/10g/11g

Operating Systems : Windows Server 2008, XP, Vista, 7, 8, Ubuntu, UNIX, LINUX Application Servers : WebLogic, Apache Tomcat, WebSphere Software’s : SVN, ClearCase, IBM Rational Rose, Visual Paradigm, Informatica Power Center, Oracle Forms, Winscp, Putty, ERWIN, SAS Enterprise Miner, SAS Enterprise Guide, BIDS, SSIS, SSRS,SSAS, Eclipse, Visual Studio, TOAD, SQL Developer, Tableau, PLSQL Developer JIRA, SQL Server Data Tools, Confluence, Qlikview

EDUCATION:

Texas Tech University, Rawls College of Business Lubbock, TX Master’s in Management Information Systems (GPA: 3.5) 2014 - 2015 Jawaharlal Nehru Technological University Hyderabad, IN Bachelors in Information Technology (GPA: 3.75) 2006 – 2010 PROFESSIONAL EXPERIENCE:

Infosys Limited (Client: AT&T) Feb’16 - Present

Oakton, VA Technology Analyst

Responsibilities:

Creating on PL/SQL stored procedures, functions, database triggers and packages to achieve the business requirements

Writing sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions

Creating Tables, Views, Constraints, Index and developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL

Analyzing data using Python scripts through CSV package and reporting the findings to business. Generating reports for evaluating the best outcomes and observations using Pandas, Matplotlib, SciPy and NumPy

Developed shell scripts to load data from flat files to oracle database tables using SQL loader and SQL control files

Importing data from excel by writing python scripts using CSV packages

Generating Histograms, bar graphs using Python packages for data analysis for business

Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle

Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager

Involved in creating new table structures and modifying existing tables and fit into the existing Data Model

Extracted data from different databases like Oracle and external source systems like flat files using ETL tool

Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data

Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.

IT Help Central, Texas Tech University Aug’14- Dec’15 Lubbock, TX Graduate Programmer Assistant

Responsibilities:

Prepared technical design/specifications for data Extraction, Transformation and Loading

Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer

Analyzing the sources, transforming data, mapping the data and loading the data into targets using Informatica Power Center Designer

Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data

Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer

Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic

Used Informatica Workflow Manager to create workflows, database connections, sessions and batches to run the mappings

Used Variables and Parameters in the mappings to pass the values between mappings and sessions

Created Stored Procedures, Functions, Packages and Triggers using PL/SQL

Implemented restart strategy and error handling techniques to recover failed sessions

Developed Unix Shell Scripts to automate pre-session and post-session processes

Got a chance to write complex SQL Queries involving multiple tables with joins

Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process

Jeppesen, A Boeing Company June’15- August’15

Denver, CO Web Developer Intern

Responsibilities:

Gathering the requirements across the teams to design a standard template

Created standard project template page in Confluence for various teams in company like PMO, Engineering Team, Testing Team, Architecture and Configuration teams

Involved in Logical & Physical Oracle Database Layout Design and Developed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic. Generated server side PL/SQL scripts for data manipulation and validation

Allowing users to access content dynamically on project template in confluence

Automated the webpages to pull data from JIRA and excel files stored on shared repository

Designed Web application using HTML, Java Script, CSS and Java which interacts with the database for storing and pulling data

Oracle Financial Software Services, Jan’11 – May ’14 Bangalore, KA Associate Consultant

Flexcube is an Online banking application, which enables bank customers to access their accounts through web. The system guarantees convenient and safe access to their account at any time from any chosen place in the world. There are several modules in this system such as accounts, deposits, Transfers, standing orders, beneficiary, applications and reports. Flexcube banking system is a solution which provides front–end application used for servicing day-to-day needs of the bank’s customers. This project deals with development of modules like Loans and Payments, Foreign Exchange, Letter Of Credit, Check Transactions and Journal Enquiry. All transactions are stored in Journal and are branch specific.

Responsibilities:

Involved in various phases of Software Development Life Cycle (SDLC) such as requirements gathering, modeling, analysis, design and development

Worked on Flexcube 3.x, 7.x, 11.x versions with environment using Oracle Database, WebLogic application server and Oracle Forms

Created on PL/SQL stored procedures, functions, database triggers and packages to achieve the business requirements. Generated Oracle reports

Wrote sequences for automatic generation of unique keys to support primary and foreign key constraints in data conversions

Performed Database Administration of all database objects including tables, clusters, indexes, views, sequences packages and procedures

Hands on with ETL Development using ODI

Responsible for maintaining and keep track of the issues reported by various clients for future reference and preparing the technical design documents for the given functional design

Creating test cases for System Testing (Development Environment), Integration Testing (UAT) and Production

(Post Implementation Review)

Also involved in setting up database environment and schemas required for development

Providing technical and functional support for FLEXCUBE universal banking Product AWARDS/ACHIEVEMENTS:

'I-Appreciate' from Oracle for excellent role toward clients and timely project execution for consecutive quarters

Received "We-Applaud" award for training new comers and making them with the familiar to the Oracle company process and projects for three continuous batches

Contact this candidate