SUMMARY:

• Over 4.5years of experience in Information Technology with solid working experience as SQL server Developer with SSIS, SSRS, and SSAS mainly in Sales & Telecom Domains.
• Skilled in writing and reviewing T - SQL code DDL, DML, DCL and maintaining coding standards.
• Experienced in writing complex T-SQL Queries, Stored Procedures, Triggers, Views and Indexed Views, User Defined Functions, CTE’s, Latest Date Functions, Table Variables to implement business logic.
• Strong knowledge and experience with Relational Database Management Systems, including E/R Diagrams, Normalization, Constraints, Querying, Joins, Keys, Indexes, and Data Import/Export.
• Experience in Error handling and debugging coding issues using Try Catch Block and error methodologies for troubleshooting coding issues.
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans.
• Expert in Extracting, Transforming and Load data (ETL) from various heterogeneous sources and creating packages using SSIS, Import & Export Data, Bulk Insert and BCP utilities.
• Developed SSIS packages for importing and exporting data from various Databases like MS Excel, Flat files, Teradata, Oracle, DB2.
• Building and modifying the structure of the tables and executing the DDL statements, Using Primary key and foreign keys.
• Expert in creating custom Logging and Event Handlers for error handling in SSIS packages.
• Experience in converting ETL packages from legacy systems (DTS and SQL 2000 code) and migrating to Latest SSIS versions, deploying the packages across Dev/UAT/Prod environments.
• Expertise in creating Cross-Tab, Drill-down and Sub-Reports using SSRS RDL and promoting RDLs to Reporting Services Server.
• Wrote and integrated stored procedures to generate the SSRS reports.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, writing named queries, calculations members using expressions, creating perspectives and actions for users and Deploying and Processing SSAS objects.
• Strong team player with ability to prioritize workload.
• Very good understanding of the project development life cycle, estimating project-hours, writing project Implementation plans, and preparing back up plans.

TECHNICAL SKILLS:

Programming Languages: T - SQL, PL/SQL, C -Language

Databases MS SQL Server 2014/2012/2008 R2, Teradata V14/15, Oracle11i MS Access 2000, DB2, SQL*PLUS.

Database Tools: SQL Management Studio, Data tools (SSIS/SSRS/SSAS), SQL Server Enterprise Manager, T-SQL, DBCC, BCP, SQL Server Profiler, SQL Server Query Analyzer, Import/Export tools, SQL Server Agent, oracle enterprise manager and TOAD.

Reporting Tool: SSRS, Excel, Tableau.

Tools: Microsoft Visio, Data tools (SSIS/SSRS/SSAS),Visual Basic 10.0,HP Quality Center.

Version Control: Visual Source Safe 8.0, Windows SharePoint Services.

Operating System: Windows 2012 R2/2008/ Windows 7/8/WIN 10.

PROFESSIONAL EXPERIENCE

Confidential, Dallas

SQL/ MSBI Developer

Responsibilities:

• Gathering new requirements from the users and preparing the BRD’s and HLD’s.
• Communicating with users to understand the functional and technical specs.
• Understanding BRD, Gathering requirements from users and mapping them to development.
• Developing Complex SSIS Packages for Data Migration, Incremental Loads, and SCD’s using control flow and data flow toolbox components.
• Created SSIS packages for loading incremental data on weekly and Bi-Weekly basis
• Transforming the SSIS packages according to the Client requirements with required business Logics.
• Involved in designing SSIS packages for data mart for sales and partner channel subject areas of ODS and DW. Integrated data into ODS and cleansed it to move to Data mart using SSIS.
• Developed complex SSIS packages to transform raw data into business data from various sources like Flat files, Teradata, SQL Server to SQL Server database stage area .
• Developed SSIS Packages to run the Batch scripts and FTP (File Transfer Protocol) to other servers using UNIX and DOS commands.
• Configured packages for sending automatic mails to the respective Groups when a SSIS process failure or success.
• Enhancing and deploying the SSIS Packages with new logics or enhancements and deployed them from Development server to UAT and Production server.
• Extensively developed SSAS Cubes, Partitions, Aggregations, KPI’s and Browser perspectives.
• Creating SSRS Reports from Pre-built Cubes for Business Users. Assigning access approvals to the new users for SSRS reporting website.
• Involved in creating SQL server logins, creating roles, granting privileges, unlocked accounts, reset passwords for developers and users.
• Responsible for Database backups &Restoration, Backup policies, scheduling backups.
• Tuning and optimization of T-SQL Queries using Execution plan, tuning advisor based on Change request management.

