SUMMARY:

• 16 years of experience in the industry as a Web Developer, Web Designer, Programmer, SQL Developer and DBA. With a focus on application development, Integration, Data Migration, Architecting Transactional Databases, Data Warehousing and Data Marts.
• Expert with Microsoft Platform tools like SQL Server 7.0/2000/2005/2008/ R2/2012/2016 databases, SSRS, SSIS, SSAS, Team Suites, and Control Source Interface.
• Expert in ASP, .Net, PHP, CSS, HTML, XML
• Expert in Data Migration between SQL Server and Legacy Database.
• Expert in Data Migration between SQL Server and MySQL database.
• Expert in Data Migration between SQL Server and other ODBC/OLEDB compliant databases.
• Expert in creating and executing SSIS packages using SQL Server Integration Services (SSIS), Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Well - versed with database Installation, configuration, maintenance, monitoring, backups and recoveries, developing and debugging Stored Procedures, Triggers, Views and User defined Functions, DB Performance enhancements & tuning.
• Used Performance Monitor/Profiler and execution plans to solve dead locks and/or long running queries.
• Expert in query optimization using several tools and efficiency standards including Indexes.
• Hands on experience in troubleshooting database issues including performance and installation issues.
• Expert in managing Alerts, Operators and Jobs through SQL Server Agent.
• Expert with SQL Server Email Alerts and Database Mail.
• Proficient in Google Analytics and Search Engine Optimization (SEO).
• Created table manipulations for Consistency Checks using DBCC Utilities.
• Worked extensively as DBA for tasks such as data loading, batch jobs, data unloading, backup & Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Highly Proficient in creating SQL Server Reports using SSRS 2005, 2008, 2012, 2016.
• Well versed in defining Data Sources for creating Data Source views and stored procedures.
• Expert in handling parameterized Reports using SSRS.
• Expert in deploying SQL Server Analysis Services Projects using MS SQL Server 2005, 2008, 2012, 2016.
• Well versed in defining advanced attribute and dimensions properties.
• Skilled in modifying the measures and dimensions of the Cubes.
• Very Well versed in designing queries for manipulating the multidimensional data stored in OLAP cubes using MDX, Exporting MDX queries to SQL Relational database.
• Skilled in analyzing data in software like Tipco Spotfire and Tableau.
• Expert in defining granularity within a measure group and drill through actions.
• Possess strong communication and problem solving skills and proven abilities in team leadership providing proactive support.
• Expert with working in teams with any magnitude.
• Experience with working with Scrum development methodology with Agile approach.

TECHNICAL SKILLS:

Database Technologies: SQL Server 7.0/2000/2005/2008/ 2008R2/2012/2016, Paradox, MS Access, MySQL, MS ADO, MS RDO, MS DAO, ODBC, OleDB, SSIS, Oracle, OLAP, SSAS, SSIS, ETL, SSRS

Packages: Visio, Microsoft Project

Languages: C#, Visual Basic, VB.Net, PL/SQL, T-SQL

Software Suites: Microsoft Office, Lotus SmartSuite, Visual Studio 2005/2008/2010/2012, Visual Source Safe, VS Team Explorer, VS Source Control, Microsoft Project, MS Visual Modeler, MS Office, TOAD

Analytics Software: Tipco Spotfire, Tableau, Cognos, Business Objects, Hyperion

PROFESSIONAL EXPERIENCE:

Confidential

BI Lead Architect & Developer

Responsibilities:

• Evaluate, architect and develop a solution to import Nielsen research data into a new data warehouse
• Setup reporting on top of the data using PowerBI and SSRS. These reports are used to compare data between two time periods
• Remove bugs from existing Booth Data Warehouse (BDW)
• Remove bugs and enhance performance on current SSIS packages that feeds into BDW
• Create SSIS packages to bring new sources and data into existing BDW
• Provide optimized views and queries for Business Objects reports

Confidential

.Net Developer

Responsibilities:

