SUMMARY

• Over 5+ years of professional experience in the Information Technology field as SQL/ BI developer in MS SQL server 2014/2016/2017/2012/2008 R2/2008 environment covering various domains.
• Vast experience with SQL in understanding DDL, DML, DCL, TCL, and DRL statements.
• Ability to assign different types of keys with their preferred data types.
• Experienced in installing, upgrading, and configuring Microsoft SQL Server and Databases.
• Excellent in writing T - SQL queries, creating clustered and non-clustered Index, Data Cleansing, Data Migration, and using them to alter and build objects.
• Hands-on experience in database normalization, de-normalization, optimization, Tuning, backup, migration, conversion, and document processing using data modeling tools.
• Experienced in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Confident with operators, variables, wildcards, views, triggers in T-SQL.
• Clear cut idea about data warehouse, dimensional modeling, OLAP, RDBMS, and schemas.
• Proficient in creating dynamic packages for Incremental loads and data cleansing in a data warehouse using SSIS.
• Design Change Data Capture (CDC) to capture insert, update, delete activities applied to SQL Server tables, and to make the details of the change available in an easily
• Develop SSIS packages using Change Data Capture (CDC) functionality to truck a change on the data.
• Involve in all phases of SDLC, create detailed analysis-design document with a source to target mapping.
• Develop DataStage jobs to do ETL (load collection of data from multiple sources to different destinations with required business transformation.)
• Experience in maintaining Batch Logging, Error Logging with Event Handlers, and Configuring Connection Managers using SSIS.
• Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, and flat files using connectors, tasks, and transformations provided by SSIS.
• Accomplished in creating Packages, Scheduling Jobs, and sending Alerts using SQL Mail.
• Ability to build data marts and cubes by analysis tool SSAS. Easy to build and deploy analytic solutions for decision support systems.
• Involved in Analyzing, designing, building, and testing OLAP cubes with SSAS.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Ability to measure, edit and compare business data with different queries. Good experience in KPI (Key Performance Indicators) areas.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures
• Experience in Application systems and understanding of how the data resides in the source system to effectively create OLAP Structures to support reporting.
• Excellent experience in developing drill down, cascading, parameterized, Drill through, Sub reports, and Charts using Global variables, Expressions, and Functions for the business users.
• Experienced with visualization tools like Power BI and Tableau
• Experienced in creating Ad hoc reports with complex designs to query the database for Business Intelligence.
• Good Understanding of AGILE methodologies like Scrum, Extreme Programming (XP), and Unified Process (USDP).
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

Databases: SQL Server 2017/2016/2014/2012/2010

Reporting Tool: SQL Server Reporting Services (SSRS), Tableau, Power BI

Integration Tool: SQL Server Integration Services (SSIS)

Analysis Tool: SQL Server Analysis Services (SSAS)

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, DTA

Other Tools: Microsoft Office 2003/2007/2010

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

MS SQL/BI Developer

Responsibilities:

• Requirements gathering, Analysis, and Design of all the client requirements
• Performed Data Modeling and Developed logical and physical model using Erwin and implemented them on SQL server. Designed database, tables, and views structure for the application.
• Created new tables, written stored procedures, triggers for Application Developers, and some user-defined functions. Created SQL scripts for tuning and scheduling.
• Involved in performing data conversions from flat files into a normalized database structure
• Written custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.
• Developing Stored Procedures and Functions used for inserting, updating, or transforming data.
• Developing complex T- SQL queries used for data investigation.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Sourced data from various types of relational databases, flat files, and excel files.
• Created story points for different dashboards involving a lot of category divisions.
• Involved in creating and visualizing dashboards using Tableau Desktop.
• Generated Dashboards by joining multiple complex tables.
• Created SSIS packages using various data transformations like fuzzy lookup, derived column transformation, etc. to migrate the old Bills information, Customer Information, Contracts Information, and other important data.
• Used SSIS to upload amortization schedules sent by the client. CSV format on to the staging tables, which were used for doing all the calculations. Then the data was moved to the core tables and the staging tables were deleted.
• Designed, coded, and implemented ad hoc reports using existing report models in SSRS.
• Identified the Data sources and defined them to build the Data Source Views. parameterized reports using Variables, Expressions, and Functions for the reports
• Managed Alerts for successful or unsuccessful completion of scheduled jobs.

