Name: Sai Chand

Email: ac8arm@r.postjobfree.com

Mobile: 571-***-****

Professional Summary

As a Certified SQL developer having 6 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server2014/2012/2008R2/2008/2005/2000 in Development, Test and Production Environments with various business domains.

Proficient experience in Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services(SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)

Expertise in designing SSIS packages to import and transform data between databases and external data sources using various transformations

Experience in configuration and maintain report manager and report server for SSRS, Deployed and scheduled the reports in report manager

Experience in generating reports using SQL Server Reporting Services(SSRS), Crystal Reports, WEBI Reports and MS Excel spreadsheets and Power Pivot.

Strong expertise in using ETL Tool Informatica Power Center 8.x/9.x/10.0 (Designer, Workflow Manager, Repository Manager and ETL concepts.

Designing and developing Informatica mappings including Type-I, Type-II, Type-III slowly changing dimensions (SCD).

Experienced in using advanced concepts of Informatica like push down optimization (PDO).

Validating data files against their control files and performing technical data quality checks to certify source file usage.

Experience in performance tuning of Informatica mappings and sessions to improve performance for the large volume projects.

Experience in Assisting other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation

Generated Tableau visualizations and dashboards using tableau desktop. Generated Dashboards with Quick filters, parameters and sets to handle views more efficiently

Experience in Built dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices.

Involved in trouble shooting of performance issues which were associated with Tableau reports.

Knowledge in all types of Database migrations with all the versions of SQL Server.

Strong Communication and Management Skills with excellent role-playing capabilities.

Excellent analytical, problem solving skills and a motivated team player with excellent inter-personal skills and familiar with offshore and multi-site development.

Technical Skills

Databases Tools

MS SQL Server 2017/2016/2012/2008, Business Intelligence Development Studio, SQL Server Profiler 2017, Informatica

Reporting Tools

Data Transformation Services (DTS) – Export/Import, SSIS, SSRS, SSAS, Tableau and Weka

Programming

T-SQL, PL-SQL and Oracle

Data Warehouse

Star and snow-Flake Schema Modeling, Fact and dimensions, physical and logical Data Modeling

Data Modeling

Microsoft Visio

Cloud Technologies

Microsoft Azure

Operating Systems

Windows 2012/2008/2003, Mac, Linux

Smart Energy Water (HCL), Irvine, CA Aug 18 -Till date

SQL Developer

Responsibilities

Worked with application developers and production teams across functional units to identify business needs and discuss solution options.

Designed and implemented SSIS packages to migrate data from heterogeneous data sources to staging database and load the data to data warehouse or data marts.

Excellent report creation skills using Microsoft SQL Server 2017 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder

Created T-SQL queries, complex Stored Procedures, User-defined Functions, designing and implementing of Database Triggers (DDL, DML), Views and designing and implementing Indexes.

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

Experience in monitoring MS SQL Server databases and performance tuning using Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.

Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation process for efficiency purposes

Created user variables, property expressions, script task in SSIS. Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.

Migrated data from SAS environment to SQL Server 2017 with SQL Server Integrated Services SSIS.

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.

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

Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2016

Developed optimal stored procedures and queries to create data sets for reports. Involved in migration and Conversion of Reports from SSRS 2013 to 2016

Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Strong Experience in Azure based Power BI to import, shape, and transform data for business intelligence (BI), Visualize data, author reports, schedule automated refresh of reports and share dashboards based on reports in power BI desktop

Worked with subject matter experts (SME's) and project team to identify, define, collate, document and communicate the data migration requirements

Environments:

Windows server 2003, IIS 6.0, MS SQL Server-2017/2016/2013/2010/2008 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Performance Point Sever, Office-2017, MS Excel

Air Liquide, Houston, TX Oct 16 - July 18

SQL Developer

Responsibilities

Developed and implemented custom data validation stored procedures for metadata summarization for the data warehouse tables, for aggregating telephone subscribers switching data, for identifying winning and losing connection, and for identifying value subscribers

Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.

Spearheaded a project to implement company standards and establish procedures to ensure a unified data management approach.

Experience in Backup, using different Recovery models depending on Application requirement.

Experience in Performance Monitor/SQL Profiler to solve dead locks/long running queries.

Created the design and technical specifications for the ETL process of the project.

Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.

Worked on Informatica Power Center tool - Source Analyzer, Data Warehousing Designer, Mapping Designer & Mapplets and Transformations.

Worked with various complex mapping, designed slowly changing dimension Type1 and Type2

Developed Parameter files for passing values to the mappings for each type of client

Experience in design and developing Application leveraging MongoDB.

Experience with creating script for data modeling and data import and export. Extensive experience in deploying, managing and developing MongoDB clusters.

Performed day-to-day Database Maintenance tasks including Database Monitoring, Backups, Space, and Resource Utilization.

Creation, configuration and monitoring Shards sets. Analysis of the data to be shared, choosing a shard Key to distribute data evenly. Implemented scripts for mongo DB import, export, dump and restore

Scheduled batch and sessions within Informatica using Informatica scheduler and wrote shell scripts for job scheduling.

Working with team of developers designed, developed and implement a BI solution for Sales, Product and Customer KPIs.

Developed a 360-business dashboard with multiple panels and parameters that became a driver for sales force team.

Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x) reports.

Created Tableau Dashboards with interactive views, trends and drill downs along with user level security.

Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.

Worked on other packages of the SQL server 2013 Edition SSRS (SQL Server Reporting Services), SSAS (SQL Server Analysis Services).

Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Environment:

Windows 2000 Advanced Server, SQL Server 2014/2013/2012/2008, Enterprise Manager, Informatica 9.6, Tableau, SQL Profiler, SQL Query Analyzer, ETL: MS SQL Server DTS, Windows Performance Monitor.

Immunomedics, Morrisplain, NJ Apr 15 - Sep 16

SQL developer

Responsibilities

Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Experience in T-SQL Scripts and stored procedures to implement the business needs and to support the frontend application.

Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008

Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications

Hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.

Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.

Worked on designing and executing a Data Quality Audit/assessment, data quality mappings that cleanse data

Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.

Evaluate and implement recommended industry wide security practices for MS-SQL and Windows.

Extensively worked on Unit testing for the Informatica code using SQL Queries and Debugger.

Coordinated with Autosys team to run Informatica jobs for loading historical data in production.

Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.

Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Performed data integration and lead generation from Informatica cloud into Salesforce cloud.

Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.

Migrated the entire schema as well as data into MS SQL Server 2008 and validated the migration process to ensure that it has been successfully migrated.

Created DTS packages to copy tables, schemas, views and to extract data from Excel using SSIS.

Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers& maintaining Referential Integrity.

Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports. Expertise in Report writer.

Environment:

MS SQL Server 2000 Enterprise Edition, Enterprise manager, Informatica Power center 9.6, MS Access 2000 & Windows NT platform, Reporting Services, DTS, Business Objects 4.0/6.5, Windows Active Directory

PatnySystems, Telangana, INDIA May 13 - Mar 15

SQL Developer

Responsibilities

Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Designed ETL SSIS packages for data migrations, alerting notifications for various processes and developing automation process for efficiency purposes.

Created logs 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.

Generated occasional reports in view of the factual investigation of the information utilizing SQL server Reporting services (SSRS)

Created SSIS Packages using Variables, Expressions and Environment Variables

Reconcile data for transformation from SQL 2010 to SQL 2012 using SSIS

Created Production support packages.

Migrated DTS 2010 packages to SSIS 2012 Packages.

Used SSAS (SQL Server Analysis Services) for designing UDM including dimension and Fact Tables.

Involved in re-designing of database to create de-normalized reporting schema for better throughput.

Expertise in Report writer. Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.

Assisted in building the ETL source to Target specification documents by understanding the business requirements

Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.

Implement performance tuning on a variety of Informatica maps to improve their throughput.

Used Look up, Pivot, Merge Join, Union all, Derived Column, Conditional Split, and Aggregate transformation to manipulate data in SSIS package data flow.

Created and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views, user security management.

Environments

MS SQL Server 2005, SSAS, SQL Server Reporting Services 2012, SSIS, Informatica 9.6, Front Office 8.3 / 10.2 / 10.3, Windows XP / NT / 2000/2003, MS Office 2003/2007.

Education

Master’s in Computer and Information Science from New England College - Henniker, NH

Graduated- Oct 2017

Bachelor’s in Electronics and Communication Engineering from Andhra University

Year - May 2013

Contact this candidate