MUTHU

acwaex@r.postjobfree.com

EXPERIENCE SUMMARY:

Around 7 years of experiencein Database programming, System Analysis, Design, Development, Maintenance & Support of MS SQL Server 2005/2008/2008R2/2012, SQL/SSIS/SSRS/SSAS/DBA on various domains like Marketing, Financial and Health andEquipped with excellent communication and interpersonal skills and has in-depth understanding of Trade life cycle and Trade settlement process..

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

Designer/developer of Web and Windows applications using .Net 3.0/3.5/4.0, C#, VB.NET, Win forms, ASP, ASP.NET, ASP.NET MVC, ADO.net, Web services, WCF, and XML in multitier architecture.

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.

Strong Experience in designing, developing & consuming XML web services using C#, ASP.Net, SOAP Headers and Extensions, SOAP Protocol, WSDL.

Hands on Experience in using various frameworks, tools and technologies like Visual Studio, Dreamweaver.

Extensive knowledge of the Software Development life Cycle (SDLC) from requirements gathering, Analysis, Design, Development, Integration, Implementation and Testing of applications.

Proficient with Agile Methodology.

Hands on Experience in ASP.NET, MVC3/4, WCF, WPF, .NET SQL Server Reporting Services (SSRS).

Experience in all phases of application development including User Interface/ Presentation, Business Logic and Data tiers.

Experience in securing web applications using ASP.NET authentication and authorization mechanisms.

Strong experience in design patterns like Model View Controller (MVC).

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.

Strong experience in creating reports using Microsoft SSRS and Crystal Reports.

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

Maintained positive communications and working relationship at all levels.

EDUCATION :

Bachelor of Technology in Computer Science and Engineering, JNTU, India.

TECHNICAL SKILLS:

RDBMS/DBMS:

MSSQL Server 2005/2008/2012, Oracle 9i, MS Access 2003/2007

Operating Systems:

MS-DOS, Windows 7/Vista/95/98/NT 4.0/XP/2000/2003 Server, UNIX, Linux

Programming Languages:

T-SQL, PL/SQL, Dynamic SQL, C, VBA, Visual Basic 6.0, C# .NET, VB .NET, ASP .NET, ADO.NET, XML, HTML, DHTML

DataDesign Tools:

ER/Studio, ERWIN, MS Visio, Rational Rose, Smart Draw

BI Tools:

SQL Server Reporting Services (SSRS 2000/2005/2008/2012), SQL Server Integration Services (SSIS 2005/2008), SQL Server Analytical Services (SSAS 2005/2008), Data Transformation Services (DTS), Visual Studio

Tools/Database Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Performance Point Server, Business Intelligence Development Studio (BIDS), Crystal Reports 9.0, XML

PROFESSIONAL EXPERIENCE:

Reliant NRG, Houston, TX April 2015 – Present

Role: MS SQL Server SSIS/SSRS/SSAS/DBA/ETL Developer

Description: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.

Work with SSDT, SSIS, and SSRS for enhancing the existing system.

Involved in Design and Developing components of the applications using ASP.NET, MVC, C# .NET, JavaScript, JQuery, XML.

Worked with MVC 3.0/4.0 architecture application using Razor view engine and web API.

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.

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.

UsedTFS for the purpose of version Control and source code maintenance needs.

Involved in Coordinating with off-shore team and giving Non-prod support for 24hrs at on call schedules.

Worked on existing OLTP system(s) and created facts, dimensions, data models, star schema representation for the data mart of OLTP and Data warehouse databases.

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

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2/2008 and 2012, ASP.NET, MVC, C# .NET, JavaScript, JQuery, XML, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP.

Cigna, Philadelphia, PA May 2013 – March 2015

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

Description: Cigna is global health service organization. It is major provider of medical, dental, disability, accident and life insurance and related products. The project mainly involved in developing and maintaining SSIS packages and support Single sign on connection for medical underwriting.

Responsibilities:

Attended the Business Requirements walk through sessions and Design Walk Through sessions to understand about the project

Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.

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

Designed and developed the application using Visual Studio 2010 and ASP.NET 4.0.

Responsible for migrating classic ASP applications into ASP.NET MVC 3.0 applications.

Used MVC UI Pattern to design the Test driven UI Layer.

Analyzed and designed existing transaction sets, and modified these transaction sets to ensure HIPAA compliance.

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.

Developed and deployed data transfers packages using SSIS 2012/2008, also maintained the jobs running on Servers.

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

Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions.

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

Supported and created Single sign on for medical underwriting platform for third party administration using XML, SoapUI.

Deploying, Testing and Scheduling SSIS packages using SQL Agent.

Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.

Created many Cascaded parameters in the reports using SQL SSRS 2012/2008. Developed many Tabular Reports, Matrix Reports, Drill down Reports and Charts using SQL Server Reporting Services (SSRS 2012/2008).

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

Environment: T-SQL, PL/SQL, MS SQL Server 2008R2/2008, XML, Soap UI, ASP.NET, MVC 3.0SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS), Windows XP.

Comcast, West Chester, PA April 2012 – April 2013

Role: SQL Developer/Crystal Reports Developer

Description: 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 techniquesand 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.

Created complex functions and views based on the business requirements.

Tested and standardized the data to meet the business standards using Fuzzy /exact lookups.

Defined relationships between Measure groups and Dimensions.

Deployed the generated reports on to the Report server and fine-tuned the database objects and server to ensure efficient data retrieval.

Environment:MS SQL Server 2008, T-SQL, .NET, ERWIN 7.3,Windows Server 2008, SSAS-2008/SSIS-2008/ SSRS-2008.

Raymond Corp, Greene, NY Sep 2009 - March 2012

Role: SQL Server Developer

Description: Raymond Corporation operates material handling for various industries since last 90 years. The project mainly involved in designing, creating and maintaining databases. It also includes developing and maintaining SSIS packages and creating reports using SSRS.

Responsibilities:

Participated with business analysts in order together requirements for design and implementation of database.

Designed high level ETL architecture for overall data transfer from the OLTP to Data warehouse with SSIS and also prepared ETL mapping processes and maintained the mapping documents.

Expert in extracting, transforming and loading data using SSIS Import/Export Wizard.

Created SSIS Packages to integrate data coming from Text files and Excel files.

Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

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

Created local variables and global variables package configurations and error handling.

Responsible for designing, creating and deploying the reports into the production server.

Created complex store procedure to copy Database Objects from remote server to local machine and vice versa.

Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.

Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.

Responsible for ongoing maintenance and change management to existing reports and optimize report performance (SSRS).

Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

Responsible for creating and implementation of data access stored procedures and triggers for automating tasks.

Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: T-SQL, PL/SQL, MS SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MS Excel, Windows XP.

Contact this candidate