SUMMARY:

• Over 7 years of extensive work experience as a SQL Server Developer and in depth proficient experience in Microsoft Business stack, OLTP, Operational Data Source (ODS), Tabular & Multidimensional Modeling, Performance Tuning, Data warehouse, OLAP and Database technologies. Intelligence
• Experienced in the Finance and Insurance domains with exposure to Investment Banking, Retail Banking, and Global Capital Markets (Equity, Mutual Funds, Fixed Income).
• Active participation in Software Development Life Cycle (SDLC) specifically waterfall and Agile Scrum methodology.
• Demonstrated expertise in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS and SSAS in BIDS.
• Experience in installation, upgrade and configuration of Microsoft SQL Server databases.
• Broad experience in Query Optimization and performance tuning of TSQL stored procedures, functions, SSIS packages, SSRS Reports etc.
• Over 3 year’s Strongexperience in SSRSdevelopment skills, experience including Tablix, Matrix, chart, graphic scorecard reports, Performance Summary Dashboards, sub - reports.
• Experience in creating Adhoc reporting ready universes usingBusiness Objects Universe Designer.
• Have good understanding of Tableau architecture, development and end user experience.
• Application Clusters specializing in tuning & monitoring of high availability in Oracle & SQL Server.
• Over 6 years’ experience in utilizing ETL tools, including SSIS, DTS and ETL Package design.
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages through scheduler such as Autosys and SQL Server Agent.
• Over 3 years’ experience in SSAS (SQL Server Analysis Services) 2005/2008/2012.
• Have good experience with designing and implementing MDX queries, OLAP architecture, MOLAP, ROLAP and HOLAP.
• Over 5 years of experience in coding in VB.NET, C# while working with SSIS.
• Extensive experience in developing tools using Access, VBA, Excel environment.
• Excellent hands on experience in developing Windows applications, Web applications using ASP.NET, C#.NET and ADO.NET.
• Interaction with the Users and Business Analysts for better understanding of business & reporting requirements.

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database: MS SQL Server 2012, 2008R2, 2008, 2005, Oracle, SAP, Siebel, Microsoft Office 2007/2003, Excel, VBA, MS-Access.

Language: C, C++, XML, TSQL,ASP.NET,VB.NET,C#,MDX,DAX

Operating System: Windows XP/NT/ 2000/2003/2008 , DOS

Tools: & Applications: Erwin Data Modeler, MS Visio, Business Objects XI 3.1/3.0, Cognos, Crystal Reports 10,Autosys, Microsoft office 2003/2007, Tableau Server 8.2, Power Pivot 2010, Microsoft Power BI, SharePoint 2010, Excel Services 2010, LANDesk

Architecture: Relational DBMS, Client-Server Architecture, OLAP, MOLAP, ROLAP, HOLAP, OLTP

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, VA

SSRS/SSIS Developer

Responsibilities:

• Worked on Implementing the Extraction strategy & created the SSIS Packages in Visual Studio to extract, transform & load all the client information.
• Created complex SQL views, functions and stored procedures to join multiple tables and pivot based on the attributes in source to target tables.
• Mapped the single table attributes information from source to around 20 target tables by pivoting the rows into columns in destination using SSIS and stored procedures.
• Wrote business logic code in C# code behind files to read data from database stored procedures.
• Developed Data Migration strategy for the customer to transfer enterprise legacy data to the newly developed EMM application. Reverse engineered various application to develop data mapping between the two applications and implemented SQL migration scripts to load data across multiple tables by maintaining data integrity.
• Provided technical assistance for development and maintenance of Autosys and related scheduling solutions.
• Experience in Microsoft Visual C# as part of transformations in script component of SSIS when splitting the data as per business needs.
• Worked on various SSIS tasks such as Conditional Split, Derived Column, Lookup, Merge Join etc. which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Technicolor’s target tables.
• Improved the Performance of Packages by configuring the Component Properties like MaxConcurrentExecutables, Default Buffer Size, Engine threads & Delay Validation etc.
• Created views to pull up the attributes data based on recent transaction date time.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Generated Parameterized/dropdown SSRS Reports.
• Developed different account level and security level reports using SSRS.
• Created shared Data sources and developed data models to create Ad hoc Reports.
• Designed and developed matrix and tabular reports for each serial numbers related data across different tables with drill down, drill through and drop down menu option using SSRS.
• Scheduled reports every week to Business analyst and customer representatives for various categories and regions for data analysis using SQL Server Reporting services (SSRS).

Confidential, O’fallon, MO

SQL Server/SSIS Developer

Responsibilities:

