Data Developer

Profile Summary

Techno Functional Professional with over 9 years of progressive experience in Database Management in the areas of Database Architecture, Data Analysis, Development of Logical, Conceptual and Physical data models. Areas of specialization include Oil and Gas, Healthcare and Telecommunications industries.

Technical experience include the areas of SQL, TSQL and PLSQL development, Extract, Transform and Load (ETL) Strategies, tuning, replication; and solving object-relational mapping, analysis of business and technical requirements, mapping implementation strategies and design (system/application architecture) and experienced in designing functional-technical project document/design, test scripts, data integration and migration, Interfaces, Forms and Reports.

Core Competency

Strategic Planning(Agile),Performance Evaluation, Process Improvement and Budget Forecasting

Project leadership, Management, Intuitive, and Cross Functional analysis in Datawarehouse

Executive and Operational Reporting, Dashboard, Analytical Reports and Forecasting

Experience in Call Center Operation, Monitoring and Reporting, Client Relation and Staff Mentoring

Experience in ICD 9- ICD 10 remediation

Telecommunications and networking technology

Technical Competency

RDBMS: SQL Server 2015, 2012, 2008R2/2008/2005/2000, Oracle 11g, MS Access.

SQL Server Tools: Data Tools 2012, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS, SharePoint, SQL Query Analyzer, SQL Profiler, Teradata SQL Assistant, MS Excel (Report), PowerPivot

Programming Language: Oracle, T-SQL, C, C#, VBA and VB.Net

Reporting Tools: OLAP tools, Crystal Reports, SQL Reporting Services, Business Intelligence/Dashboard Reporting, Tableau, and Power BI.

Data Modeling Tools: MS Visio 2003/2007 Architecture: Relational DBMS, Client-Server Architecture, OLAP And OLTP

Professional Experience

Client : Memorial Hermann, Houston TX

Role : SQL Developer/ Application Analyst

Duration : May 2018 – Jul 2018

Analyzed business requirements and have designed High level and detail level documents for various conversion processes.

Creating of SSIS packages to FTP data from client source into Data Warehouse using SQL Server Data tools with intense use of VB scripting and C# scripting to access and load data.

Created Complex queries to large data sets in efficient manner to meet the business logic.

Worked with end users and vendors to create user friendly reports to meet their business needs.

Created extensive SSIS packages to import and export data to and from Database and have scheduled the SQL Jobs to process the files in timely manner.

Interact with Users and business analysts and meet their business needs with Techno - Functional expertise to convert requirements to technical documents and design and development.

Client : RMS Inc., Houston TX

Role : Sr. Business Intelligence Analyst

Duration : Jul 2016 – Apr 2018

Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development, & Testing of application.

Experience in Complex SQL Queries, Dynamic SQL, Analytical function, various Oracle Objects.

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.

Efficient in creating SSIS packages to FTP data from client source into Data Warehouse using SQL Server Data tools with intense use of VB scripting and C# scripting to access and load data.

Performed data analysis including development and deploying SSRS reports, worked extensively in PowerPivot, Power BI and SAS and generated ad hoc reports for business needs.

Interacted with people from various teams in the Project like Oracle/Teradata DBAs', Maestro Schedulers, Spec. Creators, Reporting and UNIX etc. to aid in the smooth functioning of the Project flow.

Developed data marts using COGNOS Power play and Transformer OLAP tools.

Client : McKesson Specialty Health, Woodlands, TX

Role : Sr. Business Intelligence Analyst

Duration : Aug 2013 – Dec 2015

Collaborate with cross-functional teams and Responsible to load data from Oracle Database to SQL server Database to create new table structures and Procedures for ICD 9 - ICD-10 code set transition and Remediation Project

Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data.

Analyzed business requirements, transformed data, and mapped source data using the Teradata Financial Services Logical Data Model tool, from the source system to the Teradata Physical Data Model.

Extensive knowledge on visualization of data and knowledge of tools such as tableau.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.

Expert in ETL and data flows with various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups.

Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.

Created stored procedures to automate the Load process between the databases on periodic basis.

Created high-level test plans for data architecture and process flow.

Client : Stage Stores Inc., Houston TX

Role : Program Analyst/SQL Developer

Duration : Dec 2012 – June 2013

Analyzed business requirements and have designed High level and detail level documents for various conversion processes.

Good experience about procurement process including suppliers, buyers, orders and allocations to DC s and the whole supply chain process flow.

Generated EXCEL spreadsheets thru VBA to provide detail Reporting solutions for business management people based on different criteria provided.

Implemented slowly changing dimensions methodology to keep track of historical data.

Used Teradata utilities Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases. Developed intensive PLSQL packages, UNIX job run, Unit testing and QA to meet the requirements and successful implementation in production environment.

Client : Universal American, Houston TX

Role : Program Analyst/Team Lead

Duration : Jul 12 – Dec 12

Provide customer phone support for custom Manufacturing Execution System (MES) solution

Application of technical experience to analysis and implement solutions to complex business problems and created Report templates, bar graphs and pie charts based on the financial data.

Coordination with on site and offshore team, work assignment and tracking project from initiation to successful delivery.

Intensively worked on scripts/modules in VBA MS Access to drill down data as per operational needs and export to MS Excel to do pivoting bar graphs for reporting purposes.

Maintain day to day operations in data marts and Data ware housing.

Client : Core Laboratories Inc., Houston TX

Role : SQL Developer

Duration : June 08 – June 11

Gathered the requirements of the client and have performed detailed analysis and development with business users and sponsors to match up their requirements and successfully run in production.

Develop SQL, PLSQL programming triggers and constraints in development and in production environment.

Have good knowledge in Relational and Dimensional data modeling for creating logical and physical design of database and ER diagrams using multiple data modeling tools

Created packages to transfer data between OLTP and OLAP database.

Test cases creation and Unit testing.

Maintenance of development and production database.

Client : LEVEL 3 COMUNICATIONS, Denver CO Role : Oracle Developer Duration : April 07 – September 07

Analysis and tuning of the Application code (SQL) using explain plans to get the statistical data for the performance tuning of the SQL queries and stored procedures.

Participated in writing functional specifications, translating business requirements to technical specification and in creating data models with detailed descriptions of logical entities and physical tables.

Produced query optimization for complex stored procedures and ad-hoc SQL queries to provide user friendly reports.

Involved in planning, development and creation of various web based reports using SSIS and SSRS.

Production Support and Maintenance.

Client : Kulick & Soffa Inc., Fort Washington, PA

Role : Oracle EBS Developer

Duration : September 06 – February 07

Develop Customer Invoice, Booking Snapshot and other custom reports.

Customize Forms and Reports to track down the process from placing an order to the point of shipment confirmation

Trigger the Auto invoice program

Develop PL/SQL Stored procedures to validate the order data from staging tables

Register concurrent programs and concurrent program sets using Application developer and system administration

Navigating through different AR tables like RA_CUSTOMER_TRX_ALL, RA_INTERFACE_LINES_ALL from the client Database.

Client : Cyber Tech, Bangalore, India

Role : Developer

Duration : November 2000- January 2002

Creation of Technical Design and Document Preparation

Test Case Preparation

Coding of Stored Procedures and SQL for data persistence and retrieval

Writing SQL queries for data persistence and retrieval

Involved in testing and quality analysis

Education

Bachelor of Engineering and Computer Science – 2000 (University of Madras, Tamil Nadu, India)

Contact this candidate