SUMMARY

• Over 6+ years of strong IT experience with demonstrated success in the Database development, design, Administration and deployment of large - scale enterprise applications.
• Expert in MS SQL Server 2014/2012/2008 suite of products like SSIS, SSRS and SSAS.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Mapping, Table normalization and Data Modeling.
• Extensive knowledge in T-SQL queries (DDL and DML) for developing complex Stored Procedures, Batch Scripts, Triggers, Tables, Views, Relational Database models and Data integrity, and SQL joins.
• Extensive knowledge of addressing Performance Issues and involved in Index tuning, Data Profiling and optimized queries using query execution plan.
• Excellent in working on SSIS, SSAS, SSRS, OLAP, OLTP, Reporting and Analytics, Data Cleansing, Data Scrubbing, Data Migration and writing T-SQL.
• Expertise in developing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Experience working with REST API sources in SSIS
• Retrieving data from a Power Pivot workbook that containsthe data behind Pivot Tables and Pivot Charts
• Experience in providing Logging, Error handling by using Event Handler, Configurations and Custom Logging for SSIS Packages.
• Experience developing SSIS packages for Batch File Processing’s using Execute Process Task.
• Experience in Extraction &Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, AS400, and DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS utilities.
• Experience in Performance Tuning for SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Experience in developing Crystal Reports, Cascading parameters, drill down, Drill through, Sub Reports and Charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder.
• Experienceingenerating on-demand and scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Expert in calculating measures and dimension members using Multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating MDX query in SSAS cube for various calculated members, KPI, Actions, Aggregation, Perspectives and various actions such as drill through, reporting etc.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Created Dashboard pages in Performance Point Server that use different types of web parts and excel services for reports.
• Experience in database administration and development activities such as Installation, Configuration, Database design & development, Data modeling, Backup & Recovery, Performance tuning and Query Optimization, Data Transformation Services, and Database Security.
• Experience with NoSQL databases (MongoDB, CouchDB, Redis, Cassandra).
• Expert in gathering business requirements and converting them into technical requirements
• Implement/code reporting and database solutions usingclient standard coding and design standards which include MSSQL queries and stored procedures Implement and test solution architecture
• Maintain and Monitoring of Various SSRS reports, SQL code, store procedures and Solving Tickets on Daily Basis for Production Issues.
• Experience in providing 24 x 7 production support.
• Excellent communication skills, organizing skills, highly punctual and an excellent listener.
• Proven experience in project and team leading with minimal defect delivery. Equally comfortable working independently as well as in a team environment
• Ability to work in a team and as an individual with minimal supervision.

TECHNICAL SKILLS

Programming Skills: T-SQL, C, HTML, XML, Perl, JavaScript, XSLT, ASP.NET, VB Script, C#

Databases: Microsoft SQL 2014/2012/2008, MySQL, SYBASE, MS ACCESS

BI and ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Adept SQL diff, Oracle SQL, Microsoft Visual Studio2010/2012, Cognos 10.2

Reporting Tools: Microsoft SQL SERVER 2005/2008/2012, Reporting Services (SSRS), Report Builder 2.0, Report Builder 3.0, Crystal reports 10, ProClarity, Tableau

Database Design Tools and Data Modeling: MS Visio, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables

Operating Systems: Microsoft Windows, UNIX, LINUX.

Tools: and Utilities: Business Intelligence Development Studio (BIDS), SQL Navigator/SQL Plus/Toad, Visual Studio 2013/2008, Share Point 2013, Team Foundation Server (TFS), Microsoft Word, Excel and PowerPoint.

Version Control Tools: VSS

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Sr. SSIS/ETL Developer

Responsibilities:

• Designed ETL SSIS packages for loading data files provided by the external vendor into our data warehouse, generating reports for Sales Operations, supporting internal data warehouse applications, and generating Outbound files.
• Automated the entire process of running the reports from Infor ERP LN and validating against existing data for new accounts and inserting them in Salesforce.
• Developed complex SQL queries, Joins, Functions, CTEs, and Stored Procedures to generate reports.
• Implemented SSIS packages to call Salesforce API to load data using Task Factory Pragmatic Works.
• Implemented Standardizing Addresses for the legacy data in salesforce by calling Smarty Streets through REST API.
• Responsibilities involve ETL development, unit tests, business validations, integration tests, defect resolution and production support.
• The development technologies involved working with Microsoft SQL Server 2014, SQL Server Integration Services (SSIS), Task Factory Extension, Visual Studio 2012, Salesforce, MS Excel and TFS.
• Worked closely with Business Analysts, data architects for business requirements, design standards, validations, and UAT tests.
• Designed PowerShell code for SSIS Project deployments in SQL Server SSISDB.
• Validated data from Pivot tables, VLOOKUP validations in Excel
• Had a chance to optimize legacy system SSIS packages, SQL code using SQL execution plan, Indexing, Update Stats and documented ETL packages going through development process to assist other teams for future development purposes.

Environment: SQL Server 2014, SSIS, T-SQL, SSMS, C#, Excel 2013, TFS, Visual Studio 2013, Salesforce, info ERR LN, Cognos

Confidential, Jersey City, NJ

Sr. SQL/ETL Developer

Responsibilities:

• Part of a large technical team, responsible for development of database objects (schema changes, stored procedures implementation) and SSIS packages.
• Understood Brokerage business knowledge and financial products.
• Responsible of analyzing the existing data elements (Client specific schema) and mapping to Broadridge specific data elements.
• Worked in Agile based environment involved to work closely with web, Mid-tier, BSA and QA to break down business requirements into Agile stories.
• Responsible for adhering to our Programming, documentation and process standards.
• The development technologies involved Microsoft SQL Server 2014, Microsoft SQL Server Integration Services (SSIS), Microsoft Visual Studio 2013, Microsoft Office, XML, Scripting (Visual Basic, C#), and Team Foundation Server (TFS).
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Conducted ETL Design and prepared ETL design documents/technical specifications.
• Extracted the data from different Data Sources and transformed the data as per the user criteria and used the data in the SSAS cubes for the analysis.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• GeneratedSub-Reports,Drill down reports, Drill through reports, Parameterized reports using SSRS and created various types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.
• Completed code reviews raised for DB objects in code collaborator and checked into TFS.
• Handled tickets for Database deployments into QA, and Production Environments
• Worked on various QA and Production Defects.

Environment: SQL Server 2014/2012/2008, SSIS, T-SQL, SSMS, C# scripting, BIDS, Excel 2010, SharePoint 2013, TFS, Visual Studio 2013/2008, Code Collaborator Client, Rally, ServiceNow.

Confidential - Fort Worth, TX

SQL BI/ETL Developer

Responsibilities:

• Performed Server installation and configuration using SQL Server 2012.
• Created Packages that Transfers Databases from OneSQL Serverinstance to Another Instance and Scheduled the SSIS packagefor migration of data from old system to MS SQL 2012.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous sources.
• Used various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Developed and maintained critical applications for sales auditing team by balancing sales and settlements of credit amounts with the bank on a day to day basis.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts and SSRS reports.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Created SSIS packages for File Transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.
• Used Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Designed and built Star and Snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Worked on multidimensional data modeling.
• Participated in Databases Architecture and data modeling design.
• Reviewed and developed data models and database designs with development teams
• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Monitoring Performance of SQL server using SQL Profiler, Query Analyzer, Database Engine Tuning Advisor (DTA) and Performance monitoring.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2012.
• Inspected the reports and fixed bugs in stored procedures and tuned Reporting Services to the T-SQL.
• Worked on Change Management Cases to resolve the production change request issues based on the Specifications provided.
• Planned Backup strategy based on projects requirements.
• Responsible for database backup and Restore, Creating Roles, Granting access.
• Worked on call support to resolve issues whenever needed.
• Worked on Agile Methodology and Microsoft Team Foundation Server (TFS)

Environment: SQL Server 2008R2 & 2012 Enterprise Edition, SQL, T-SQL, MS Access, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS, SSRS.

Confidential, NYC, NY

MS SQL BI Developer

Responsibilities:

• Migrated the existing database from SQL Server 2008 to SQL Server 2012 and worked on improving the performance of the system.
• Reports are also created for the banking process on the daily and weekly basis. These reports were reviewed by Directors and Analysts to calculate different categories like banking calculation. It also involved in creating new database from different scatter database.
• Gathered requirements and acquired application knowledge from Business Managers.
• Collect functional and application data requirements from customers.
• Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers form the existing diversified data sources.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created SSRS reports from SSAS Cubes Datasets.
• Created drill down and sub reports from reporting services (SSRS) that can be browsed on web.
• Worked on relationships and hierarchies between attributes and measure groups and defined granularity with in a measure group and drill through actions in SSAS.
• Implemented multidimensional cubes with MDX calculations to support analysis needs and fast data retrieval.
• Developed reports using SSRS 2008 mainly parameterized reports.
• Developed report specifications, created and modified reports using SSRS 2008, deployed, and maintained of various SSRS Reports in SQL Server 2012.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler Index Tuning Wizard.
• Worked on error handling a module consisting of data from bank, transactions, and currencies, countries, master and static.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Actively involved in Normalization & De-normalization of database.
• Planned a complete backup on the database and restored database from disaster recovery.
• Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked on designing ETL packages using SQL Server 2012.
• Actively participated with design and development of NoSQL(MongoDB) solutions for the users.
• Actively interacted with the team of managing and administering NoSQL database systems.
• Used “SQL Profiler T-SQL Duration” template for tracking execution time of T-SQL Statements.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Developed various Dashboards using objects such as Chart Box (Drill Down, Drill up & Cyclic Grouping), List, crosstab etc. using Tableau.
• Involved in publishing of various kinds of live, interactive data visualizations, dashboards, reports and workbooks from Tableau Desktop to Tableau servers.

Confidential, Lexington, KY

SQL BI (ETL/SSIS/SSRS/SSAS) Developer

Responsibilities:

• Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan in SSMS
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005/2008/2012 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
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package per the advanced feature of SQL Server Integration Services
• Experience in developing the Drill down, drill through, Parameterized reports using SSRS
• Experience in creating stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design
• Defined Check constraints, Business Rules, Indexes, and Views
• Identified and worked with Parameters for parameterized reports in SSRS 2005/2008
• Experience in creating and managingstored procedures,indexes, views, UDF’s, Database Constrains, to meet business requirements and policies.
• Good Knowledge in Designing and Building the Dimensions and cubes with star schema and writing MDX queries using SQL Server Analysis Services (SSAS)
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes
• Experience in writing the SQL Statements, PL SQL, SQL plus Commands for modifying and retrieving the data.

Confidential

SQL Server Developer/DBA Trainee

Responsibilities:

• Involved in installation, configuration and administration of SQL server 2005 and 2008 on Servers.
• Install, configure, administer and secure Sybase 12.X and 15.X databases using UNIX/LINUX operating systems.
• Applied patches and service packs to keep the database at current patch level.
• Successfully resolving SQL Server problems in conformance with SLAs, which involves in-depth knowledge of SQL Server architecture, connectivity, replication, SSIS, backup/restore, database corruption, security, and contribute to continuous improvement.
• Learned to Implement database standards, naming convention for the database objects and maintain database security.
• Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, User defined data types and functions.
• Responsible for installation and configuration of Oracle 9i and 10g database servers on a UNIX platform.
• Implemented trigger and stored procedures and enforced business rules via checks and constraints.
• Involved in data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.

Environment: SQL Server 2008/2005, UNIX/ LINUX, DTS, T-SQL, Crystal reports7.