Environment: Windows 2012 R2/2008/2003 Server, SQL Server 2014/2012/2008 R2, Data tools (SSIS, SSAS, SSRS), .NET Framework 4.5, VB10, TERADATA VR14/15 MS Excel, Visual Studio.

Confidential, CT

ETL/SQL Developer

Responsibilities:

• Requirements gathering from the end users perspective and preparing the final HLD’s and BRD’s.
• Understanding BRD, Gathering requirements followed by enhancements from users and mapping them to development.
• Created complex SSIS packages extensively for data loads and business logics implementation.
• Worked on different tasks in control flow like Foreach loop container, Execute process task, execute SQL tasks to implement the business needs and all the DDL and DML commands.
• Configured Server for automated notification process in SSIS packages after the process completion.
• Enhancing and deploying the SSIS Packages from Development server to UAT and Production server.
• Involved in dealing Service level information and Account level information for implementing them into the final web page of Confidential telecom management enterprise).
• Responsible for creating & Enhancing Stored Procedures, Views, Tables & T- SQL Scripts.
• Created complex Store Procedures using System and user defined functions.
• Generated various plans for QA testing of developed T-SQL queries for data retrieval and analyzing the outcomes.
• Identified the database tables and attributes for defining the queries and embedding them to the SSIS packages accordingly.
• Generated plan for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations.
• Created groups, roles, users and assigning access privileges to users in SSIS packages.
• Involved in deploying SSIS packages and SQL’s to different environments like UAT, Production after development process using security levels.
• Scheduled SSIS packages and T-SQL Store procedures on SQL agent to kick off on Production schedules accordingly.
• Created Production deployment and packages documentation.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Extracted Data using SSIS from DB2, XML, Oracle and flat files, Excel perform transformations and Populate the data warehouse.
• Extracted and integrated the data from SAP.
• Scheduling and monitoring the ETL packages for daily load in SQL Server job Agent.

Environment: Windows XP/2003 Server, MS SQL Server 2008 R2, MS SQL Server Integration 2008/2005, MS Excel, Access, Visual Studio, BIDS, Visual Source, Subversion (SVN).

Confidential

SQL/ MSBI Developer

Responsibilities:

• Involved in understanding Business requirement document and developing Technical Design specification documents for multiple interfaces.
• Identified various source systems for data feeds.
• Used SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Designed and developed jobs for loading data to star schema.
• Extracted Data using SSIS from DB2, and flat files, Excel transformations.
• Populate the data warehouse. Worked on SSIS to remove duplicate records with data standardization.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Created various Jobs, Alerts and Events, Created Backups for databases and automated the process. Assisted in building dimensional cubes with SQL Server Analysis Services (SSAS) and building multiple calculated members, KPI’s for user perspectives.
• Worked as a developer in creating complex Stored Procedures, tables, and views and other SQL joins and statements using T-SQL for different applications.
• Managed index and optimized queries using execution plan.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Involved in the Analysis of the Report Data, Developed and Deployed Reports on to the Reporting Server. Wrote and integrated stored procedures to generate the reports.
• Created Cross-Tab, Drill-down and Sub-Reports using RDL and promoting RDLs to Reporting Services Server.

Environment: SQL Server 2012/2008 R2, T-SQL, PL-SQL, SSIS, SSAS, Power Pivot, MS Access, SharePoint server, Windows 8/7.