• Migrated contacts, courses information from Mindbody CRM to Microsoft Dynamics
• Created architecture and developed all SSIS packages
• Created all jobs to schedule daily loads
• Created new pages and updated existing Wilton School website using MVC 4 in C#
• Integrated Demandware widgets with Wilton School website pages
• Migrated data between Microsoft Dynamics 4.0 to Microsoft Dynamics 2013
• Created SSRS reports for an automation process
• Held small classes to teach the staff and managers on how to use and develop using SSRS and SSIS

Confidential

Business Intelligence

Responsibilities:

• Assisted with requirement gathering from hospital databases
• Designed, Developed rolled out the complete BI product for the company
• Played the role of a Lead Technical Architect. Designed the Technical Architecture of the database solution
• Created architecture and designed all for the data warehouse and operational data store (ODS) databases
• Created architecture and developed all SSIS packages
• Created all jobs to schedule daily loads
• Handle Patient de-duplication process, orphan records, fact table validity
• Improve queries by applying industry best practices on Indexing, performance tuning
• Work with Change Tracking to migrate updated data to Warehouse on hourly basis

Confidential

BI Developer

Responsibilities:

• Part of 3 developers in BI Integration team responsible for creating SSIS packages and stored procedures to migrate data from over 400 legacy tables into SQL Server 2012.
• Lead in creating Gap Analysis report to figure out what source fields got missed during migration
• Created/Reformed one time pull SSIS packages (Seed Migration)
• Created over 400 stored procedures to be used with dynamic SQL to be called inside incremental load packages
• Created logging inside SSIS and stored procedures for exceptions and error records
• Implemented SSIS framework to run all packages either parallel or sequential based on parent child relationships within the destination database
• Created over 80 SSRS reports to search for data anomalies
• Wrote VB.Net code, Excel macros to handle data migration differences & gaps

Confidential

BI Architect Manager

Responsibilities:

• Created best practices and naming convention to implement in all packages used by the entire team
• Educated team members on SSIS and proper way of utilizing SSIS to the fullest potential
• Created complicated stored procedures to create RAF score
• Created reports for physicians (Clinical chart review, Demographics data, code clearing) on SSRS
• Created master reports along with sub reports so that individual report can be sold separate to the client on a subscription model.
• Created POC on Tableau for analytical purposes and demonstrated it to the entire team including product owner

Confidential

Senior BI Architect

Responsibilities:

• Joined the company that had no SSIS structure so I developed and trained staff on SSIS
• Created best practices and naming convention to implement across the company developers.
• Created SSIS framework from scratch to perform logging, error handling, status, job management and timings.
• Worked with SolidQ mentors to implement a data warehouse ETL framework.
• Attended PASS Summit 2010 in Seattle, WA to get latest knowledge on the entire BI Stack (SSIS, SSAS, SSRS)
• Created brand new cube sitting on top of new Data Warehouse for Website Analytics. The cube had analytics for multiple months with extremely high volume.
• Created brand new OLAP cube for Online Reporting and Customer Reporting. The cube had daily aggregated information for multiple years with relatively low volume of data for faster query performance.
• Created new reports and updated existing reports (Online Reports, Customer Reports) that sourced information from the SSAS Cube.
• Wrote complex MDX queries to pull information from the cube into the reports.
• Attended several sessions on Power View (Project Crescent) and SQL 2012 (Denali)
• Managed partitions and complex dynamic portioning on databases and cubes.

Confidential

SSIS & SSAS Developer

Responsibilities:

• Client had a need to import new dimensions and fact regarding user’s online orders and call center orders to the data warehouse in SQL Server 2008 from ODS.
• Created connections to the ODS PostgreSQL database.
• Created SSIS packages VS 2008, with XML and database configurations.
• Performed unit test, functionality test and environment testing on each package before the package was migrated to production environment.
• Wrote queries to optimize the performance and make the process faster due to the number of records passing through the package.
• Created Analysis Services Cubes with multiple prospective to display the new dimension relative to the existing dimensions.

Confidential

SSRS/Report Builder Expert

Responsibilities:

