Mani C

SQL BI Developer/SSIS/SSRS/SSAS

Phone: 813-***-****

Email: ac53zl@r.postjobfree.com

Summary:

Over 7+ years of Experience in Data Warehousing and Business Intelligence applications design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).

Experience in data analysis, design and development of databases for business applications in a client/server and data warehouse environments in SQL 2000/2005/2008/2012/2014/2016.

Expertise in writing T-SQL queries, dynamic queries, sub-queries and complex joins for generating complex Stored Procedures, Triggers, User-Defined Functions, Views, Constraints (Primary key, Foreign key, Unique key, check key etc.) and cursors.

Extensive knowledge of Tuning SQL queries, Maintaining Data Integrity and Data Consistency, Performance Tuning and Query Optimization.

Created packages using SSIS, SSMS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.

Experience in Administration/Maintenance of source control management systems, such as Sub Version (SVN), Perforce, CVS, TFS, GIT and knowledge of Clear Case

Expert in configuring and creating SSIS solutions for high performance Data Integration, Data Migration and Business Intelligence Process that includes Merging Data from various Heterogeneous Data Stores, Populating Data Warehouses and Data Marts, Cleaning and Standardizing Data.

Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Bulk Insert, Data Replication, Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Proficient in OLTP, OLAP and Data Warehousing Design concepts.

Expertise in creating Packages by SSIS/DTS for ETL work.

Proficient in building Cubes, defining Referenced Relationships and creating Hierarchies in SSAS.

Expert in Tabular Modeling, Multi-Dimensional Cubes, DAX and MDX (SSAS)

Expertise in creating Cell Level Security, Perspectives, Partitions and Design Aggregations in cubes using SSAS.

Expertise in creating Dashboard Reports to support end users using SSAS.

Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.

Experience in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.

Extensive experience in different type of reports including: Tabular forms, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports. Very good experience in writing expressions in SSRS.

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive

Experienced in preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.

Experience in validating the results in Tableau by running SQL queries in MS SQL developer.

Proficient in Tableau 7.x/8.x/9.x (Desktop, Server, Mobile, Public), MicroStrategy 9.x/8.x product suite (Desktop, Intelligence Server, Narrowcast Server, Command Manager, Web, Mobile, Integrity Manager and Administration).

Familiar with parallel processing database like Teradata.

Worked extensively on planning, installing, deploying and configuring both SharePoint 2010 and SharePoint 2013 in both single server deployment and multi-server (server farm) deployment.

Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.

Excellent time management and strong team player.

Education:

Bachelors at ANU Guntur, India.

Technical Skills:

Databases

SQL Server 2016/2014/2012/2008/2005, MS Access, Teradata, Oracle, DB2, AS400 and MySQL

Database Tools

SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, T-SQL, PL/SQL, OLAP, MOLAP, ROLAP, OLTP, DBCC.

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica 8, ProClarity OLAP tools, Performance Point Server 2007, Crystal Reports 9.0/XI

Languages

SQL, T-SQL, PL/SQL, Dynamic SQL, .NET, HTML, C, C++, C#, UNIX, MDX.

Web Technologies

XML, HTML, XSL, JavaScript, IIS

Database Design Tools

Erwin 5.1, MS Visio 2007/2003, Rational Rose(UML)

Tools & Technologies

PerformancePoint Server 2007(ProClarity), Enterprise Manager, SSMS, Database Tuning Advisor, DTS, Analysis Manager, BCP, Visual Studio, Microsoft Office SharePoint Server 2007.

Operating Systems

Windows 2000/NT 4.0, Windows 2003 Advanced Server/

Windows 95/98/200/XP-pro, UNIX

Professional Experience:

Aetna, Phoenix, AZ Jul 2017 – Till Date

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

Extract, Transform and Load the source data into the respective target tables to build the required data marts.

Install and configure the servers and clients using SQL Server 2012/2014. Create and upgrade SQL databases.

Get some Understanding regarding the user requirements and Data Model defined and developed by the business analysts and data architects.

Created functional specification document and technical specification document.

Constructed OLTP and OLAP Databases.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.

Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.