• Worked on the Data migration project to migrate the data from ADABASE, DB2, and MS ACCESS to SQL Server.
• Assisted with Database design, extensive data analysis of all 3 source systems & implemented the ETL architecture to support the migration into EDW.
• Created ETL Extraction Strategy architecture as part of Development plan to extract & load data from source systems to staging and to ECB Destination servers.
• Extensively worked on Stored Procedures, triggers, views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design.
• DefinedCheck constraints, Business Rules, Indexes, and Views.
• Worked on business logic code in C# code behind files to read data from database stored procedures.
• Worked with Exception handling in Stored procedures with Try/Catch and with @@Error.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into target tables.
• Worked extensively on complete data mapping of all source systems as part of data analysis.
• Extensively used SSIS transformations such as Script component, Pivot/Unpivot,Multicast, Derived column, Data conversion, Row count and Send Mail task etc.
• Experience in SSIS script task, look up transformations and data flow tasks using T- SQL, C# and Visual Basic (VB) scripts.
• Worked on the data archival process by transferring data crossing different platforms, validating data during transferring, and archived data files for different DBMS by creating dynamic SSIS packages.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Involved in the Production support for TLC application & generated the reports based on Case counts, Hearing decisions etc. as per Users requirements.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Confidential, Palm Beach Gardens, FL

SQL Server/MSBI Developer

Responsibilities:

• As an ETL/Report Writer Tech lead, lead the Offshore Philippines team in designing and developing ETL structures, SSIS packages & SSRS reports for enhancements in Data warehouse.
• Worked on providing the SQL Report access for the users through incidents and service requests using LANDesk as part of PROD Support.
• Developed ComplexT-SQL stored procedures, triggers, views,and adding/changing tables for data load and transformation, and data extraction.
• CreatedRecursive User Defined Functionsto encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Designed SSISPackagesto transfer data from Multi formatted Flat files, Excel to SQL Server using Business Intelligence Development Studio.
• Worked on Debugging the SSIS Packages as part of Error Handling when dealing with the Flat Files.
• Implemented Control flow, data flow, logging, event handling and package configurations using SSIS
• Analyzed the data to implement incremental load.
• UsedConfigurationfiles to deploy and install a package from one environment to another.
• Created reports from data warehouse using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts, Table.
• Created reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Created Report Snapshots to improve the performance of SSRS.
• Generated Parameterized/dropdown SSRS Reports
• Installed Power Pivot for Excel 2010 Add-in to load & query the data for easy to use analysis for business users.
• Used agile methods to promote a disciplined project management process that encourages frequent inspection and adaptation.

Confidential

SQL Server Developer / SSRS Developer

Responsibilities:

• Used SSIS 2008 to create ETL packages (.dtsx files) to validate, extract, transform and load data to Data warehouse databases, data mart databases.
• Worked on Creating SSIS packages to store the Summary level values of different measures for Premium, Claims & Cash templates.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.
• Worked with SQL Views to improve the enhanced security of the given templates for various measures.
• Created Clustered, Non Clustered & Covered Indexes to improve the performances of queries based on the business requirements.
• Worked on different types of Source systems like SAP, Clarity, Siebel & Oracle and matched with the measures of EDW and stored it in SQL Server Database using SSIS.
• Worked with the off shore developers, DBA, and systems support personnel in elevating and automating successful code to production.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Created and migrated the reporting data to the landing zone from different source systems like UC, IRIS, SICS, EDW etc. using SSIS.
• Created the Pop-Spec documents for different projects based on the spec conventions.

Confidential

SQL Server Developer / SSRS Developer

Responsibilities:

• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2000 user’s client critical databases.
• Involved in Normalization of the database and bringing it to 3NF.
• Implemented disaster recovery for solving different kinds of issues and also prevented the loss of data.
• Responsible for developing GUI screens.
• Wrote SQL queries and stored procedures to generate data for reports.
• Integrated Database Maintenance jobs to perform Full, differential & transaction log Backups and scheduled them with the SQL Server agent job scheduler.
• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes and views.

Confidential

SQL Server Developer / SSRS Developer

Responsibilities:

• Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
• Involved in Normalization of the database and bringing it to 3NF.
• Involved in creating the constraints, rules, defaults and triggers to maintain the data and referential integrity.
• Created ER diagrams using Visio.
• Created Views to enforce security and data customization.
• Created Non-Clustered indexes to improve query performance and query optimization.
• Involved in the performance tuning and optimization of T-SQL queries.
• Responsible for Data migration from SQL Server 2000 to SQL Server 2005 Databases.
• Created Stored Procedures for commonly used complex queries involving join and union of multiple tables.