SUMMARY

• Over 6+ Years of IT professional in database Design and Development on Microsoft SQL Server 2005/2008/2012/2016 , T - SQL, Performance Tuning, Troubleshooting, SSIS, SSRS, SSAS and Data-warehousing.
• Full Software Development Life Cycle (SDLC) experience including Analysis, Design and Review of Business and Software Requirement Specifications
• Experience with Amazon Web Services including EC2, VPC, S3, EBS, Cloud Watch
• Expertise in Transact-SQL (DDL, DML, DCL) and in Design and Normalization of the database tables.
• Created and updated database objects like Complex stored procedures, joins, tables, User Defined functions (UDF's) for business logic.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Migrated old data from MS Access into SQL Server 2012 using SSIS Packages.
• Designed and developed ETL packages to validate, extract, transform and load data from OLTP systems to the Data warehouse.
• Worked on all activities related to the development, implementation and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked with control flow and data flow tasks like Containers, Precedence Constraints, and Execute SQL task in SSIS.
• Having SSAS - Working knowledge of SSAS using tabular.
• SSRS - Reporting using parameters, Subreports, Drill down Reports, expressions and report development using Tabular modeling SSIS - Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems.
• Used Script task for Data Flow and Error Handling in SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Created SSIS packages using Conditional Split, Aggregate, Merge, Multicast, Term extraction Data Conversion, Fuzzy Lookup, Pivot, Lookup.
• Created logging for ETL load at package and task level to log number of records processed by each package and task in a package using SSIS.
• Implementation experience in running and scheduling SSIS.
• Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
• Hands-on in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the manager.
• Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS)
• Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Ability to work closely with the client to understand requirements and get it done from individually
• Strong experience in design and construction of data views. Experience in Building Multi-Dimensional Cubes, Data Modeling, and OLAP Cubes using SSAS.
• Involved in building Dimensional Cubes with SQL Server Analysis Services (SSAS) and querying the data with MDX script.

TECHNICAL SKILLS

Cloud Technologies: Microsoft Azure

Databases: SQL Server 2008/2012/2014/2017 , Azure (Cloud Server), Access, MySQL, Oracle 10g, 11g,12c.

Programming Languages: T-SQL, HTML, XML, PowerShell, VB.NET, ASAP.NET

BI Tools: SSIS, SSAS, SSRS, Power BI

Operating Systems: Windows Server 2003, 2007, 2010, 2013, Windows 8/NT/XP/Professional, MS- DOS, Red Hat Linux

Version Control: TFS/GIT/SVN

Languages: T-SQL, PL/SQL, C/C++, HTML, XML, VBScript, C#.Net, VB.Net, ASP.Net, ADO.Net, ActiveX, XML, MS Access, HTML, DHTML, Shell Scripting

Tools: SQL Server Enterprise Manager, Management Studio

PROFESSIONAL EXPERIENCE

Confidential, Alexandria, VA

Sr. SQL Developer

Responsibilities:

• Responsible for creating a Data warehouse for the organization as part of the migration project from IBM to Microsoft SQL Server.
• Created SSIS packages to load data from flat files, csv and excel files in to the staging tables.
• Created T- sql objects to load the data from the staging tables to the transaction tables.
• Responsible for creating the datamart for various domains.
• Creating SSIS pacakges to send the data in flat files to various vendors .
• Working with the Business Analysts to gather the requirements and working witht them on the mapping document.
• Monitoring the the production Jobs and working working on post production tickets (defects) and enhancements.
• Working with the business to create SSRS reports by extracting data from the data mart.
• Implementing OLAP cubes (Star Schema) for the business users.
• Solely Reponsible for deployment of objects (T-SQL, SSIS, SSRS) to all the regions(DEV, INT, ACC, PROD).

Confidential, St.Louis, MO

MSBI Developer

Responsibilities:

• Creating SSIS packages to extract data from various sources to load them to data warehouse using various transformations.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered Index) tables.
• Responsible for monitoring the jobs deployed on to the server and also trouble shooting the same.
• Responsible for migration from SQL Server 2012 to SQL Server 2014.
• Working on service tickets (service - now) created by the users/business and resolving them based on the priority level.
• Conduct design review meeting with developers and architects before the actual development is done.
• Responsible for configuring report service in SSRS and creating various reports based on the requirements from the business.
• Responsible for Training interns in ETL(SSIS).
• Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the bigdata inside the cloud.

Confidential, Madison, WI

Database Developer

Responsibilities:

• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for Conducting bug triage meeting for successful and fast closure of bugs.
• Transferred data from various data sources systems including MS Excel, MS Access, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion.
• Performed Bulk data migration using SSIS from flat files.
• Transferred data from various data sources systems including MS Excel, and Flat Files to SQL Server using SSIS/DTS using various features like data conversion.
• Created SSRS report model projects and created, modified and managed various report models with multiple model objects, source fields and expressions.