Administrator Associate Data Entry

PROFESSIONAL SUMMARY:

●Over * years of experience in IT with expertise in Data Integration and Report Development using Microsoft SQL Server Integration and reporting tools.

●Experience in implementing various BI/Data Integration Projects on different business domains like Health, Retail, Manufacturing and Telecommunications.

●Expert in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.

●Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.

●Good understanding in database and data warehousing concepts (OLTP and OLAP)

●Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS.

●Extensive experience in Views, Stored Procedures, Cursors and Triggers.

●Experience in migrating data from legacy system (text based files, Oracle, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).

●Experience in developing dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.

●Experience in building ETL processes using SSIS packages by extracting data from various sources such as flat files, Excel files, legacy systems and loading into SQL server.

●Experience in creating Parameterized, drill-down, drill-through, sub-reports, matrix, tabular and Various Charts in Reports using SQL Server Reporting Services (SSRS).

●Good report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.

●Expertise with job scheduling using SQL Server Agent to perform hourly/daily/nightly updates.

●Good communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS

Operating Systems

Windows 8/7/Vista/XP/2003/, Windows Server 2008/2005/2003

Programming Languages

T-SQL, PL/SQL, HTML, XML, Oracle, C, .NET, VB.NET, ASP.NET,

ActiveX, MS Access.

Tools/Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export, Visual Studio, Business Intelligence Development Studio(BIDS), Crystal Reports 9.0, ETL, IIS, Snowflake

Database Design Tools

MS Visio, MS Access, MS SQL Server 7.0/2000/2005/2008/2008R2/2012/2014

BI Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Power BI, Oracle ublisher,, MS Visio, Erwin, Crystal Reports 9.0/XI, SAP Business Objects

Software

MS Office Visio, MS-Project 2000, MS Office

Other Tools

JIRA,TFS, FTP, GIT, Snowflake, Genk ins, FileZillah, Loadrunner, Tomcat, MS Office like MS Word, MATS,MS Excel, MS Project, MS power point, Auto cad, 2020, and MS Outlook

PROFESSIONAL EXPERIENCE

CoreLogic - Columbus, OH Jan 2021 till Date

ETL/SSIS/SQL Developer

Responsibilities

●Extensively worked in creating ETL SSIS packages both design and code to process data to target databases.

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

●Worked on SQL project where SCD type2 data is provided to the end user after capturing and analyzing the changes on the required data in a defined time frame.

●Identify and resolve problems encountered during both development and release of the SSIS code.

●Strongly worked in debugging and troubleshooting the technical issues while implementing the applications.

●Created Packages for extracting data from Flat Files, Excel, MS Access, Oracle and MS SQL Server 2014

●Created packages in SSIS with error handling and worked with different methods of logging in SSIS

●Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging and Production environments.

●Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.

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

●Used ETL to implement Slowly Changing Dimension to maintain historical data in Data Warehouse.

●Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

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

●Responsible for loading data from Data feed to Data Warehouse tables.

●Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

●Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

●Created views to display required information on user interface, and triggers to validate consistent data entry into the database.

●Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Tabular, Matrix, Drill Down, Drill Through and web reporting.

●Designed different kinds of reports from scratch depending upon the requirements of the markets, vendors, providers and scanners.

●Documented all the work and all the process of integration and reporting services for further references

●Worked extensively on system analysis, design, development, testing and implementation of projects (Complete SDLC).

●Hands on Experience in creating Star Schema and Snow Flake Schemas

●Expertise in SQL server integration services(SSIS) and SQL server Reporting Services(SSRS) with good knowledge on SQL server Analysis Services (SSAS)

●Designed Cubes with star schema using SQL Server Analysis services 2008 (SSAS) created several dashboards and scorecards with key performance indicator (KPI)in SQL server 2005 Analysis Services (SSAS)

●Exensively involved in the SSAS storage and partitions, and aggregation, calculation of queries with MDX datamining models, developing reports using MDX and SQL

●Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).

●Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.

●Developed, analyzed, and evaluated information/data to create and maintain business intelligence that supports the strategic objectives of the outreach team.

●Experience in migration of on-premises SQL server to azure sql database (paas) on clound

●Experience in azure sql configuration for the database and automation of tuning, vulnerability assessment auditing and threat detection

●Good knowledge and experience on cloud computing like azure/AWS