Confidential, Norwell, MA

SQL/ETL Developer

Responsibilities:

• Identified the data sources and created sources to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Performed intermediate queries using SQL, including Inner/Outer/Left Joins and Union/Intersect.
• Pulled data from existing customer databases using views built-in SQL Server, Excel, and CSV flat files.
• Developed complex stored procedures to be used in SSIS 2008 packages to audit the information about the data flow from one stage to other.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load using Visual Studio.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2008.
• Troubleshoot to resolve issues and meet company standards.
• Optimized the queries for efficient data retrieval by implementing indexes on the tables.
• Provided regular reports for both internal and external stakeholders.
• Designed snowflake and star schemas for customer summaries.
• Used complex expressions to group data, and filter and parameterized reports.
• Designed reports and visualizations using MS BI solutions utilizing MS SQL Server, SSAS, SSRS, Power Pivot, Power View, and integration with Excel
• Created linked reports and managed snapshots using SSRS.
• Performed various calculations using complex expressions in the reports and created report models.
• Created reports having actions like URL and bookmarks which helped to easily navigate through the report using SSRS 2008.
• Created many complex ad hoc reports like Tabular reports, parameter reports, and drill through and drill down reports in SSRS.
• Advance knowledge of Autosys Scheduling techniques in Distributing environment.
• Deployed and managed the reports in the Report Manager using SSRS 2008.
• Designed reports subscription schedule for managers.
• Standardized reporting formats and statistical analysis methodologies.
• Visualized nationwide growth with Power Map.
• Used Power query and Power view extensively for mobile data improvements.
• Create predictive models and verified predictive analytics for the business solutions using Rapid miner.

Confidential, Portland, OR

SQL BI Developer

Responsibilities:

• Identified the data sources and created sources to target mapping documents to be used by the packages in SQL Server Integration Services (SSIS).
• Designed and implemented a complex SSIS package to migrate data from multiple data sources.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, XML task.
• Performed Data Modeling and Developed logical and physical model using Erwin and implemented them to SQL server. Designed database, tables and views structure for the application.
• Created SSIS package to extract, validate and load data into Data warehouse.
• Created and modified existing stored procedures, triggers, views, and indexes.
• Design Change Data Capture (CDC) to capture insert, update, delete activities applied to SQL Server tables, and to make the details of the change available easily.
• Creating table indexes and constraints to ensure data integrity and enhance query processing.
• Created traces using SQL server profiler to find long-running queries and modify those queries as a part of Performance Tuning operations.
• Successfully migrated data between different heterogeneous sources such as a flat file, Excel, etc.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Extensively used SSRS to design and subscribe Drill Down, Drill Through, Matrix, cascading parameterized reports to present the billing detail and sale performance of departments and shared them in SharePoint.
• Designed reports subscription schedule for managers.
• Standardized reporting formats and statistical analysis methodologies.

Confidential

MS SQL Developer

Responsibilities:

• Created traces using SQL server profiler to find long-running queries and modify those queries as a part of Performance Tuning operations.
• Successfully migrated data between different heterogeneous sources such as a flat file, Excel, etc.
• Performed review of the business process, involved in requirements analysis, system design documents, flows, test plan preparations, and development of business process and workflow charts.
• Performed database design and implementation using SQL Server and data modeling tools.
• Involved in various data transformation and cleaning techniques like the cast, convert, trim, etc.
• Developed database objects like tables, views, indexes, stored procedures, and common table expressions.
• Involved in writing queries with join conditions, correlated subqueries, and nested queries for business application development.
• Created custom T-SQL procedures to read data from flat files to dump to SQL Server database using SQL Server Import and export data wizard.
• Developed procedures and database triggers for the validation of input data and to implement business rules.
• Developed user-defined functions based on the requirements and used various built-in functions.
• Handled errors using exception handling (try, catch) extensively for the ease of debugging and displaying the error messages in the application.
• Involved in adding, validating, and dropping the XML schema to the database.
• Developed backup restore scripts for SQL Server as needed.
• Resolved any deadlocks issues with the databases/servers on a real-time basis using transaction and locking strategies.
• Created DTS packages for data transfer.