SUMMARY

• 5+ years of experience in IT industry performing Database Administration, Design and Development using SQL Server 2008 R 2/2012/2014/2016.
• Expertise working with SQL Server 2008 R2/2012 tools Such as Management Studio, Query Analyzer, SQL Profiler, SQL Agent, SSIS and SSRS.
• Experience in data Normalization and Data Modeling using Erwin and generating mapping documents.
• Extract Transform Load ETL development using SQL Server 2014, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS.
• T - SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL Server 2008 R 2/2012/2014.
• Expert in generating on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), Tableau and POWER BI.
• Solid knowledge of Power BI and Tableau Desktop report performance optimization.
• Experience with Ad-hoc reporting, parameterized, custom reporting using SSRS for daily Ad-Hoc reports.
• Configured and administer BPA Business Process Automation for designing ETL workflow and including multiple packages within the workflow
• Documenting all ETL projects and workflows by using Bi Documenter and including supporting documents for troubleshoot for each project.
• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Working with new data quality services DQS in SQL 2012 as part of creating rules for data mapping and data cleansing.
• Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
• Experience in Data Migration by using side-by-side upgrade process Management.
• Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions. Implementing SQL Server security and Object permissions.
• Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace, and 3rd party tools.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.
• Managing Production Server and Development server for SCCM Reporting.
• Have experience in Performance Tuning, T-SQL Query Optimization and Solving Blocking issues.
• Experience in Query Tuning by Using Execution Plan, query analyzer and tuning advisor.
• Good understanding and knowledge of Relational Database Management Systems RDBMS
• Migrated DTS Packages to SSIS using various versions of SQL Server.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Involved in projects on claims domain to coordinate and gather requirements.
• Installation on Azure Data Factory gateway, Microsoft Power BI gateway, Power BI desktop.
• Created shell scripts to run daily jobs and extract the files from remote location for data loads.
• Good Knowledge of Web development technologies such as HTML, XML, DHTML and Visual Studio 2008/2010/2012 /2014.
• Highly organized with the ability to manage multiple projects and meet deadlines.
• A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS

RDBMS/DBMS: Microsoft Access, SQL Server 2008 R2, and SQL Server 2012, 2014, 2016

Software/Databases: MS SQL Server 2008RS,2012 MS SQL Server Reporting Services 2008/2012/2016 (SSRS), MS SQL Server Analysis Services 2008/2012 (SSAS), MS SQL Server Integration Services 2008/2012(SSIS), ODBC, OLTP, OLAP, SQL Server Management studio (SSMS), MS SQL Server 2000 Enterprise Manager, SQL Query Analyzer, SQL Profiler, PerformancePoint Server

Development Environments: Microsoft Visual Studio Team System 2008/2010/2012 , Microsoft SQL Server 2008/2012/2014 , ORACLE, POWER BI, Tableau, Excel, Smart Sheet

Programming Languages: Experienced in Transact-SQL (T-SQL), XML, VB 6.0, and C#.

Operating Systems: Windows XP/7/10

Technologies: Microsoft Business Intelligence, SharePoint

Others: MS Office Suite, SVN (Subversion), BMC Remedy, JIRA

PROFESSIONAL EXPERIENCE

SQL/ETL Developer

Confidential

Responsibilities:

• Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Designed, developed, and tested various Power BI and Tableau visualizations for dashboard and ad-hoc reporting solutions by connecting from different data sources and databases.
• Expert in connecting multiple data sources in Power BI to implement working reports. Expert in creating multiple kind of Power BI Reports and Dashboards.
• Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.
• Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.
• Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.
• Responsible for creating reports based on the requirements using SSRS 2014 and Defined the report layout and identified datasets for the report generation.
• Extensive experience in developing ETL mappings, scripts and data integration using Informatica Power Center 9.x/8.x/7. x.
• Created different types of reports including financial reports, crosstab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.
• Developed, implemented, and maintained various database objects such as stored procedures, triggers, functions, indexes, and views.
• Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.
• Worked Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.
• Used VSS to store, run, view, edit and revert to different versions of the design in case of a version control.

Environment: MS SQL Server 2008/2012/2016 , SQL server integration services 2014, Oracle, Power BI, SQL server Reporting Services 2014, VSS visual source safe, .NET Framework, ASP 3.0, Microsoft Visual Studio 2012/2014, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

SQL/SSIS Developer

Bank of the West

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• Diligently worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.
• Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Experienced in ETL Informatica & Database Upgrade Testing.
• Effectively worked in Informatica version-based environment and used deployment groups to migrate the objects.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Assisted on the Ad-hoc Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.
• Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.
• Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.
• Developed T-SQL for maintaining, developing, and creating database and fine tune Stored Procedures and Queries to improve performance of system.
• Understand business and how their claim data will be analyzed.
• Proficient in creating and tuning database, developing views, and having good exposure of C and .NET Framework.
• Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.
• Involved on creating SQL Data warehouse, Analysis Services, Azure Data Factory.
• Developed, monitored, and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS SQL server reporting services and SSAS.
• Created Azure Data Factory Pipeline to load data from On-premise SQL Server.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA server and Production server.
• Created schemas, keys and indexes considering the granularity of the data

Environment: Informatica PowerCenter 8.1, MS SQL Server 2012/2014 R2, SSRS, SSIS, SSAS, DB2/UDB 9.5, .NET Framework, C, ASP.NET, Windows 10 Advance Server, HTML, XML, MS Excel, MS Access.

SQL/SSIS/SSRS Developer

Confidential

Responsibilities:

• Extract Transform Load ETL development using SQL Server 2005, SQL server 2008R2 Integration Services SSIS and SQL Server 2008R2 Reporting Services SSRS.
• Captured Plan information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to providing a record of all plan changes and optimizing query based on results.
• Developed and maintained ETL packages SSIS Packages to extract the data from various sources and involved in debugging and upgrading of several ETL structures as per the requirements.
• Build Development Server for Reporting and creating SCCM Reports Based on infrastructure needs. Publishing Reports on Reporting Server and Share point portal.
• Used Informatica as ETL tool to pull data from source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Developed Power BI reports using Power Query from SharePoint & different Data sources.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Managing Production Server and Development server for SCCM Reporting.
• Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Formatted the reports using the Global variables and expressions. Managed security by defining roles and rights.
• Manages the implementation and support of SQL Server 2008R2 and SCCM across multiple applications.
• Experience in data migration using tools like DTS, Bulk Insert, BCP and Replication between different homogeneous and heterogeneous systems and SQL Server.
• Working knowledge of disaster recovery and high availability solution like replication, transaction log shipping, mirroring, and clustering.
• Created notifications and alerts, subscriptions to reports in the Power BI service
• Experience in publishing the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets
• Monitored the database server performance and if required go for tuning of the T-SQL queries, stored procedures etc. Proven ability to handle database of more than 500 GB in size.
• Conducted root cause and analysis for database incidents and problems. Provide 2nd and 3rd level support and rotating on-call support.
• Monitored data activities i.e. database status, logs, space utilization, extents, checkpoints, locks, and long transactions.
• Developed and maintained scripts, utility jobs or implement needed software for database maintenance.

Environment: Informatica Power Center 7.1.x, MS SQL Server 2008 R2, SQL server integration services 2008 R2, SQL server Reporting Services 2008 R2, TFS, ASP.Net4.5, MVC 4.0 Framework, Microsoft Visual Studio 2008/2010, SQL Server Management Studio, MS Excel, T-SQL, SCCM 2007 Console, SQL Sentry Power Suite Performance Advisor for SQL, Report Builder 2.0/3.0.