Environment: MS SQL Server 20014/2012/2008R2, SSRS, SSIS, SQL Query Analyzer, SQL profiler, Power BI, Windows Server 2003/2008, DTS, Share Point Portal Server, HTML, XML, C#, .Net, ASP.NET, Visual Studio 2005/2010/2015/2017, MS Access, Crystal Reports 2013, MS Excel 2007.

Client: DCCA, Ellicott City, MD Sep 2018-Dec 2020

Role: MS SQL Server Developer/SSIS/SSRS

Responsibilities:

●Provided assistance for optimization and performance tuning of DB2 SQL and stored procedures.

●Created stored procedures, functions, views and other database objects.

●Performed performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

●Assisted in designing and development of DB2 and Oracle server and database objects.

●Worked with business users and stakeholders to gather or refine requirements.

●Designed databases and relevant objects through preparation of tables, groups and indexes.

●Deployed database objects from development/testing environment to production environment.

●Supported end users to resolve issues and assisted users on existing database applications.

●Provided assistance for optimization and performance tuning of DB2 SQL and stored procedures.

●Successfully created schema change scripts to existing objects to synchronize with changing business rules.

●Wrote complex stored procedures to process prospective customer information and balanced the processing load between frontend and backend.

●Involved with full development cycle of a Data Warehouse, including requirements gathering, design, implementation, and maintenance.

●Developed Complex SSIS Packages to load data into Staging, ODS, and Data Warehouse systems.

●Developed SSIS packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups, and Derived Columns with Multiple Data Flow tasks.

●Developed SSIS package to load data into dimensions and fact tables using slowly changing dimension.

●Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.

●Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases. Involved in Extracting, Transforming and Loading (ETL) data from Excel, Flat file to MS SQL Server by using SSIS services.

●Developed periodic SSRS reports in BIDS used to generate daily, weekly, monthly and quarterly reports.

●Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using Cross-checked the SQL Server is online and that still have connectivity with the front end applications and functionality, making sure a 24/7 availability. Collaborated with multiple application owners addressing various issues.

●Routinely checked the SQL server error logs for failed or aborted overnight jobs.

●Monitored growth of database objects for capacity planning.

●Supported multiple high availability technology SQL server 2008R2 clustering (active - active), Log shipping Mirroring between multiple locations on both development and Production environment size over 1TB.

●Reorganized\rebuild Indexes to meet standards index fragmentation level to keep below 30% so as to improve Query Performance.

●Migrate Clients Image data with a vendor-neutral archive(VNA)which is an enterprise-class data Management

●Convert and migrate customer legacy database using SQL server 2014 tools(SSIS)

●Provide technical documentation of the data migration project for different clients.

●Involved in creating sub reports on dashboard, linked reports, charts, snapshot reports, dill through, and report models drill down reports using a cube.

Tools & Technologies:

SQL Server 2008R2/2012, BIDS, IBM, Visual Studio 2010/2008, T-SQL, MS Access, MS- Excel, SSIS, SSRS, SSAS, Report Builder 2.0/3.0,Power BI

Key Creative – Longview, TX Jun 2015 – Aug 2018

Role: SQL Server TSQL/SSIS/SSRS

Responsibilities:

●Involved in gathering user requirements, application design and analysis of hardware requirements to meet business needs.

●Designed and developed web based ecommerce application.

●Worked with Oracle Server to extract, load information of Customers.

●Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.

●Wrote standard & complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results based on business requirements.

●Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.

●Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

●Accountable for Backup and Recovery Strategy and Planning.

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

●Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.

●Applied various data transformations like Slowly Changing Dimension (SCD), Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.

●Used Packages by testing and cleaning the Standardized Data by using tools in Data.

●Data flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing and new packages.

●Involved in scheduling SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers.

●Logged various packages as well as individual tasks using SQL server log providers like text file, SQL server database, trace file, xml file.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008R2.

●Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008R2.

●Generated daily, weekly and monthly reports for the managers.

●Used sub reports functionality for complex report calculations.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008R2.

●Responsible for database tuning using normalization and application tuning.

●Documentation for all kinds of reports and SSIS packages.

Tools & Technologies:

MS SQL Server 2008/2019 R2, T-SQL, SQL server Integration service 2008 R2, SQL Server Reporting Service 2008 R2, Erwin7.3, Query Analyzer, Index Tuning Wizard, and SQL Profiler Windows Server 2003.

EDUCATION: Degree in Information Technology

Microsoft Certified: Azure Database Administrator Associate Microsoft Certified: Azure Database Administrator Associate

Contact this candidate