• Part of the conversion team to deploy and implement SQL Server 2005 BI-Stack company-wide.
• Actuarial reports were running on mainframe operating system and the goal was to migrate 50+ reports to report builder, Microsoft Access and eliminate the use of mainframe reports.
• Created reports using report builder 2005 software for the actuarial department of the company with complex calculations and formulas.
• Created views and stored procedures for report builder.
• Most of complex calculations and formulas were created in user-defined functions and views.
• Created presentation and report builder demos and for all employees in the company to learn the new tool.

Confidential

Senior DBA and SSIS Expert

Responsibilities:

• Created a Business Intelligence data mart to manage customer listings and to better segment targeted emails and direct mails to the customers.
• Created SSIS packages to automate input from third party source information into specific tables.
• Created business logic into SSIS packages to generated custom Surrogate keys in the BI database.
• Generated data sanity checks in the SSIS packages using Derived columns & Scripting tool to ensure database integrity.
• Utilized Slowly Changing Dimension model of SSIS to populate information in dimension tables.
• Transformed the SQL Server 2008 database into fully relational solution.
• New database was created with data warehouse model of Fact and Dimension tables. This design made a simple and unique approach for the management reporting.
• Implemented Indexes, Full Text Indexing capabilities for better search performance.
• Optimized views, queries, stored procedures and User defined functions to optimize database overall performance at runtime.
• Created new and fully optimized tables for new promotions introduced by the company.
• Monitored the production database performance logs, transactional logs, active queries to ensure developer’s adhoc queries are fully optimized.
• On issues with queries, review .Net code with programmers and modified queries and .Net code.

Confidential

Senior SSIS Developer

Responsibilities:

• Part of a six people team to develop a secure data warehouse that will be used for companywide data and business logic storage.
• Created a data warehouse to streamline the aggregate earnings, claims and receivables for the company’s clients.
• Used SCRUM based methodology with two week iterations to complete tasks.
• Part of requirement gathering team, on data migration to PeopleSoft AP, Billing and GL Interface, along with two Business Analysts.
• The project was developed with an agile development approach.
• Extensively used SSIS to communicate information between front-end interface, data warehouse and PeopleSoft AP, PeopleSoft Billing and Peachtree GL interfaces.
• Unified SSIS logging and configurations were used to ensure the correct connectivity of each source and target.
• Created several SSIS packages to migrate information from legacy system into SQL Server 2005 database with Visual Studio 2008 & team explorer used as a backend developing tool.
• Used DBPro to ensure the unity of database schema and lookup / dimensional table data across the local environment, development, staging, UAT and production environments.
• Source control was used as a central repository for database, code and SSIS packages.
• Wrote Tests in DBPro as part of unit testing on each environment. The tests were included in the build process to ensure successful deployment.
• Applied Diff-build strategy to deploy new items and updates to production.

Confidential

Lead .NET/SQL Developer

Responsibilities:

• Lead Developer and Database Programmer amongst a team of 5 developers and designers.
• Technical Lead in Web page Design, Database Design and Development, Coding and Documentation based on established quality standards.
• Used Master Pages, User Controls, Custom Controls and CSS to get the same look and feel throughout the site.
• Created robust search utility that searched through over 100,000 unique events and attractions.
• Developed Input Validation controls, Web Form Server controls, client Side validations and Regular Expression using ASP.Net, Java Script, and AJAX for the search section.
• Implemented predictive search functionality through the use of AJAX that predicted user input based on first few typed characters.
• Worked on Store Procedures, Functions, Triggers, Indexes and Views using T-SQL.
• Lead in developing the reports using Crystal reports, SQL reporting (SSRS) and Integration services (SSIS).
• Created a Business Intelligence data mart to manage customer listings and to better segment targeted emails and direct mails to the users who have previously visited the site.
• Created SSIS packages to automate input from third party source information into specific tables.
• Implemented Indexes, Full Text Indexing capabilities for better search performance.
• Analyzed and fixed the bugs reported. Involved in resolving Production issues.

Confidential

Senior Developer

Responsibilities:

• Lead in gathering requirements for this Customer Relationship Management (CRM) tool.
• Designed and architected the relationship model, database and laid out the programming milestones.
• Created a new database for CRM holding fully relational tables, optimized views, and stored procedures for inserts, updates and complicated queries.
• Created a backup and disaster recovery plan for the database.
• Migrated all fact and dimension data from several sources using SSIS, DTS and Flat file sources.
• The CRM tool was designed to handle three levels of administrative hierarchy for data access.

Confidential

SSIS Developer

Responsibilities:

• Created ETL’s in SSIS for SQL Server 2005 for enterprise reporting team.
• The package gathered 26 months worth of data on customers, orders, products, account mangers, sales, invoices and hierarchy structure of account managers.
• This information was translated into useful Data Mart tables in SQL server 2005 that was to be presented as useful sales information for the sales and marketing department.
• The total number of records in one weekly report was approximately 350 Million records.
• Used source tables from Data warehouse and AS400 based ERP system of the company and target Dimensions and Fact tables in Data Mart designed for ER Team.
• A combination of extremely efficient queries and data flows made the entire package very unique in utilizing minimum server resources to maximize the potential.
• Load balancing on SSIS and SQL server was heavily stressed to minimize the runtime of the package and allow time for other packages during the night.

Confidential

Senior Developer

Responsibilities:

• Created Complex ETL structure for the client to determine the profitability of the partners and products.
• The profitability of partners was dependent on several complex business rules and logic. Converted this logical information into data and created data mart tables to be used as source for XL cubes.
• Source information for SSIS data flows was obtained from PeopleSoft, AS400, SQL 2000 Data warehouse, Excel spreadsheets and Microsoft Access databases.
• Created SSIS data flows and pulled information from the source tables, created aggregates on millions of rows to determine the profit percentage for a partner in a particular quarter.

Confidential

Senior Developer

Responsibilities:

• Lead SQL Developer
• Created queries for Oracle in TOAD to pull daily sales, customer and product information.
• This information was used as the source for a SQL Server 2005 based application for Abbot Laboratories.
• This info was transferred using Informatica ETL tool into flat files. Similar transfer of info was made for historical feed from SQL to Oracle.
• Created highly optimized queries to pull information from Oracle tables.
• The queries pulled relational information between customers, products, invoices, purchase orders for a specified time period.
• The relational information was processed through an automated QC process to make sure the integrity of the information.

Confidential

Project Manager

Responsibilities:

• Managed a team of 6 people with various skill sets.
• Designed the architecture of SSIS packages for company-wide infrastructure database migration from MySQL to SQL Server 2005 with 250+ tables.
• Implemented Transactional Replication on the entire Database, and replicated it to two remote locations.
• Created two-step Project Solution to migrate 7 GB of data from MySQL to SQL Server 2005.
• A set of manual and automated QC processes were created to ensure there was no data corruption during migration process.
• Lead a team of 3 .NET developers to update the code for the website, company-wide used Dashboard application and several other communication tools. This upgrade was required for the code to work with SQL Server 2005 database.
• Made sure all the project requirements were met at every one of the three tiers of the code.
• Entire code was placed inside version control software (VSS). This way all modifications were made to the code using a check-in and checkout procedure.
• Created and implemented QC procedures and solutions to ensure the integrality of data.
• Lead a team of QA testers. Compiled & created test cases and scenarios. Created a system of unit testing, functionality and usability testing.

Confidential

Lead Developer

Responsibilities:

• Lead in the requirements, design, development, rollout, and support phases of this project.
• Worked with the Marketing division of this Lighting Company in order to align their overall marketing strategy with their online identity. Purpose of the project was to synchronize multiple sub brands so that they were working together online towards same strategy already established in their print marketing campaign.
• Designed a web strategy for the company to follow. Strategy called for integrating the databases for sub brands associated with the parent company and have them interact with each other in order to market across brand lines.
• Created a hub database for the company that outlined and summarized the benefits of all sub brands.
• Created a larger database with entire Product Catalog combined with Brochure Downloads, Lighting Examples, Contact, and Product Descriptions information.
• The new database was configured to be fully Relational, with multiple optimized views, stored procedures and User Defined Functions to optimize run-time database queries.
• Created local and remote backup plan for the catalog database.
• Put efficiency measures and created Indexes on the database to ensure peak performance.

