SUMMARY

• Over 8+ years of extensive experience in database design, development and administration with MS SQL Server versions 2014/2 R2 using SSIS, SSAS, SSRS (BI Tools) in Financial and Banking industries.
• MS SQL Server Developer 2012/2008R2/2008 with 8+ years of IT experience in various Industry verticals like Finance, Insurance and Service. Maintained positive communications and working relationships at all business levels.
• Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
• Experience in analytical Database Design and Data Modeling skills using MS Visio and ERWIN.
• Experience inTableauDesktop,TableauServer in various versions ofTableau6/8/9.
• Experience conversion of SAS reporting to SQL SSIS/SSRS solutions
• Expert in ETL - Extraction Transformation Loading/SSIS, Data warehousing, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.
• Expert knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL/SSIS processes, dimensional modeling and reporting tools.
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Experienced in designing high level ETL/SSIS architecture, creating, configuring and fine tuning ETL workflows designed in DTS/SSIS for overall data transfer from the OLTP to OLAP/EDW with the help of SSIS and also Involved in creating C# scripts using script task in SSIS
• Created SSIS package to load data from XML Files, SQL Server 2005 and Teradata to SQL Server 2012 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension
• Involved in data load using PL/SQL and SQL Loader and jobs callingUNIXscripts to download and manipulate files.
• Expert in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R 2/2008/2005.
• Created SSRS reports from SharePoint.
• Expert in developing Drill through and Drill down reports using Crystal Reports and MS SQL Server Reporting Services (SSRS).
• Developed Templates and Implemented comprehensive Maintenance plans for backup, re-indexing, database health check, updating of statistics for a variety of both Prod and Non-Prod DB Servers.
• Experience of analyzing data, and interpreting financial cost models.
• Performed cost analysis and developing financial models for mortgage project.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages
• Efficient in up gradation and migration from MS SQL Server 2005 to MS SQL Server 2008
• Hands on experience in production/staging/test/development database administrative: Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Knowledge of SAP System and tools.

PROFESSIONAL EXPERIENCE

Confidential, Pennington, NJ

