PROFESSIONAL SUMMARY:

• A Microsoft certified professional with 8+ years of total IT experience in teh design, modeling, development, implementation and support of SQL Server 2014/2016/2019
• Experienced Support Leads to provide Application Support within teh Finance and Risk portfolios.
• Application Support professionals provide excellent customer service in addition to resolving issues.
• Resolve customer technical issues through diligent research, reproduction, and troubleshooting.
• Expert in analyzing designing development, installing, configuring and deploying SSRS, SSAS, SSIS, Power BI.
• Experience in maintain one - to-many and many-to-one relationships while moving data between two databases.
• Experience in using CTE, temp tables and effective DDL/DML trigger to facilitate efficient data manipulation and data consistency as well as to support teh existing applications.
• Expertise in writing T-SQL queries, dynamic, sub-queries and complex joins for generation complex stored procedures, user-defined functions, view and cursors.
• Extensive noledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.
• Skilled in error and event handling precedence constraints break points, check points and logging.
• Extensive experience in developing Drill through and Drill down reports, parameterized reports, Linked reports, Sub reports, Matrix reports, and Chart reports using MS SQL Server Reporting Services (SSRS)
• Strong experience in designing and developing large number of reports in SSRS using teh data from ETL Loads
• Experience in using SSIS tool like import and export wizard, package installation and SSIS package designer.
• Experience in ETL process involving migrations and in sync process between two databases.
• Experience in Building cubes using SSAS.
• Defining data warehouse (star and snow flake schema), fact table, cubes, dimensions, measures using SSAS.
• Highly proficient in working with users to gather requirements, analyze them, and subsequently use design tools to model teh requirements.
• Ability to handle multiple tasks, initiative and adaptable, self-motivated, organized team player with strong problem solving and analytical skills and total commitment to teh organization goals.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS:

RDBMS : MS-SQL Server

ETL : SQL Server Integration Services, Data Transformation Services -TSQL, TSQL SSAS, SSRS

Languages : SQL, C#, XML

Tools : SQL Visual Studio, SQL Management Studio, Excel Pivot, SharePoint

Office Tools : MS Word, Power Point, Excel

Domain Expertise : Marketing/Sales, Insurance, Health, Financial

Others : Data Analysis, Data Validations, Database Maintain, Error Handling

PROFESSIONAL EXPERIENCE:

Confidential

SQL SERVER SSIS/SSRS / Power BI / ETL Developer

Responsibilities:

• Ensures daily/monthly data feeds are received on time, with proper follow up conducted for missing information
• Applies noledge of teh product supported and it’s processes, such as, payment methods, terms and conditions, general operating policies, rules and regulations used by correspondents, clients and their agents in teh day to day reconciling of accounts
• Recognize that accuracy is key to ensure true breaks are identified and investigated accordingly
• Identify and initiate investigation cases on items that represent a potential loss to teh Bank Display a strong commitment to teamwork; open two-way communication and good staff morale
• Seek opportunities to share information with colleagues
• Identify departmental system or process changes to streamline and/or improve teh reconciliation process and efficiency (matching rules, automating processes)
• Gathered requirement from End User and converted into TSQL Query to get teh data from SQL Server.
• Created Stored Procedures, Triggers, Function, CTE, Temp Tables, Views, Joins, and so on as per teh requirement.
• Optimized teh existing Stored Procedures according to teh Technical Specifications and performed Troubleshooting on teh existing Stored Procedures.
• Generated SSRS Reports by using SSRS Report Builder and schedule as per teh End User’s requirement.
• Designed and developed stored procedures, queries and views necessary to support SSRS reports
• Automated and monitored SSRS Reports such as Simple Report, Cascading Parameterized Report, Drill Down, Drill Through, and so on to teh End User by using Report Builder.
• Designed and developed SSIS packages to move data from production environment to different environments within teh organization.
• Extracted data from different sources like Excel, Flat Files, CVS Files, Oracle etc., transform and load into a Centralized Database destination by using SQL Server Integration Services (SSIS) Packages.
• Responsible for Creating, Monitoring and Deploying SSIS Packages in daily basis.
• Automate teh SSIS packages in SQL Server Agent and created teh alert to notify teh status of teh jobs to teh team.
• Experience on making teh package dynamic by creating package configurations such as XML.
• Performed Unit Testing on Reports, and monitored teh Performance of teh Reports.
• Provided ongoing Technical Support in teh Production Environment.

Environment: MS SQL Server 2016 (SSIS, SSRS), T-SQL, SQL Profiler, Report Builder 3.0, Oracle, MS Excel, Window 2007.

Confidential, Dallas, TX

SQL SERVER SSIS/SSRS / ETL Developer

Responsibilities:

• Installation of MS SQL enterprise servers on test and development boxes.
• Designed and Created databases, tables, views, stored procedures and triggers.
• Created groups, roles, users and assigning access privileges to users.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
• Monitored and scheduled existing/new jobs on production environment.
• Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
• Tested backup and recovery strategies in a test environment before and after moved to production environment.
• Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
• Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services (SSIS).
• Developed 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.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS and Power BI
• Using Power Query to extract, transform and load data into Excel and/or Power Pivot directly.
• Using Data Analysis Expressions (DAX) to solve a number of basic calculation and data analysis problems.
• Designed OLAP cubes with star schema and multiple partitions using SSAS.
• Understanding teh OLAP processing for changing and maintaining teh Warehousing Optimizing Dimensions, Hierarchies and adding teh Aggregations to teh Cube.

Confidential

SQL SERVER SSIS/SSRS / ETL Developer

Responsibilities:

• Performed analysis and presented results using SQL, Logic Analytic, and MS Excel
• Extract Transform and Load data to multiple destinations using SSIS
• Reviewing all ongoing work out plans with customers, evaluating their needs and issues, by creating Business Requirement Documents .
• Used tools (Excel and SQL) to analyze, query, sort and manipulate data according to defined business rules and procedures.
• Experience in configuring SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix teh errors
• Coordinated with DBA in creating and managing Tables, Indexes, Triggers, DB links and Privileges.
• Maintained data integrity by Creating checks and constraints.
• Involved in creating new databases, performance tuning, deploying, scheduling and creating reports. This included writing T-SQL backup and created various operational, drill-through and dynamic reports using SSRS.
• Interpreted business needs and developed code
• Involved in Technical decisions for Functional requirements, Data Mapping, Data Directory. Interaction with Business Analysts, Client team, Development team
• Created and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
• Worked with different Control flow tasks in creating SSIS packages especially For Loop and For Each Loop containers with Execute SQL and Script Tasks.