JAYAMOORTHY MUTHUKUMARASWAMY

acq7xg@r.postjobfree.com

848-***-****

SUMMARY DETAILS:

Over 7+ years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008 in Development, Test and Production Environments on various business domains like financial services, Health Care, Pharmaceuticals and Constructions.

Involved in various stages of Report Developments including Data analysis, Report designing, development, enhancements and testing of Reports.

Experience in RDBMS Concepts, Database Physical and Logical design, Data Mapping, Table normalization, Data Modeling, Creating ER-diagrams using tools like MS Visio.

Experience in data warehousing dimensional modeling to define dimensions and fact tables using Star schema and Snowflake schema design based on the requirements.

Experience in designing, creating, maintaining, and deploying form reports, tabular reports, drilldown reports, drill through reports, ad hoc reports, multicolumn reports, matrix, and charts using Tableau.

Experience in developing Dashboards, Parameterized Reports, linked reports and Sub reports using SQL Server Reporting Services and Tableau

Worked on the designing of custom objects, custom fields, role based Report layouts, custom Tabs, custom reports, report folders, report extractions to various formats, Snapshots, Dashboards and various other components as per the client’s report requirements.

Designed reporting objects and implemented various advanced fields like checklist, Custom Formula Fields, Field Dependencies, Validation Rules and Work Flows according to reports requirements.

Experience in merging data from heterogeneous data sources like Excel, MS Access, Oracle, and DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, and Bulk Insert utilities.

Experience in writing Complex T-SQL queries, dynamic-queries, sub-queries and complex joins, Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2005/2008/2012.

Highly Experienced in creating Views, Triggers, Functions, Batch Scripts and stored procedures consumed at various stages of migration/cleansing process, reports or data validation.

Experience in Extraction, Transformation, and Loading (ETL) solutions using SQL Server Integration Services (SSIS).

Hands on experience in transformation of heterogeneous data sources into a variety of SSIS transformations and good knowledge in applying ETL concepts.

EDUCATIONDETAILS:

Diploma in Business Intelligence & Data Warehousing (BI & DW), NIIT, India

Master of Business Administration (M.B.A), SASTRA, India

Bachelor of Commerce (B.Com), India

CERTIFICATIONS:

Certified in MS Dynamics Axapta Financials - 2009

TECHNICAL SKILLS:

BI & DW : SSIS, SSRS, SSAS, Tableau, Google Analytics, SAS

ERP : MS Dynamics Axapta Financials-2009

Operating System : Ubuntu, Windows 2000/XP/Vista/8 & Mac OS

Languages : SQL, T-SQL, Visual Basic, Visual C++, Power Builder, HTML

RDBMS : MS-Access, Oracle, SQL – Server 2000, 2005/2008/2012

Creative Tools : Visio, Visual Studio, Adobe Photoshop, MS Office Suite

PROFESSIONAL EXPERIENCES:

Summit Works Technologies Inc.

South-Plainfield, NJ Reporting Analyst – BI Nov’ 14 – Present

Calsonic Kansei North-America Inc.

CKNA Inc. is a global company, manufacturer cum supplier for NISSAN of its leading portfolios in car dashboards, electronic systems, exhausts, engine coolers and interiors. This project aims in fulfilling need for reporting to better understand the Inventory status, Financial positions, Cost trends to improve their decision making process in manufacturing, procurement and financial functionalities. The core purpose of the project is migrating from Man-Man to IFS ERP systems as well as to develop SQL Server BI/DW environment. Coordinate with the business and Database team to design data solutions to accomplish the multi-functionality reporting solutions to the various departments of the organization.

Responsibilities:

Gathered reporting requirements and identified critical functional modules for report design and required data analysis.

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to provide reporting Solutions.

Created detailed reports for the end users to help them decide which area needs to be taken care by showing demographic information based on various parameters.

Generated periodic reports based on the financial analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)

Developed various operational Drill-through and Drill-down reports using SSRS

Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.

Used cascaded parameters to generate a report from two different Data Sets.

Involved with Query Optimization to increase the performance of the Report.

Developed Reports for business end users using Report Builder with updating Statistics.

Involved in Analyzing, designing, building &, testing of SSRS reports using OLAP cubes as data source with MDX queries.

Designed a report on the monitoring of Server Performance using Task Manager. This report gives a detail report to the management on the Performance of the server.