Sr. MS SQL Server/SSIS/SSAS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Involved in complete lifecycle implementation of the project from gathering user requirements, preparation of technical specifications documents, designing and developing reports, Integration testing, Unit testing to Go live production support.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files.
• Generated DDL, DML statements for creation of new database objects like tables, views, functions, indexes, and stored procedures for implementing the business logic.
• Configured and monitored database application and optimizing database performance, updating statistics, rebuilding indexes and database backup and recovery.
• Created, tested and deployed SSIS Packages to load data into data Warehouse using File System Task, Script task, Execute SQL Task data Flow Task and various transformations.
• SQL server, Teradata database environments and accessed for reporting, analytics, market research and multi-channel marketing activities.
• Performed Transformation of data using various SSIS built-in tools like Derived Columns, Condition Split, Aggregate, Fuzzy Look Up, Pivot and Row Sampling.
• Generated Parameterized, Drill Through reports, Sub-Reports and charts using SQL Server Reporting Services SSRS.
• Mainly designed and developed Qlikview software applications and complex server-based QlikView dashboards from scratch to support reporting and Business Intelligence initiatives.
• Created various SSIS packages to populate the data from flat files, Excel and Access into ODS (SQL Server). Performed full loads for current data and incremental uploads for historical data (transaction based data).
• Created and configured SSIS package configurations using sql server table and environment variables and loaded data from XML, Flat files and SQL Server incrementally.
• Designed and developed STAR schema and multidimensional (OLAP) objects. Created cubes and populated the data using SSIS 2014 packages.
• Designed complex SSIS packages with error handling as well as using various data transformations like conditional split, fuzzy look up, multi cast, data conversion, derived columns, Merge join, row counts, Oledb source, Oledb destination, Excel source, Oledb Command.
• Highly responsible for development and management of SSRS projects like creating drill through reports through Linked reports. Worked with tabular, matrix, gauges, Maps for Sales by region & chart reports, drill down reports as well as interactive reports according to business requirements.
• Expertise in creating Indexes (clustered, Non-clustered Views, indexed views, complex stored procedures, User defined functions, Common Table Expressions (CTE's) and appropriate triggers to facilitate efficient data manipulation to maintain data consistency
• Hands on experience in writing SSIS script/script component task using C#, VB script for customized data manipulation of complex SSIS packages PerformedBackup and recovery&Automation of Backups using maintenance plans.
• Involved introubleshootingfront endapplications designedin ASP.NET for connectivity issues and backend performance issues.
• UsedSSISto populate data from various data sources, creating packages for different data loading operations for application, and to export data from other sources toSQLdatabases.

Environment: MSSQLServer 2014/2012/2008 R2/2008/2005,TSQL,MSSQLServerIntegratedServices(SSIS)SQLAgent, SSRS,SQLProfiler, Teradata,Windows 2008/2003server,Visual Studio, .Net Framework. Qlikview

Confidential, New York NY

Sr. SQL Server DBA/DEVELOPER

Responsibilities:

• Involved in Upgrading the Instance of SQL Server 2000 to SQL Server 2005 in testing and production environment. Used SSMS for monitoring, troubleshooting and addressing database related issues.
• Implementing Database Mirroring using high safety with automatic failover for Disaster Recovery. Implemented New Objects according to the Business requirements. Implemented Constraints (Primary Key, Foreign Keys Check and Not Null/Null) and fine-tune Indexes on Tables.
• Create and Modify Stored Procedures, According to the business. Fine Tuning of Stored Procedures and SQL Queries. Worked with Control Flow tasks, Data flow tasks and Data flow transformations using SSIS 2005.
• Developed various reports to validate the data between source and the target systems. Involved in providing security to the reports by restricting various users through Roles. Used Database Engine Tuning advisor and SQL Profiler for Monitoring memory, processor, Disk I/O and SQL Queries.
• Configured Log shipping from one production server to the reporting server. Implemented built in log shipping with SQL Server 2000 for disaster recovery server. Creating the Packages for running the jobs automatically good in Implementing SQL Server security and process control.
• Creating Users and Assigning Permissions in the DEV Box. Creating back up strategies and scheduling them for execution.
• Created the MS DTS Packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Involved in Performance tuning for source databases.
• Knowledge of VPN Networks and used VPN Extensively to connect to Citibank Networks from home.

Confidential, New York, NY

Sr. MS SQL Server Developer

Responsibilities:

• Worked with financial analyst, application developers, business stakeholders to gather requirements, analyze and build solutions with my team.
• Develop business requirements and create technical specifications and diagrams.
• Perform functional, technical and project management related tasks and activities like created functional analysis document for legacy GPS (Global Payment System) and prepared the vendor analysis document and presented a vendor proposal document to upper management and got the approval for implementation of Java based GPS (JGPS) system.
• Wrote the windows batch program using PowerShell script, SSIS to Extracted GPS message file from Unix system and transform it into Excel format and uploaded it into SQL Server database. This batch job runs every day and loaded/archive daily message file to SQL server.
• Wrote the rules engine, Consolidated 288 swift alliance message routing rules into 48 rules, by combining all messages going to same destination are combined together, eliminating redundant rules.
• Worked on SQL Server profiler for improving the performance of present quires, created triggers, created and worked on existing Stored Procedures and Indexes.
• Created various ETL (SSIS) packages to load data from CSV files to the tables in SQL Server with using derived columns to specify the file path.
• Created data mapping documents for ETL process (SSIS). Worked on writing the insert, update and delete quires joining multiple tables to make changes in the staging tables.
• Created a front end application for the finance and sales team with implementing the complex business logic of projected and actual amounts with coding in VB script using MS Access application
• Designed and created various forms for finance team, sales team and account managers with implementing the business logic. Worked with non-technical teams to help them to use the application.
• Worked on creating various reports in SSRS (matrix, multi drilldown, parameterized) and scheduled the snapshots

Environment: SQL Server 2012/2014, MS SQL Server Integration/Reporting Services/ Analysis Services 2008(SSIS/SSRS/SSAS), XML, Visual Studio 2008/2010, T-SQL, PL/SQL, SQL Profiler, Report Builder MDX, ASP.NET, C#, COSMOS/SCOPE, Azure, Agile, Crystal Reports, Power View, Power Pivot, ER-Win, MS Visio

MS SQL Server Developer

Confidential - Jersey City, NJ

Responsibilities:

• Involved in creating tables and their relationships in the data warehouse.
• Involved in migration of SQL Server .
• Involved in analyzing and gathering the requirements for Row level Security and Role based security.
• Involved in creating SSIS packages to migrate large amounts of data.
• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.
• Troubleshooting ODBC and OLEDB connection issues in SSIS packages.
• Developed Dynamic Report Engine for creating the customized reports in SSRS.
• Developed MDX Queries against SSAS cubes to generate reports.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Involved in using SSAS data sources in SSRS reports.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Tested, Cleaned and Standardized Data meeting the business standards using Fuzzy /exact lookups using SSIS tasks.
• Responsible for month end maintenance activities and large data pulls from COSMOS and CUBES using SSIS packages and SCOPE scripts.
• Worked on COSMOS Like Downloading the data from COSMOS to SQL Database using Metric Explorer Tool.
• Created in Extracting and Transforming data (ETL) from Azure Database and creating packages using SSIS, Import, Export Data, Bulk Insert and BCP Utilities.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu and used gauge reports with KPI's in SSRS
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS.
• Worked on GIT, Team Foundation server, Visual Studio online and the application lifecycle tools associated with it.
• Designed, developed, tested, deployed, supported, maintained and documented (KPIs), Scorecards, Time Aware Dashboards and accompanying Analytical Grids and charts with URL actions using Performance Point Server and SQL Server Analytical Services.
• Created Databases, Tables, Cluster/Non - Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. Involved in SSAS Cubes design by creating KPI, Actions and Perspective from huge dataset using SQL Server Analysis Services (SSAS).
• Designed and build the OLAP cubes using Star schema and Snow Flake Schema using native OLAP Service Manager.
• Created Tableau Dashboards with interactive views, trends and drill downs along with user level security. Install upgrade Tableau server and server performance tuning for optimization.
• Created Batch Stored Procedures for in the Report Scheduler according to the monthly, weekly or daily. Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau (7.x ) reports.
• Prepared Technical Documentation.
• Involved in performance tuning of queries for query efficiency.

Environment: SQL Server 2012/2014, MS SQL Server Integration/Reporting Services/ Analysis Services 2008(SSIS/SSRS/SSAS), XML, Visual Studio 2008/2010, T-SQL, PL/SQL, SQL Profiler, Report Builder MDX, ASP.NET, C#, COSMOS/SCOPE, Azure, Agile, Crystal Reports, Power View, Power Pivot, ER-Win, MS Visio

Confidential, Boca Raton, Florida

SQL Developer/Production Support

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Extensively used SSIS to move data from text files to SQL Server.
• Responsible for building Power BI Dashboards for 3M Digital Marketing team using Tabular and Multi dimensional Models. Design and model data sets with Power BI desktop based on measure and dimension requested by customer and dashboard needs.
• Good understanding of Integrations including Web Services, SAAS, Workday Architecture, Business Process Framework.
• Installed On premise data gateway and scheduled daily data refresh in Power BI.
• Worked on Windows Azure Infrastructure as A Service Platform (IAAS)/(PAAS).
• Extensive experience in analysis, design, application programming on Oracle. Experience in database Backup & Recovery.
• Good knowledge on delivering predictable performance, scalability, business continuity, data protection using Microsoft Azure SQL Database.
• Worked with Oracle DBA in migration project and supported oracle databases
• Views using T-SQL in Development and Production environment for SQL Server 2008.
• Created Quality Assurance stats reports using SSRS
• Created SSIS packages for new projects utilizing Business Intelligence Development.
• Writing complex Stored Procedures to meet the business requirements.
• Using SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created data sources, connection strings and defined the datasets for generating the report.
• Worked on all types of report types like tables, charts, sub reports etc.
• Used VB.Net to define and implement Business Logic Layer and Data Access Layer.
• Created OOPs objects like Collections, Interfaces implementations using VB.Net Generics for extracting data
• User interface screens developed using VB.NET.
• Participated in the conversion of VB system into MVC VB based architecture
• Created Linked reports, Ad-hoc reports etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Developed, monitored and deployed SSIS packages.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created 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.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages through Active Batch Job Scheduler.
• Created subscriptions to provide a daily basis reports. Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Environment: MS SQL Server 2008 Visual Studio, MS SQL Server 2000/2008R2/2016 SQL Integration Services, VB.net, SQL Query Analyzer, Import & Export Wizard.

Confidential

SQL Developer/SSIS/SSRS/DBA

Responsibilities:

• Worked extensively on database administration, storage maintenance, software upgrade, installation, replication monitoring, backup &recovery planning, partition tables, indexes, and performance tuning
• Responsible for Conceptual, logical and physical design with a significant effort towards application using ERWIN.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.
• Implemented High Availability inSQL2012 by configuring Always On Availability groups across WindowsServerFailoverClustering usingFailoverClustering Instances
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Automated and enhanced daily administrative tasks including database backup and recovery.
• Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV/XML, SQL Server 2005, instances, Oracle Databases and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Configured SQL Mail agent for sending automated alerts/email.
• Gather requirements from users at chat sessions and interviews.
• Adept at preparing business requirements documents, defining project plans, writing system requirement specifications.
• Developed Pl/Sql procedures & functions to support the reports by retrieving the data from the data warehousing application.
• Provided documentation for all kinds of reports and SSIS packages.
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks.

Environment: Microsoft SQL Server 2008/2005 Enterprise edition SP3, SSMS, SSIS, SSRS, SSAS, BIDS,SAP Tools, Microsoft Visual studio 2005,XML,Windows server 2003.