Data Manager

Email: *.**********@*****.*** Mobile: +1-904-***-****

Location: 18328 43rd. Dr SE, Bothell, WA, 98012

Summary:

Over 5+ years of IT Experience in design of IT experience Most of the experience in designing & coding of database, and applications of MS SQL Server/Oracle. Work experience in the Area of SQL Development, integration Development using Microsoft tools like SSIS, SSRS, SSAS & POWER BI.

Strong T-SQL experience in creating different database objects Tables, Stored Procedures, DDL/DML Triggers, Functions and User defined data types. Skilled in writing and reviewing-SQL code and maintaining coding standards.

Good knowledge of Data Warehouse/Data mart concepts and Expertise in data modeling for OLAP & OLTP systems from design and analysis to implementation including the conceptual, logical and physical data models.

Experience with Relational and Dimensional data modeling using ERWIN, understanding of Ralph Kimball and Bill Inmon methodology for Dimensional Modeling, Star and Snowflake Schemas. Thorough understanding of DW concepts like Facts, Dimensions, Surrogate Keys, drill down and drill across approach.

Experienced in Installing, Upgrading and Configuring Microsoft SQL Server2014/2012/2008.

Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using Power BI SQL Server 2014/2012/2008, DTS, SSIS, SSAS and SSRS 2012/2014.

Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.

Experience in writing complex SQL queries involving multiple tables inner and outer joins.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and indexed views and Created views as per design needs for security reasons.

Experience in Creating Tables, Views, Triggers, Stored Procedures, Power BI User Defined Functions and other T- SQL statements for various applications.

Worked Extensively on ETL process using SSIS package.

Excellent in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), DTS, Bulk Insert, BCP. Also, created data using SQL Server Integration Services (SSIS) and coordinated with ETL developer' s team to ensure data extracted, transformed and loaded according to the specified requirements.

Expert in design and development of SQL Server Integration Services (SSIS) packages and Using various control flow task and data flow transformation.

Excellent in creating SSIS Packages for integrating data using OLE DB connection from Heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.