Migrated DTS objects to SQL Server Integrated Services (SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.

Involved in loading data from Teradata to HDFS

Maintaining the build environment, the source code control system and managing build packages using TFS.

Administering and Monitoring TFS Servers.

Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.

Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

Designed SSAS Tabular model for summary reports.

Performed migration operation from SharePoint 2010 to SharePoint 2013.

Created Snapshots, Subscriptions and Transactions using Replication services.

Responsible for gathering business requirements to create business user reports.

Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008/2012 with .NET applications.

Migrate existing data into the Power BI.

Create reports in Power BI preview portal utilizing the SSAS Tabular.

Published Power BI Desktop reports created in Report view to the Power BI service.

Transformed and combined the data using Query Editor in the Power BI.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Created roles using SSAS to restrict cube properties.

Writing the DAX statements for SSAS Cube

Created roles using SSAS to restrict cube properties.

Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the SSAS Tabular Models.

Developed Report Models for building Ad hoc reports using SSRS. Developed optimal stored procedures and queries to create data sets for reports.

Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports..

Expertise in creating SQL code for extracting, summarizing, aggregating or presenting data from database systems using report writer.

Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.

Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.

Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS, TOAD and SQL*LOADER

Environment: SQL Server 2014/2012/2008 R2 Enterprise Edition, Microsoft Dynamic GP, Micro Strategy Desktop 10/9, SSRS, SSIS, SSAS, Redgate, .NET Framework, C#, ADO.NET, Windows Advance Server, XML, MS Excel, Access and Team Foundation Server (TFS).

Komatsu America Corp, Rolling Meadows, IL Apr 2015 - Jul 2017

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

Built Data marts (Fact and Dimension tables) from the warehouse tables.

Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.

Extract, Transform and Load (ETL) source data into respective target tables to build the required data marts.

Understand user requirements and Data Model defined and developed by the business analysts and data architects.

Wrote hundreds of stored procedures and function on numerous SQL servers to use in SSIS package and Power BI.

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server. .

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

Created SSIS Packages per the requirements.

Communicate to the business analyst, Data Modeler on a regular basis to be informed on changing requirements or data model design alterations.

Worked with Flat Files (Pipe Delimited) sources and implemented error handling routines.

Worked with Flat Files Data source connections, ODBC data source connections (to SQL server sources) and DB2 data source connections.

Created OLAP Dimensions, Measures and Cubes using SSAS.

Implemented and enhanced existing reports like Group by, Drilldown, Drill Through, Sub-Reports, List, Tabular, Matrix, Navigation Reports, Standard Parameter, Cascading Parameter and Multivalve Parameters.

Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations.

Used comprehensive knowledge of T-SQL code as well as SSIS, SSRS, visualization tools i.e. Power Bi and Tableau and predictive modelling to build models for tangible operational excellence of the commercial aviation business

Constructed OLTP and OLAP Databases.

Extensive Knowledge in Creating Relationships, Measures, Partitions, Calculations using DAX and KPIs in SSAS Tabular model.

Extensive use of DAX (Data Analysis Expressions) functions for the Reports and for the Tabular Models.

Used Query, SQL, Merge, Case, Validation transforms to transform the data (as needed) before loading into the warehouse tables.

Wrote custom functions to produce the derived fields using the source table fields for each record from source

Used Date functions, String functions, Database functions to manipulate and format source data as a part of Data cleansing and data profiling process.

Worked on Power BI and prepared dashboards using Tableau to make it more attractive.

Created, Maintained & scheduled various reports in Power BI like Tabular Reports, Matrix Reports.

Created Power BI Visualizations and Dashboards as per the requirements.

Worked with Date/time manipulations in SQL Server built in functionalities as well as Data Integrator Date functions.

Generated Parameterized/dropdown SSRS Reports.

Implemented history preserving using Table comparison, History Preserving and Key generation transformations in warehouse /dimension workflows.

As a part of optimization: Used MAP operations to route UPDATE and INSERT records in warehouse workflows

Ran stats on all tables. Right choice of transformations & right design in data flows. Implemented incremental load process.

Handled the cross schema (Warehouse, Data mart) challenges between the different environments (Development, QA and Production) by granting permissions on tables using Database functions in scripts before running work flows.

Prepared ETL design documents for implemented work flows and loaded the documents in the project share point site.

Environment: SQL Server 2012 R2/2012 Enterprise Edition, Enterprise Manager, MicroStrategy Desktop 10/9, TFS, ERWIN, UML, MS Project, .NET, C#, ASP.NET, SSIS, SSRS, SSAS, Team Foundation Server (TFS), SQL Server Agent.

EQHealth - Tampa, FL Jan 2014 - Mar 2015

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF’s) for business logic.

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

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

Transformed the data using different SSIS transformations like Aggregate, split, join, merge, derived column, Multicast, term extraction and data conversion of SQL Server Integration Services (SSIS).

Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.

Created numerous MicroStrategy objects which used features like Dimensional metrics, Transformation metrics, Conditional Metrics, Relationship filter, pass through functions.

