SUMMARY:

• Around 8+ of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2000/2005/2008/2008 R 2/2012/2014/2016.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Strong understanding of the mortgage process, especially underwriting and closings.
• Exceptional approach to customer service, providing an optimized banking experience.
• Comfortable strategizing, setting banking objectives and accomplishing them within deadlines
• Familiar with residential and commercial mortgage lending practices.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Migrated database from SQL Server 2014 to SQL Server 2016 using utilities i.e, exp/imp and attach/detach for SQL Servers 2016 futures.
• Assisted as data analyst in mining data from the sql database that was used in several significant presentations.
• Assisted as data analyst in offering support to other personnel who were required to access and analyze the sql database.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Good knowledge of Data Marts, MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
• Proficiency in software development life cycle (SDLC) for development process and AGILE, SCRUM
• Expertise level of knowledge as a data analyst in data conversion and data cleansing from the raw data sources.
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Used ProClarity tool to analyze the data in the cube by using different features like Chart view, Decomposition Tree, Performance Maps, etc.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting

Databases: MS SQL Server Denali,2016,2014,2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Cognos

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

SQL /ETL Developer

Responsibilities:

• Gathered requirements from the business users, created technical specification documents.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Gathered the data from different sources using SQL Server Integration Services (SSIS) using different transformation, constraints, checkpoints and configuration settings.
• Added/modified Users, Groups, folders, rights and involved in the implementation of log shipping, mirroring to maintain the high availability of the servers.
• Created/modified SQL Joins, sub-queries, indexes, stored procedures, triggers and other T-SQL, PL/SQL code to implement business rules and automate the tasks.
• Involved in documenting the project steps and presenting to the team members.
• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package per the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL Server 2012, 2014 Integration services.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.

Environment: MS SQL Server 2012, 2014, 2016, SSMS 2012,T-SQL, PL/SQL, Oracle 10g, MS Share Point, Microsoft Visio 2010 and Excel.

Confidential, Englewood, CO

SQL BI Developer

Responsibilities:

• Created one central reporting database.
• Created objects like tables, views, stored procedures, and indexes and handled performance tuning using T-SQL.
• Using SSIS packages moved the data from SQL server 2005/2008.
• Recreated the reports in SSRS from Access, migration from Access DB to SQL Server 2012.
• Worked closely with Business team to understand their requirements, Based on their requirements created Reports using SSRS and created reports using SSIS into Excel format.
• Transformed the data using different transformations like Conditional split, join, merge, lookup, Derived column of SQL Server Integration Services (SSIS).
• Scheduled all the reports built and automated the report output delivery in diff formats.
• Worked with SQL DB from the scratch. Created database, set up permissions and Migrated the Schema form existing SQL server.
• Created SSRS data source using connections and generate reports in Diff Formats.
• Hands on Power BI View Tool. Created reports using the Power BI Tool.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in writing MDX Queries for Analytical and Reporting purposes.
• Involved in developing and deploying OLAP cubes, monitoring full and incremental loads using Cube wizard and manual methods.
• Generated multiple Enterprise reports (SSRS) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP).
• Built Drill Down, Drill through, linked and sub reports using SSRS 2012.
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Supported existing reports in production environment.
• Worked on property expressions, variables and configurations between SSIS packages.
• Developed SSIS Packages for migrating data from Staging Area of SQL Server 2008 to SQL Server 2012.
• Good experience in working with tasks like FTP, File System, executed SQL task in SSIS.

Environment: SQL Data Warehouse, BLOB, Power BI, SQL Server 2016/2014/2012/2008/2005, MS SQL Analysis Services, MS SQL Integration Services, MS SQL Reporting Services, Power Pivot, XMLA, T-SQL/PLSQL, MDX, VISIO, tableau desktop, Excel Cosmos Extension.

Confidential, King of Prussia, PA

SSIS Developer

Responsibilities:

• Created Stored Procedures, and Functions using T-SQL scripts.
• Created and modified different complex SSIS packages which pulls data from different sources like SAP and SQL databases and insert into SQL Data Warehousing database.
• Deployed and scheduled the SSIS packages to run at different time intervals.
• Created reports using SQL Server Reporting Services (SSRS).
• Created Ad-hoc reports using report builder.
• Developed new database objects including tables, stored procedures and functions.

Environment: /Tools: S QL Server 2008/2012, SQL Server Data Tools (SSDT).

Confidential, Harrisburg, PA

SQL Server/BI Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements.
• Participated actively in designing the system database structure.
• Developed reports using complex T-SQL queries , User Defined Functions, stored procedures and Views.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing various kinds of transformations using SSIS/DTS packages.
• Worked with various upstream and downstream systems and customers in interfacing various systems for data extractions, ETL , Analytics and Reporting needs.
• Used different Control Flow Tasks and Data Flow Task for Creating SSIS Packages .
• Designed packages using Lookup Transformations, Merge Joins, Fuzzy Look Ups and Derived Columns with Multiple Data Flow tasks.
• Used several types of Transformations for Data Conversion, Sorting and cleaning the data from various sources into company's format.
• Created Packages using Stored Procedures and T-SQL queries .
• Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.
• Developed Complex Packages to load data into Stage, ODS and Data Ware House systems.
• Involved in Automating SSIS Packages using SQL Server Agent Jobs.
• Designed large-number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.

Environment: T-SQL, SQL Server 2008/2005, Crystal Reports 9.0, Windows 2000 Server, MS Access 2000.

Confidential

SQL Developer (SSIS/SSAS/SSRS)

Responsibilities:

• Actively involved in understanding business requirements, analysis and design of ETL Process.
• Fully Involved in Data Warehouse Schema Design.
• Fully involved in identifying Dimensions and Facts.
• Developed Dimensions and Fact Packages.
• Created scripts and written queries to move the data from source to destination.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Created derived columns from the present columns for the given requirements.
• 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.
• Extensively worked in data Extraction, Transformation and Loading from source to target system-using SSIS.
• Identifying the usage of Indexes in Data warehouse at various situations as part tuning.
• Handling different conditions while the Data is moving from source to Destination.
• Developing Cube based on requirement.
• Developing Different types of reports for cancellations.
• Comparison of Incremental and Full load.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Bulk data migration using SSIS from flat files.
• Developed, monitored and deployed SSIS packages.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Report parameters included single valued parameters, multi-value parameters that also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report like tables, matrix, charts, sub reports etc.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.
• Designed interactive Dashboard reports in SSRS using a new special Tableau features and shared them on Share Point for the executives.

Environment: Windows2003 Advanced Server, VB.Net Advanced Sql, MS SQL Server 2005/2008/2012/2014, Pl/SQL, Oracle 11g, SSRS, SSIS, OBIEE, Erwin.

Confidential

SQL Developer / SSIS

Responsibilities:

• Configured SQL Server Environment.
• Created DTS packages to copy tables, schemas and views and to extract data from Excel using SSIS.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used BCP command line utility to replicate a database.
• Designed Entity-Relationship diagrams and thus the database schema
• Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.
• Performed job scheduling in the SQL Server Environment.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Developed stored procedures, triggers, row level audit tables in SQL Server.
• Developed cursors and views to improve performance in data transactions.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports, and Drill-down Reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005.

Environment: MS SQL Server 2000/05, MS SQL Enterprise Manager, SSIS, DTS, T-SQL, and Windows NT.