Sql Server Data
Resume:
Mukki Kumar
***********@*****.***
SQL/SSIS, SSRS Developer
PROFESSIONAL SUMMARY:
Nearly 3+ years of Experience in Programming, Development, Data Analyst and Implementation of Database systems using SQL Server 2008 R2/2012/2014 and Toad For Oracle 12.5. Experience in complete Software Development Life Cycle (SDLC). Used Waterfall Model and Agile Methodologies-Scrum.
Experience in T-SQL Developer skills including Stored Procedures, Triggers, Indexes, Views and User Defined Functions to support efficient data storage and manipulation.
Experience in using SSIS for implementation of ETL Methodology in data Extraction, Transformation and Loading.
Worked on managing ETL process by pulling large volume of data from OLTP to a staging Database Using SSIS for Data transformation.
Created packages in SSIS with error handling as well as created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For loop and For Each Loop Container, Execute SQL, Execute Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Slowly Changing Dimension, Look up, Aggregate, Data Conversion, Lookup, Merge, Merge Join, Row Count, Sort, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.
Transferred data from various sources like MS Excel, Flat File and SQL Server using SSIS and then created reports using SSRS.
Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, and
Database health Check, Indexing, and Updating Statistics.
Wrote PL/SQL Queries using Toad for Oracle 12.5
Having Reporting Experience in creating Different kinds of reports and Dashboards using SSRS/POWER BI/Tableau.
Scheduled the Packages in HUDSON Scheduler & SQL Agent on daily/weekly/monthly basis. Scheduling and Monitoring ETL Processes using Batch files.
Knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
Developed Lookup Transformation package for Data Matching, compare source and destination data based on Id and get the new and updated records and then we use conditional split to select that new records before inserting into the database.
Played a significant role of QA testing at various stages of the project including Data Quality Testing, Data load Testing, Data Integrity testing, Business Objects Reports Testing etc.
Excellent analytical, problem solving and interpersonal skills. Ability to learn new concepts fast consistent team player with excellent communication skills.
TECHNICAL SKILLS:
Languages
T-SQL, PL/SQL, HTML-5, CSS3, JavaScript, JQuery.
Databases
MS SQL Server 2008R2/2012/2014
DWH / BI Tools
SQL Server Integration Services (SSIS), SSRS, Business Intelligence Development Studio (BIDS) 2008 R2, Visual Studio 2012/2010.
Database Design and Data Modeling
Star Schema/Snowflake Schema modeling, FACT & Dimension tables, Physical data modeling and De-normalization techniques, Kimball Methodology
Packages
MS Office, Microsoft Office Suit.
Tools and Utilities
SQL Server Management Studio, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Excel Power Pivot, NetBeans7.0, Rational Rose, Tomcat 5.0, TOAD for Oracle 12.5.
Operating Systems
Windows xp/7/8/10.
EDUCATION:
University of Central Missouri Graduation Date: Dec'15
Warrensburg, MO
Master of Science in Computer Science
Coursework: Application Programming in C# and .Net, Database Theory and Apps, Advanced Database Systems, Software Engineering, Operating Systems
Vignana Bharathi Institute of Technology Graduation Date: June'13
Hyderabad,India
Bachelor of Technology – Information Technology
PROFESSIONAL EXPERIENCE:
Client: Duke Energy - Charlotte, NC. July'16 - Nov'16
Role: SQL/ Business Intelligence Developer
Project Name : Team Connect (TC)
Description : Worked closely with attorneys of the company. Created different types of reports and also updated the existing reports using Visual studio 2010. Supported LDM application and also updated the sites using share point.
Responsibilities:
Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2012.
Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
Wrote and manipulated Complex PL/SQL queries using joins.
Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
Experience in creating or maintaining Stored procedures using Oracle PL/SQL.
Advanced extensible reporting skills, developed SQL Server reports using SSRS.
Having Reporting Experience in creating parameterized, drill down reports and table formatted reports as per the requirement using SSRS.
Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
Deploying all the SSRS reports into Team connect report manager.
Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
Interacted with vendors, developers and customers to manage the business requirements.
Environment: Toad for oracle 12.5, Visual studio 2010, MS SQL Server 2012, MS Access, MS-Office, MS-Excel, Team connect, and share point.
Client: Ally Financial Services - Charlotte, NC. Dec'15 - June'16
Role: SQL/ Business Intelligence Developer
Project Name : Financial Shared Services.
Description : Responsible for creating and supporting the SSIS Packages. Worked with financial team of the company. Also responsible for getting the data from different source systems like SAP, CONCUR and ARIBA team's.
Responsibilities:
Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, CTE'S and stored procedures.
Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system to SQL server.
Building the SSIS packages to load the Data into Staging, ODS and dimensional model
Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Knowledge in Job scheduling tools like Hudson.
Create package include a variety of transformation, Slowly Changing Dimension, Aggregate, Derived column, conditional Split and Data Conversion.
Developed Lookup Transformation package for data matching, compare source and destination data based on id and get the new and updated records and then we use conditional split to select that new records before inserting into the database.
Wrote T-SQL statements for retrieval of data and involved in performance tuning of T-SQL queries and Stored Procedures. Optimized query performance by creating Indexes.
Performed the Unit and functional testing which validate the data is mapped correctly which provides a qualitative check of overall data flow up and deposited correctly in Target Tables
Environment: ASP.Net, MS SQL Server 2008 R2, T-SQL, BIDS 2008 R2, Ms-Office, Ms-Excel.
Cloud9Systems, Hyderabad June'12 - June'14
Role: SQL/ Business Intelligence Developer
Project Name : Product And Service Management System
Description :The system is a web based Manufacturing System that enables a Manufacturing company to schedule its manufacturing operations based on the daily update of sales from its dealers. The system modeled to be used by a Manufacturing company, whose main activity is manufacturing different products & then selling the finished goods through a network of Dealers.
Responsibilities:
Worked in Requirement Analysis, Design, Development, Integration & Testing, Implementation and Operations & Maintenance phases of the project.
Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
Sending project status periodically.
Provided assistance for development teams on tuning data, indexes and queries and created indexes on the tables to remove unnecessary columns and to eliminate redundant and inconsistent data.
Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
Created parameterized, drill down reports, matrix reports and table formatted reports to changed old reports as per requirements using SSRS.
Actively participated in developing efficient use of Joins and sub-queries in queries that involve data from multiple tables, also developed T-SQL queries involving joins, Stored Procedures and Views to implement security.
Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
Developed physical data models, data warehouse models and created DDL scripts to create database schema and database object.
Environment: ASP.Net, MS SQL Server 2012, T-SQL, BIDS2008 R2 /Visual Studio 10.0, SSIS, SSRS.
Contact this candidate