Muthyam Singam

acuqhf@r.postjobfree.com Ph No: 732-***-****

Professional Summary

Over 4 years of strong experience in the IT industry as a MS SQL Server 2012/2008R2/2008/2005 Developer/BI Developer in various domains like Financial, Healthcare and Banking.

Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER Diagrams using tools such as MS Visio and Erwin.

Excellent experience in designing, maintaining & tuning various RDBMS like T-SQL & SQL Server 2012/2008R2/2008/2005, MS-Access databases.

Highly proficient in using T-SQL, writing Stored Procedures, Triggers, Functions, XML and Cursors in SQL Server.

Skilled in performing Backups and Recovery, Replication, Security management, Jobs and working with Linked Servers.

Expert in using SQL Profiler, Execution Plan and Performance Monitor.

Proficient in Migration of database, successfully migrated database from SQL Server 2005 to SQL 2008 and SQL 2008R2 to SQL 2012.

Excellent in Performance Tuning and Optimization of queries and stored procedures.

Experience in creating jobs, SQL Mail, Alert and Schedule SSIS Packages using SQL Server Agent.

Extensive experience using various transforms in SSIS as an ETL tool while transferring the data from various sources into the destination files.

Expert in creating complex SSIS packages for ETL purposes using various transformations in SSIS 2005, SSIS 2008.

Transformed data from various data sources to SQL Server using BCP, DTS and SSIS 2012/2008R2/2008/2005

Adept in defining referenced relationships and calculated members in SSAS and used MDX queries, creating OLAP structures from OLTP databases.

Proven ability in defining Query for generating Drill down reports, Matrix reports, Chart reports and handling parameterized reports, creating on demand and scheduled reports in SSRS 2012/2008R2/2008/2005.

Mastered creating stylish Report Layouts using Global expressions, functions, Subtotals, Sorting the data in SSRS 2012/2008R2/2008/2005.

Experienced in all phases of project life cycle, starting from business requirement gathering and analysis to testing and deployment.

Experienced in working as a Sybase Database Developer on ASE different versions.

Solid experience in working with Sybase Client utilities such as isql, defncopy etc.

Maintained positive communications and working relationship at all levels.

Business/Technical skills:

MS SQL Server 2012/2008R2/2008/2005, SQL Server Integration Services (SSIS), SQL Server DTS, Data Stage, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), DWH, Rational Rose, ERwin4.x, EDI, HL7, TOAD 6.0, VB6, Microsoft Products MS Word, MS Excel, VSS,MS Access, Informatica, Oracle 11g,.NET, XML, C#, MS Visio. SoapUI, Webservice.

PROFESSIONAL EXPERIENCE:

Reliant NRG, Houston, TX

April 2015 – Present

MS SQL Server/SSIS/SSRS/SSAS/ETL Developer

NRG Energy, Inc. is a large American energy company, dual headquartered in New Jersey and Texas. It is wholesale and retail electricity generation and Distribution Company. Company served service in 11 US States. The project mainly involved in developing and maintaining SSIS packages and migration of data from various sources to SQL.

Responsibilities:

Work with DBA and SQL Architect to understand the existing system.

Created SSIS packages for File Transfer from one location to the other using FTP task.

Successfully extracted data from flat files/excel files, applied complex transformation and finally loading to SQL Server data warehouse on monthly basis.

Gathered functional requirements and Business requirements and written the technical specifications for building the Enterprise Integrated Data warehouse.

Worked closely with developers, end users in designing and creating the Enterprise Integrated Data warehouse.

Optimization of queries by looking at Execution Plan for better tuning of the database.

Developed numerous ad-hoc reports using SSRS for day to day financial reporting and generated custom and parameterized reports using SSRS.

Provided technical guidance and support to end-users by developing documentations required.

Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Extensively used SSIS transformations such as Lookup, Fuzzy Look Ups, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.

Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.

Work as a Sybase Database Developer on ASE different versions.

Provided back-end support for functional testing, performance testing and provided testing evidence.

Used Index Tuning Wizard, SQL Profiler and SQL trace for Performance Tuning.

Performed Database Refresh tasks from production to Development and Staging Servers.

Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning.

Provided scripts to DBA for production implementation of data warehouse and several other database objects.

Work with Business analysts to create data dictionary for end-user.

Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T-SQL 2014/2012 to store data and to maintain database efficiently.

Used ETL to implement the SCD transformation, to maintain historical data in data warehouse. Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.

Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse.

Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages.

Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams.

Tools &Technologies:

MS SQL Server 2014/2012, MS SQL Integration services, Oracle, SSRS, MS Excel/word/Power point, Visual Studio 2008/2012, Sybase Client utilities such as isql, bcp, defncopy etc, Unix Shell scripting .

HORIZON BCBC

Newark, NJ

May 2013 – March 2015

Junior DWH Developer

Responsibilities:

Managing the delivery and operations of Data Marts, ETL processes, Operational Data Store (ODS), Master Data Management (MDM) and BI solution platforms.

Managing the daily Integration/ETL activities of DW especially on Consumer Lending, Core, and Online Banking.

Involved and supervised Data Modeling, ETL design decisions.

Tracking and Managing the Data Profiling, Data Mapping activities.

Study, Develop, Implement, and Govern COE Best Practices & Standards.

Actively Participate in and/or Lead JRP/JAD sessions.

Assist the Software Development Manager with Team building activities - Recruitment, Coaching etc.

Tools &Technologies:

Informatica, DB2, MQ SERIES, WCC, UNIX, Cognos, VSAM.COBOL, SQL Navigator, Erwin 3.2.5, WinNT & UNIX, Micro Strategy, WIN SQL, CA7 SCHEDULER, Mainframe, MS Excel, MS word, MS Project, IBM WEBSPHERE, JCL, TERADATA V2R6, SHAREPOINT, PLANVIEW

Comcast, West Chester, PA

Apr 2012 – April 2013

MS SQL Server/SSIS/SSAS/ETL Developer

Comcast is major telecommunication, internet and cable connection provider in the USA. The project mainly involved in designing, creating and maintaining databases. It also includes developing and maintaining SSIS packages and creating reports using SSRS.

Responsibilities:

Defined and designed the data sourcing and data flows, data quality analysis.

Identified the data source and defined them to build the data source views.

Involved in extracting the data from OLTP to Data warehouse using SSIS.

Used SQL Server Agent to automate the SSIS 2008 package execution.

Developed stored procedures to transform the data from enterprise data warehouse to SQL server and load data to fact tables.

Transferred data from various sources like MS Excel, MS Access and SQL Server using SSIS 2008 and then created reports using this data using SSRS.

Tested and managed the SSIS 2008 packages and was responsible for its security.

Configured and maintained Report Manager and Report Server for SSRS.

Identified and added the report parameters and created the reports based on the requirements using SSRS 2008.

Developed reports using efficient data retrieval techniques and tested the reports.

Created Cross-Tab, Drill-down and Sub-Report using SSRS 2008.

Responsible for stylish Report Layouts and Deployed the Reports using SSRS 2008.

Identified and worked with Parameters using complex expressions for parameterized reports and managed report subscription in SSRS 2008.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Tools &Technologies:

MS SQL Server 2008 R2, MS SQL Server Reporting Services, MS SQL Integration services,.NET, T- SQL, ERwinv7.3, MS Excel, MS word, Visual Studio 2008.

Contact this candidate