SUMMARY:

• Data Analyst/BI developer with good knowledge of SQL Server tools and solid understanding of data warehouse structure.
• Experienced in data extraction, transformation and loading (ETL) between homogenous and heterogeneous systems using DTS and SSIS of MS SQL Server 2016 SQL Server 2008 and 2012.
• Expertise in designing, Configuration, deployment and scheduling SSIS Packages for transferring.
• Experience in migration of Data from various Data Sources such as Excel, Flat file, Oracle, DB2 to MS SQL Server by using SQL Server Integration Services, DTS utility.
• Experience in Enterprise Data Warehousing and Data Mart in OLTP/OLAP environment.
• Experience in enhancing and deploying the Packages from development server to production server.
• Expertise in building script using Transact - SQL (DDL and DML).
• Knowledge of creating Indexes to achieve better query performance and experienced in implementation of strong referential integrity and auditing by the use of triggers and SQL Scripts.
• Good knowledge on creating tabular reports, matrix reports and sub reports using global variables, expressions, and functions, sorting the data, defining data sources and subtotals for the reports using SSRS 2012.
• Use of business intelligence platforms for reporting such as SQL, SSRS, and SSIS.
• Quick learner with strong analytical and critical thinking skills.
• Ability to work and meet deadlines with results-oriented, flexible, and adaptive approach to problem-solving.
• Well-organized, effective, highly motivated and always willing to learn new things.

TECHNICAL SKILLS:

Databases: Microsoft SQL Server 2008, 2012/ ETL/ Languages

Databases: MS-SQL Server 20014/2012/2008 R2/2008

BI Tool: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), T-SQL Stored Procedures, basic knowledge of SSAS creating cubes and dimensions, Tableau desktop, Tableau server

Languages: SQL, T-SQL, basic knowledge of C#

PROFESSIONAL EXPERIENCE:

SQL/ BI Developer

Confidential, Dallas TX

Responsibilities:

• Extracted data using SSIS packages (ETL) from different server locations and data sources
• Worked with integration services for transferring and reviewing data from heterogeneous sources like Excel, csv, flat file, text format data
• Used different type of Transformations for Data Conversion, Sorting and cleaning the data from different sources into Company format.
• Created Package Configurations, Event Handlers for On Error/Warning/Task Events.
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Used various data flow transformations like Lookup, Derived Column, Row Count, Data Conversion, Conditional Split, Merge join, Sort, Aggregate, Pivot, OLEDB command, Union all etc. to map the data between different data source and to perform transformation according to the business requirements.
• Created packages using script task, containers to logically execute the SSIS package to improve performance and execution time.
• Handled Performance tuning of the developed packages to ensure faster data loads and accuracy.
• Worked in debugging complex packages using Error handling methods like Break Point and Check points.
• Handled package migration from development server to production server using package configuration.
• Developed many tablix, tabular, matrix, and drilldown reports as well as charts using SQL Server (SSRS)
• Modified existing reports according to requirements of end users
• Deployed and generated daily/weekly/monthly reports into Report Builder to access through browsers
• Designed and implemented parameterized reports using SSRS
• Generated various reports like cascade type reports, tabular reports, and drilldown reports
• Involved in writing SQL queries, views and stored procedures on SQL Server 2012
• Modified existing T-SQL stored procedures, triggers, functions, indexes, tables, views and SQL joins
• Collected business requirements from users and translated them as technical specifications and design documents for development
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
• Dimensional Data Modeling using Star and Snowflake Schemas for Fact and Dimension tables.
• Involved in optimization of Data Models using Kimball Methodology.
• Wrote T-SQL Scripts to create datasets to perform reporting and included interactive drilldown reports, report models, KPI’s and Dashboard/Scorecard reports.

SQL Server BI (SSIS /SSRS) ETL Developer

Confidential, Dallas, TX

Responsibilities:

• Extracted data from various sources like SQL server 2005/2008/2012, Oracle, CSV, Excel and text file from Client servers and through FTP.
• Designed and Developed SSIS Packages using various Control Flow and Data Flow items to Transform and load the Data from various Databases.
• Experience in configuring with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Involved in source Data Analysis, Design and Creation of Data Mappings for Extraction of bulk data from heterogeneous sources like Oracle and other OLEDB data sources.
• Designed SSIS packages to bring data from OLTP databases to the new data warehouse by performing different transformations like Lookups, Merge Joins, Derived Columns, Merge Join, Conditional Split, data Conversion with Multiple Data Flow tasks.
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Developed 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.
• Analyzed Performance tuning queries by looking at the Indexes, appropriate joins and Queries.
• Developed Tables, Indexes, Views, complex stored procedures, Triggers, Functions.
• Built Drill Down, Drill through, linked and sub-reports using SSRS 2008.
• Created Report Email Subscription using Data Driven and Time Driven Report Subscriptions.
• Dimensional Data Modeling using Star and Snowflake Schemas for Fact and Dimension tables.
• Involved in optimization of Data Models using Kimball Methodology.
• Wrote T-SQL Scripts to create datasets to perform reporting and included interactive drilldown reports, report models, KPI’s and Dashboard/Scorecard reports.