Created parameterized and adhoc reports using Report builder for the Manufacturing and financial departments.

Deployed SSRS reports in multiple environments like report server, Share point folders etc.,

Optimized queries tuned and monitored server performance to run the SSRS reports efficiently.

Formatted the report layout for the requirement of the end users and deploy the developed reports on to the server for the end users.

Environment: SQL, SSIS, SSRS, SAS-EGP, MDX, SQL Server 2008/2012, Oracle, MS Excel

Virrtuo Inc.

Nashua, NH Reporting Analyst – BI Nov’ 12 – Oct’ 14

ALLERGAN Inc.

Allergan Inc. is a global, pharmaceutical company with leading portfolios in eye care, neurosciences, medical dermatology, medical aesthetics and urologic. This project aims in fulfilling need for reporting to better understand the market trends, behavior, future opportunities and to improve their decision making process. Coordinate with the business and Database team to design data solutions to accomplish the multi-functionality reporting solutions.

Responsibilities:

Gathered business requirements and identified critical functional modules for report design and required data analysis.

Created reports using various functionalities of SSRS like Drill-Down, Drill-Through, Filters, Parameters and Cross Tabs etc.

Interact with Business Users, Database team to know their requirement in developing and updating reports in order to meet the end users reporting goals.

Developed interactive Dashboards Using SSRS reporting tools.

Created and deployed Dashboards by connecting discrete data sources systems like Excel, Access, XML database using SSIS with different transformations and various functionalities available in SSRS based on client’s requirements.

Used SSRS Alerts, KPIs to highlight data wherever required in business reports and prompt in deliverables.

Maintained the OLAP cubes for accurate reporting.

Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data using SSAS and used Multi-Dimensional Expression (MDX) to access them.

Involved in comparing, validating and migrating the reports in different Environments.

Stored procedures scripts tuning and understanding Joins, views, functions etc. for resolving report data requirements.

Involved in creation of custom fields, field dependencies, tabs of the reports.

Involved in all the phases of projects from report design level to technical implementation phase and includes client support as well.

Developed Knowledge-Transfer plans, materials and documentation for business users and keep the documents up-to-date.

Environment: SSIS, SSAS, SSRS, SQL Server 2008/2012, Google Analytics, MS Excel,

MS-Visio.

CVC Inc.

CVC Inc. is one of the nation’s foremost construction management and general contracting firms. Building Information Modeling is the process of generating and managing Construction data throughout for each of the project’s which help us to achieve multi-functionality reports. It involves more on Time sheets, Work order Status, Revenue reports and Site Cost reports. It focused more on getting analytical data about Sales Targets vs Actuals, Target customer groups, Season wise marketing analysis Reports, Site cost Reports, Employee work sheet Reports etc.

Responsibilities:

Interact with Business Users to understand requirements in developing and updating reports in order to meet the reporting goals.

Developed various operational Drill-through and Drill-down reports using SSRS

Developed different kind of reports available in SSRS such a Sub Reports, Charts, Matrix reports, Linked reports etc.,

Used cascaded parameters to generate a report from two different Data Sets.

Involved with Query Optimization to increase the performance of the Report.

Developed interactive Dashboards Using DESKI, WEBI, Xcelsius and SSRS tools depending upon the reporting requirements.

Published Reports on the web using Crystal Enterprise Wizard and CMC.

Created Dashboards by connecting discrete data sources systems like MS Excel, XML database and using various functionalities available in SSRS and Xcelsius based on client’s requirement.

Used Alerts to highlight columns based business reports and prompts to deliverables.

Involved in comparing, validating and migrating the reports in different Environments.

Fine tuning T-SQL procedures by understanding Joins, indexes and scripts for resolving report requirements.

Involved in creation of custom fields, field dependencies and tabs of the reports.

Involved in all the phases of project from functional report design to technical implementations and support.

Modify the existing report and security management of the report and deployed as per the report requirements.

Environment: SSIS, SSRS, Business Objects BOXI .R2, SQL Server 2008/2012, Oracle,

MS-Access.

Zylog Systems Ltd., Edison, NJ BI Analyst Jan’10 – Oct’12

ASSOCIATED BANK

Associated Bank Corp is a reputed bank with long and rich tradition of providing superior financial services to the communities combined with exceptional customer service. The main focus of the project was to gather requirements from business users in developing reports and coordinating with the database team to increase reporting capability of the bank’s existing CRM systems using ETL.