Confidential

Lead Developer

Responsibilities:

• Lead in requirements, design, development and rollout and support phases of an application that was built on PHP front-end and MYSQL database.
• The application helped the employees reduce their heavy load of manual paperwork by automating numerous procedures previously done by hand.
• Made application mobile and enabled sales force to use access information from the road.
• Created daily, weekly and monthly sales reports for the President and regional sales managers of the company.
• Created and saved queries with extreme performance measures.

Confidential

Lead Technical Architect

Responsibilities:

• Lead in the requirements, design, development, and rollout and support phases of the project.
• Staffed and managed a development team of four individuals. Assigned roles and responsibilities to team lead.
• Developed a Real Estate database solution that integrated with the MLS database and showed a listing of homes currently on the market.
• Created the architecture and designed entire database for an E-Commerce portal for a Real Estate Training School. This portal integrated with the Authorize.net server and charged students as soon as they registered for their classes.
• SQL Server 2000 Triggers were utilized with heavy usage of Stored Procedures to manage the flow of information among tables, applications.

Confidential

Lead Technical Architect

Responsibilities:

• Lead in requirements, design, development and rollout and support phases of the project.
• Developed a customized ERP solution for the growing customer database and functionality requirements of the company.
• A single transactional SQL database replicated across two locations provided data for all users accessing the system across North America.
• Implemented Slowly Changing Dimensions to the inventory of the coolers that were rented out on customer site.
• The system handled sensitive customer information so many checks were in place to encrypt the data within SQL Server. Many triggers were put in place to keep up with the business logic.
• Created complicated stored procedures to handle logic for creating invoice, updating inventory, updating customer balance and order status.
• Created views and User Defined Functions to handle the order generation process.

Confidential

Lead Technical Architect

Responsibilities:

• Created complex Access based reporting system with multi-level user access to the reporting system. These reports were compiled using Microsoft Access 2000 reporting and heavy use VB programming.
• Microsoft Access links to SQL server to create the following kind of reports for the system:
• Complex sales tax reports for annual tax purposes.
• Daily and weekly sales people activity reports for managers.
• Daily reports on service technicians’ activity to monitor their performance and commissions.
• Daily invoice and payment register for accounting.
• The reporting system also confirmed and corrected postal addresses on the invoices using third-party postal software.

Confidential

Lead Developer

Responsibilities:

• Lead in the requirements, design, development, rollout, and support phases of this project.
• Played the role of a Lead Technical Architect. Designed the Technical Architecture of the database solution.
• Designed and modeled the data environment as well as performed all DBA functions on SQL Server 2000.
• Created Triggers, Stored Procedures and Views to perform various functions.
• Continue to maintain and enhance the system

Confidential

Project Manager

Responsibilities:

• Lead project manager in requirements, design, development and rollout and support phases.
• Developed Windows CE based application.
• Designed for service technicians who take customer information and signature as a receipt of the repair.
• Designed software so that the customer signature is saved as an external jpeg file with other customer information.
• Designed database & software to have the capability to email the information to the Company Headquarters.
• Developed trigger to transfer information to the current ERP system of the company.
• Made system improve the efficiency of the service technicians, gives more control to the managers to oversee the technicians, reduces paperwork of the headquarters to a bare minimum and allows company headquarters to capture real-time information about the service technicians.

Confidential

Lead Technical Architect

Responsibilities:

• Created Microsoft Access XP forms to read barcode information from linear/maxicode barcodes and integrated the results into their ERP system called BPCS. These data from these barcodes was used for job time management. Also, the statistics from the information gave useful information on future quoting of the job-time and performance bonuses to employees.
• The Access Form/reporting system performed following operations:
• Access forms read maxicode barcode with employee number, job number, time and date a particular job started.
• The start time and the end time of these jobs were compiled in a report for managers.
• With a click of a button the information was sent out to BPCS.
• These reports and forms were created using heavy use of Macros and queries.