Experienced using MicroStrategy Data Mining Services, Business users, report designers and have distributed these reports to all relevant decision makers.

Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.

Created multiple reports (SSRS) like Drill-Down, Drill-Through, Sub Reports, Chart Reports & Matrix Reports.

Design, deployment, and maintenance of various SSRS Reports in SQL Server.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

Generated reports using the Reporting Services analyzed using Server analysis (SSAS).

Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Backing up, restoring system & other databases as per requirements, and scheduled those backups.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2008 R2/2005, Visual Studio 2008/2010, MicroStrategy Desktop 10/9, Windows 7, SSIS, SSRS, Report Builder 3.0, SQL Profiler, SQL Server Agent, MS Excel, Power Pivot, TFS.

T-Mobile, Bellevue WA Jun 2013 - Jan 2014

SQL/SSIS/SSRS Developer

Responsibilities:

Installed and configured MS SQL Server 2008 Enterprise Edition on multiple environments.

Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views, CTE’s and other T-SQL scripts.

Developed and created logical and physical database architecture for servers and warehouses. All tables in database were normalized up to third normal form.

Migrated data from text files and Excel spreadsheets to SQL Server databases using SSIS.

Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

Created and scheduled SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File and vice versa.

Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.

Created Project Expense Statements in all Data marts and other Financial Reports using SSRS.

Responsible for Deployment of the report using SSRS and used Report subscription (Data Driven and Email) to publish reports.

Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.

Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.

Environment: SQL Server 2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows XP, Visual Source Safe (VSS), SQL server profiler, SQL Server Management Studio (SSMS).

Microtek, Hyderabad, India Dec 2012 - Jun 2013

SQL/SSRS/SSIS Developer

Responsibilities:

Managed the migration of SQL Server 2005 databases to SQL Server 2008.

Created Table, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.

Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.

Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.

Actively involved in Normalization & De-normalization of database.

Generated periodic reports based on the statistical 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.

Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.

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

Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.

Involved in the Data modeling, Physical Design of Database using tools like Erwin.

Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.

Performing Replication (snapshot and transactional).

Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining security up to date.

Environment: SQL Server 2005/2008, Reporting Services (SSRS), Integration Services (SSIS), DTS, Oracle 9i/8i, T-SQL, XML, MS Excel and MS Access.

Lee Cooper Ltd, Noida, India Aug 2011 – Nov 2012

SQL/ETL Developer

Order Entry and Inventory System: This Project involves development of integrated package for order entry and inventory management. The package enables order entry for taking customers’ orders, maintaining inventory and shipping to the customers. The package consists of an information system to enable the user to access the status of the sales orders, stock balances, stock value and shipped orders.

Responsibilities:

Creation, manipulation and supporting the SQL Server databases.

Involved in the Data modeling, Physical and Logical Design of Database

Created tables, indexes, sequences, constraints, triggers and procedures.

Stored procedures and triggers were used to implement business rules.

Helped in integration of the front end with the SQL Server backend.

Developed various operational, drill-through and drill-down reports using SSRS.

Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS) & SQL Server Integration Services (SSIS).

Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries

Created documentation as required.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Created SSIS package to get data from different sources, consolidate and merge into one single source.

Environment: MS SQL Server 2005, SQL Integration Services (SSIS), SSRS, Data Transformation Services (DTS), Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008, Windows 2007 Enterprise, MS Office 2007.

Coca-Cola, Atmakur,India Dec 2010 – June 2011

Jr. SQL Developer/DBA

HCCBPL is the largest bottling partner of The Coca-Cola Company (www.thecoca-colacompany.com) in India. It is a part of The Coca-Cola Company’s Bottling Investments Group (BIG) and responsible for the manufacture, package, sale and distribution of beverages under the trademarks of The Coca-Cola Company.

Responsibilities:

Actively supported business users for change in requests.

Created T- SQL queries for data retrieval and created other database objects like tables, views, Stored Procedures, Functions, Triggers and indexes.

Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.

Installed and configured SQL Server 2005 successfully.

Assisted the front end application developers with their queries.

Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.

Created the test file, which includes all the scenarios and complexities of the product.

Wrote distributed queries for Linked Servers.

Maintained the consistency of the client’s Database using DBCC.

Performed replication of data and planned backup strategy based on project requirements.

Environment: MS SQL Server 2000/2005, MS SQL Enterprise Manager, Visual Source Safe (VSS), SQL Profiler, SQL Server Management Studio (SSMS), T-SQL, VB, Java Script, MS Excel, SQL Server Agent.

Contact this candidate