Expert in creating various type of reports such as Complex drill down & drill through reports and Created SSIS packages to import/export sales data to/from the excel sheets, flat files, XML files or other databases as per the user requirements.

Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases. And working with SAP Cubes and DSO`s and ETL Process.

Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.

Absolute knowledge of software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.

Educational Qualification:

Bachelor of Engineer (Information Technology) Birla Vishvakarma Mahavidyalaya (BVM) 2003- 2007.

Technical Skills:

RDBMS: MS SQL Server 2016/2014/2012/2008/2008R2, Oracle Database, MySQL, PostgreSQL, Azure SQL Database, HyperSQL, Oracle Database Express Edition (XE), WebScaleSQL. Programming Languages: C Language, C++, Python, T-SQL, SQL, Profiler Business Intelligence Development studio (BIDS), DTS, XML, HTML/CSS, GitHub. BI Tools: Power BI Application Packages Microsoft Office Suite, SQL Server Reporting Services

(SSRS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Analysis Services (SSAS), MS Visio, MS Outlook, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, Enterprise Manager, VMware, ProClarity, OLAP & OLTP, MS Outlook, Microsoft Performance Point Server 2007. Reporting Packages: SQL Server Reporting Services (SSRS), MS Excel, Power BI. Operating Systems: Erwin 8.0/7.2/7.1, Visual Studio, Windows 10/8.1/8/7/XP, Windows Server 10/8.1/8/7/XP.

Professional Experiences:

GrammaTech Ithaca, NY MSBI Developer Jan, 2020 – Present

Actively participated in interaction with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Wrote several SQL Scripts such us finding tables that have Identity Columns, finding tables that do not have primary key.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases and implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.

Reduced the T-SQL overhead successfully by avoiding unnecessary use of the UNION, statement & using the TOP operator to limit the Select Statement in certain Queries.

Created views to restrict access to data in a table for security.

Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Published reports and dashboards using Power BI.

Direct and/or execute the technical characteristics of the overall strategy of the data warehouse and ETL process.

Work closely with IT and the Business group to understand business reporting requirements and analyze logical model, and develop subject matter expertise in a short time.

Facilitate Joint Application Development (JAD) sessions for gathering requirements for building a data warehouse and data marts.

Participate in development and execution of tactics and strategies to optimize data quality in data warehouse, and OLAP environment.

Create and design logical and physical data models using ERWIN– identify entity & its relationships and define the project’s informational needs. Design Source to target mapping as per the requirement of the client and business rules to load the data from ODS to Data Warehouse.

Architect the database schema and implement a relational (for ODS) and dimensional model

(star schema). Review and maintain the schema, its tables, indexes, views and TSQL procedures in SQL SERVER 2014.

Lead the application development team in providing support & maintenance of data marts and data warehouses. Maintains the integrity of data movement into the data warehouse and other environments.

Maps sources system data elements to target systems and develops, tests, and supports extraction, transformation and load processes – define mapping, sessions and workflow.

Defines and captures metadata and rules associated with ETL processes.

Review and analyze database performance, cubes and reports generated using SQLSERVER 2008 R2 Reporting Services.

Environment: SQL Server 2012/2014/2016, SSIS, Power BI Desktop, Power BI Web, Git Hub, python 3.7, azure portal, XML, HTML.

Broadway Bank San Antonio, TX MSBI Developer Aug, 2016 – Nov, 2018

Reviewed many T-SQL issues using management studio for better performance.

Working on various SSRS reports which are already existed.

Modifying the old reports and adding subscriptions.

Automated old manual reports and getting updated data from app tracker from site location.

Written Unit test cases for chef recipe testing using test kitchen, food critic etc.

Developed SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.

Generated multiple enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database

(OLTP).

SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc. Created reports using Cognos.

Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.

Used Publishing Report Parts feature of newly released SQL Server 2008 R2 and deploy the various report items like charts, maps, images, graphs, tables etc. to the R2 report server along with the reports. Expert in designing reports using SQL server reporting services (SSRS)

& Excel power pivot table base on OLAP Cubes.

Wrote T-SQL queries using inner join, outer join, and self joins, merge join. Also implemented functionality for removing duplicate records like using CTE and ranking function.

Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules.

Utilized T-SQL daily in creating customs view for data and business analysis.

Created subscriptions to provide a daily basis report.

Developed the necessary project plan based on Agile Principles, timelines and schedules related to client' s infrastructure and workflow needs for the scope of the project.

Worked on SSRS in SharePoint Integrated Mode.

Good experience in configuring and supporting clustering, Mirroring and Replication high availability techniques.

Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.

Extracting the data from the different sources (CSV files, oracle, and MS SQL 2000) and stored the data into the intermediate Staging Database using the SSISETL tool.

Transform the data from the staging database and perform the transformation using the Data Flow Tasks. Created SSIS Packages from various data sources.

Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.

Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Built and managed a large deployment of Ubuntu Linux instances systems with Chef Automation and Wrote recipes, tools, shell scripts, and monitoring checks.

Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases. Environment: - Microsoft SQL 2014 and 2012, Parallel Data Warehouse (APS), SSIS, SSRS, Tableau, TFS.

TCS India SQL Developer Aug, 2009 – Oct, 2011

The project aims to help the company migrate from traditional reporting to more dynamic Solutions and to continuously improve overall reporting performance.

Actively participated in gathering Business Requirements that are focused on providing a user-friendly System usage or ambience.

Developed a comprehensive reporting environment utilizing data from multiple sources and creating analysis using SQL Server Reporting Services (SSRS).

Involved in complete SSIS life cycle in creating SSIS package, building, deploying and executing the package in both the environments (Development and Production).

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

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Performed Index analysis for tables and came up with more efficient solutions to use.

Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.

Created and maintained Users, Security Permissions and Migration of the database objects from one server to another server.

Created T- SQL queries for data retrieval. Optimized queries tuned and monitored server performance.

Monitored performance and optimized SQL queries for maximum efficiency.

Created and modified Stored Procedures as per the business logic.

Created other database objects like tables and indexes. Environment: MS SQL Server, T-SQL, Windows Server, Erwin, SQL Server Profiler, Microsoft Business Intelligence Development Studio (BIDS), SSIS, SSRS, DTS, OLTP, XML.

Contact this candidate