Responsibilities:

Understood an existing system and designed modifications to the system to support new requirements.

Involved in requirements gathering, analysis, design, development, deployment and user training.

Created complex formulae in Tableau reports using different type of variables likes report variable and group variable wherever it is required in the report.

Designed, developed and tested processes which include the creation of SQL views, scripts, stored procedures whenever required.

Involved in writing Custom Functions to be used with other Functions.

Designed, developed and tested processes which include the automation of SQL views, scripts, stored procedures using SQL Server Agent.

Extracted data using Query Analyzer and SSIS packages.

Tuned and optimized SQL statements, stored procedures and views using SQL server Profiler.

Wrote complex SQL queries and could quickly understand requirements for complex queries while creating SSRS reports.

Configured, patched, tested, and maintained SQL Server database instances.

Environment: Tableau, MS SQL Server 2008/2012, SSRS, Oracle 8i, T-SQL, SSIS, Excel

GUARANTY BANK

Guaranty Bank and its affiliates are owned by Temple-Inland Inc., a Fortune 500 company. Using its online banking, the clients can pay bill and transfer money easily and conveniently. The clients can also view balances, statements and transactions anytime. My responsibilities are involved in designing, implementing, managing and troubleshooting databases for the reporting mission-critical business reporting requirements.

Responsibilities:

Experienced in complex SQL statements using joins, sub queries and correlated sub queries for report generations using SSRS.

Designed and developed monthly, quarterly and yearly reports at branch and bank level.

Involved in creation of data modeling techniques and set up SQL Server configuration settings.

Analyzed complex queries and tune the same to optimize application and system performance.

Coordinated with DBA in creating and managing tables, indexes, triggers etc.,

Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate etc.

Involved in converting all existing earlier versions of SQL Server DTS packages by using different SSIS tasks.

Optimized long running Stored Procedures and Queries for effective data retrieval.

Involved in Data migration, development and implementation of SSIS on an enterprise level.

Environment: SQL Server 2005/2008/2012, TFS, T-SQL, SQL Profiler, SSIS, SSRS

SOUTHERN TENNESSEE MEDICAL CENTER

STMC provides a full range of inpatient and outpatient services with regional centers of excellence in cardiology, surgery, cancer care, orthopedics, diagnostics, women’s and family services, senior health and an array of specialized services. STMC’s has identified the need to create an integrated Clinical Data Repository (CDR) and a Clinical Data Warehouse (CDW) reporting system that will provide a single source/view of data across the enterprise.

Responsibilities:

Used SSIS to create ETL packages to Validate, Extract, Transform and Load data into Data Warehouse and Data Mart.

Involved in Extract, Transform and Load (ETL) process framework for the large amount of data.

Developed SSIS packages using different types of containers to optimize the performance of the packages.

ETL development using T-SQL programming, scripts, stored procedures and views.

Experience with ER and Dimensional modeling to define the data management.

Involved in Performance tuning and Query Optimization whenever it required.

Created multiple MDX query, views and complex queries against cubes to develop multi-functionality using SSRS.

Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, Excel) to centralized SQL Server databases using SSIS in SQL Server to overcome transformation constraints.

Responsible for developing source to target mappings.

Involved in user interface design and developed scripts to support client business needs.

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

Environment: SQL Server 2008R2, MS Visio, VB, MS office, MS BIDS, T-SQL, SQL Profiler, DB2, Access, MS Excel

Thomas Cook Al-Rostamani LLC

Bangalore, India SQL Server Developer May’ 07- Oct’ 09

Thomas cook provides multiple financial solutions. Its commitment to enhance customer convenience has propelled to grow beyond and offer a plethora of financial products and services at one place. Project responsibilities are involved in designing, implementing, managing and troubleshooting databases and database objects.

Responsibilities:

• Assisted DBA in implementing Data and Database Security using various Default Database and Server roles and also by creating User-defined as well as Application roles.

• Experienced in creating/modifying Tables, Views, Stored Procedures, Functions and Triggers along with in- depth knowledge in query optimization & performance tuning.

• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.

• Created Indexes based on requirements like Clustered index, Non-clustered to increase the query performance.

• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard

• Performed daily tasks including backup and restore data by using SSMS tools like SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.

Environment: SQL, SQL Server Management Studio 2005/2008, SQL Server Profiler,

SQL Server Agent

References: May furnish on Request.

Contact this candidate