SUMMARY:

• 8+ years of experience as a software Engineer/Analyst in all phases of System development Life Cycle (SDLC) from investigation of initial requirements through analysis, design, programming, testing documentation and implementation.
• 7+ years of experience with focus on Database design and Development using different tools of ER diagram, Normalization techniques, T - SQL (DDL and DML) Coding and installing, upgrading, configuring and implementation of MS SQL Server 2000/2005/2008/2008 R2/2012/2014 in Windows Environment.
• Ability to isolate complex DB issues, analyze them and resolve in acceptable time frame.
• In-depth experience of Transact-SQL (DDL, DML), Designing and Normalization techniques on the database tables.
• Excellent experience in developing complex Stored Procedures, Views and Indexed Views.
• Good experience in creating User Defined Functions and Triggers in observing Business Rules.
• Expertise in working with Version control system (VSS, VS TFS) Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Expertise in Tabular Relational modeling constructs (model, tables, columns) in SSAS from OLAP modeling constructs (cubes, dimensions, measures). Code and script use OLAP metadata.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.
• Created Reports with complex formulas and to query the database for business Intelligence.
• Experience in creating/deploying Data Transformation Services (DTS), MS SQL Server Integration Services (SSIS) packages, Reporting Services (SSRS).Expertise in creating Packages by SSIS/DTS for ETL work.
• Design, develop, write, test, and implement SSRS reports and dashboard with multi-parameter, chart, drill-down, drill-through, sub-report and interactive sorting capability for admin, accounting, and sales department.
• Programming experience as an Oracle PL/SQL Developer in Design, Analysis and Implementation of Business Applications using the Oracle Relational Database Management System (RDBMS).
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/2005/2008/2012/2014.
• Sound technical knowledge of Data warehouse concepts, ETL, logical and physical Data Modeling using Normalizing Techniques, relational models and adapt to constant changes.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Expertise in developing application using SQL Server.
• Expertise in Client-Server application development using Oracle 12C/11g/10g/9i/8i, PL/SQL, SQL *PLUS, SQL DEVELOPER and SQL*LOADER, SQL Server.
• Excellent technical, communication and interpersonal skills with very good troubleshooting and problem solving skills. Ability to work on multiple tasks in a fast paced environment independently and in a team.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2000/2005/2008/2012/2016, MS Access, Oracle 9i/10g/11g/12c.

BI Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, MS Visio, Crystal Reports 9

Database: MS SQL Server 2008/2005/2000, Oracle 12c/11g/10g/9i/8i, MYSQL, MS-ACCESS.

DB Design Tools: Erwin 5.1, MS Visio 2007/2003, Rational Rose (UML)

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, T-SQL.

Office Tools : MS Office (Project, Excel, PowerPoint, Word, Visio)

Operating Systems: Windows 8/7Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

Sr SQLBI Developer/ SSRS/SSIS/SSAS Developer

Responsibilities:

• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/ SSMS in SQL Server 2012 environment, and deploy the data. Scheduled the jobs to do these tasks periodically.
• Extensively used Joins and CTE’s for complex queries involving multiple tables from different databases.
• Worked with Exception handling with @@error and with Try/catch.
• Created new ETL packages to validate, extract, transform and load data into data warehouse databases, data mart databases using SSIS packages.
• Modifying existing SSIS packages and Stored-Procedures which are used in revenue data ETL process.
• Created traces using SQL server profiler to find long running queries and modify those queries as a part of Performance Tuning operations.
• Creating SSIS package to load data from Flat file to data warehouse databases using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate and Pivot Transformation.
• Worked with users and helped Build a Tabular Data Model and published it to Share Point
• Involved in implementing Key Performance Indicator (KPI) Objects in SSAS 2012. Create Calculate member in MOLAP cube using MDX in SSAS 2012.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Scheduled the reports to run on daily/weekly/monthly basis and email the results to the users in the required format.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data warehouse.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems by adding or enhancing relevant entities/ tables, columns etc.
• Enhancing performance of SSIS packages and SQL queries using optimization techniques.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Created reports which include Matrix, Drill Down, Drill Through, Cascading, parameterized and chart Report types from data mart databases using SSRS.
• Deploying SSRS reports to report server and managing report subscriptions.
• Involved in report snapshots to improve the performance of SSRS.
• Worked on Excel 2010, Power Pivot for providing ad-hoc reporting.
• Creating and scheduling new SQL Server Agent Jobs to execute new data load process steps.
• Modifying existing Facts and Dimensions in SSAS cubes based on new requirements from users.
• Created User Defined Hierarchies depending on the business requirement using SSAS.
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Created different measure groups and calculations using SSAS.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: Microsoft SQL Server 2008/2012,, Visual Studio 2008, T-SQL, SQL Server Analysis Services, SQL Server Integration Services, Business Intelligence Development Studio (BIDS),Power BI Pivot, SQL Server Reporting Services, Net (Asp .Net,VB.net C# .Net), SQL server profiler, Team Foundation Server, Visual Source Safe.

Confidential

Sr. SQL SSIS/SSRS/SSAS Developer

Responsibilities/ Roles:

• Understand user requirements and Data Model defined and developed by the business analysts
• Created functional specification document and technical specification document.
• Constructed OLTP and OLAP Databases.
• Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. ( Table , chart and matrix report ).
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2012.
• Generated several drill down and drill through reports using SSRS.
• Migrated data from SAS environment to SQL Server 2012 with SQL Server Integrated Services ( SSIS ).
• Created ActiveX script to execute VBScript.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• 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.
• Created packages to convert txt file to XML file.
• Created SSIS packages through .NET for incremental load.
• Migrated DTS objects to SQL Server Integrated Services ( SSIS) environment. Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Responsible for gathering business requirements to create business user reports.
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2012 with .NET applications.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard. Played a Content Manager role on report server.
• Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.
• Created Reports on top of the cubes.
• Expertise in creating SQL code for extracting, summarizing, aggregating or presenting data from database systems using report writer.
• Designed SSAS cube to hold summary data for Targit dashboards. Developed Cube with Star Schema.
• Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements.
• Created roles using SSAS to restrict cube properties.
• Created usage based aggregations in cube to minimize time for query retrieval from client tool Targit.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI’s on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Performed unit and system testing, troubleshooting and bug fixing in development and QA environments.

Environment: MS SQL Server 2012/2008, MS Access, Performance Point Server 2007, C#, ER Win 4.0, Visio, Informatica, MS SQL Analysis Services 2012, Business Objects 6.5.1/ XI r2, XML, ActiveX, MS Excel, Visual Studio 2008, Windows Server 2003, Oracle, Toad, ERWIN, Crystal Reports, Excel.

Confidential, Richardson, TX

SQL Developer/SSIS/SSRS/SSAS Developer

Responsibilities/Roles:

• Developed and optimized database structures, stored procedures, views, and user-defined functions for the Application.
• Design and create SQL Database, tables, indexes, and views.
• Responsible for Query optimization and Performance tuning. Performing query plans and making sure each and every query is using appropriate useful indexes.
• Responsible for gathering/refining requirements from the customer for developing reports.
• Developed physical data models and create DDL scripts to create database schema and database objects.
• Created SQL Server Reports using SSRS 2008.
• Developed Query for generating drill down and drill through reports in SSRS 2008.
• Uploaded reports on to the report manager and organized them in folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the SSRS reports. Designed and implemented stylish report layouts.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Efficiently implemented Error handling in SSIS
• Created SSIS packages to load data from various data sources Oracle,DB2 and Flat files
• Consolidate the data load into ODS using SSIS
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SSAS.
• Involved in writing MDX queries.
• Created Cubes from which data can be retrieved rapidly by enterprise information consumers
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Worked in Creating partitions and Designing various storage modes to increase the performance of a cube using SSAS.
• Provided day-to-day administration tasks like space and log management.
• Developed Backup and Recovery Strategies, and Disaster Recovery Plan.
• Configured Snapshot replication for reporting, user acceptance test and development servers.

Environment: SQL Server 2012/2008, T-SQL, SSRS, SSIS, SSAS, Team Foundation Server (TFS), Management Studio 2005/2008,Query Analyzer.

Confidential, Madison, WI

Sr SQL BI Developer

Responsibilities/Roles:

• Designed application that collects client transaction volumes for WSS Custody and Sub-Custody products, applies unit costs, and produces a monthly export to the T&SS Costing system (CIIS).
• Created Volume Automation to enable import and maintain unit costs and other reference data, as well as providing summarized MIS reports for administrative/integrity purposes
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Created functions and developed procedures to implement application functionality at the database side for performance improvement.
• Created and Modified T-SQL stored procedures/triggers to validate integrity of the data.
• Created DTS and SSIS packages.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created dash board to show the business performance.
• Created partitions and designed aggregations in Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Designed KPI’s in SSAS and imported them to Excel.
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created datasets for reports using T-SQL and stored procedures
• Responsible for maintaining cubes using SSAS and populate the cubes with the data.
• Responsible for Query optimization and Performance tuning

Environment: SQL Server 2008 Enterprise Edition,.NET Framework, XML, T-SQL, SSIS 2008,SSRS, SSAS,VisualStudio.NET IDE, Windows 2000 Advance Server, Windows 2003 Advance Server, ASP, MS Excel, MS Access. Visual Studio 2008

Confidential

SQL Server Developer/SSRS/SSIS

Responsibilities/ Roles:

• Installed and configured MS SQL Server 2008 Enterprise Edition
• Gathered user requirements from users and managers to better understand the business logic of the company and create database that fits their needs
• Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.
• Created SSIS package to get data from different sources, consolidate and merge into one single source.
• Created DTS packages for the data cleansing/transfer and transformation.
• Created DTS Packages using ActiveX Scripts to upload Data from Text files\
• Responsible for design and Normalization of the database tables.
• Implemented Extraction, Transformation and Load (ETL), Import, Export activities by DTS package
• Created custom and Ad hoc reports using SSRS 2008.
• Migrated data from text files and Excel spreadsheets to SQL Server databases using DTS
• Successfully migrated data to new location using Snapshot Replication, and implemented Merge Replication to support up to date record of Inventory Information.
• Created Views to replace old tables and created new tables with triggers to support new business needs.
• Modified the current stored procedures using Visual Source Safe 6.0 to meet current design.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.
• Created custom stored procedures and function to support various new operations.
• Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.
• Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: SQL Server 2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2003/XP

Confidential

SQL Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Written various T-SQL Statements for the purpose of application development.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Coordinating user acceptance testing amongst business users.
• Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.

Environment: SQL Server 2000/2005, T-SQL, and Windows XP/2005.