PROFESSIONAL SUMMARY:

• Over twelve (12) years I.T. experience, where I worked on small to large - scale enterprise and performance critical applications.
• Designed data marts and data warehouses. Managed local and Chinese staff.
• Numerous years accounting and or financial experience as an accountant, accounting manager, financial consultant, and auditor.
• Wrote Technical Requirements (TRD), Functional Requirements (FRD), Test Plan, Data Dictionary, Stage-to-Target (STT), Length of Engagement (LOE) and other design documents.
• Managed the Logical Design of the Database & transforming it into a Physical Design.
• Scrum Master and Scrum member, I lead and participated in SCRUM activities, from the conceptual model to the logical model to the physical design.
• Also, I have stored and managed metadata and did data governance.
• Many years of accounting experience, inclusive of Accounts Payables and Receivables, General Ledger and Fixed Assets management, Manufacturing and Distributing Costing, Cash Flow and Budget preparation, Auditing, Payroll and Tax Preparation (including representing clients in court as their accountant), Balance Sheet preparation and Intercompany and Bank Account Reconciliation.
• Extensive experience in developing Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server 2000, 2005, 2008, 2008R2, 2012 & 2014.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Expert in using BI tools like Power View, Power Pivot, SSIS, SSRS, SSAS in MS SQL Server 2005, 2008, 2012 and 2014.
• Also, I possess knowledge of Crystal Reports, Tableau, Informatica and Business Objects.
• Performed Data Modeling using Erwin. Expert ETL Developer using SSIS.
• Experienced in supporting a team of application developers for their .NET database application.
• Transformed data from various data sources using OLE DB and ODBC connections.
• Well experienced with DTS, BCP, Service Broker and SQL Server Jobs for MS SQL SERVER.
• Expert in the Installation of Reporting Services in MS SQL SERVER 2005.
• Exceptional Computer Science background with programming skills in VB6, VB.NET 1.1, 3.0 & 3.5 and ADO.NET 2003 as a Junior Programmer.
• Worked extensively on system analysis, design, development, testing and implementation of various projects.
• Also, I possess very good knowledge of Kimball and Inmon methodologies.
• Also, I have experience with Embercado, Board reporting software, Progress DB, PGP, FTP and Secure FTP.
• Excellent verbal and written communication skills, also I am excellent at customer facing interaction, customer service and presentation.
• Self-Motivated and possess the ability for critical thinking, analysis, good interpersonal and communication skills.
• Technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Excellent knowledge of health care, finance, manufacturing, sales and insurance industry applications.
• Ability to prioritize and meet operational deadlines in a demanding fast paced environment
• Ability to work excellently as an individual contributor and as a proactive team member with minimum amount of supervision, with offshore or onshore teams.

PROFESSIONAL EXPERIENCE:

Confidential, Philadelphia, PA

BI Lead Dev

Hardware and or Software Used: MS SQL Server 2012 & 2014, MySQL, SSAS, SSRS, SSIS

Responsibilities:

• Designed data integration and analytical products. Ensured data quality, data security and data governance.
• Designed, developed, and administered databases. Designed architectural and technical documents.
• Created SSRS reports with MDX queries. I created many PowerBI reports from the SSAS cube and the SQL Server OLTP database.
• Used data engineering best practices both in modern data lakes and traditional data warehouse eco systems, which are scalable for disparate types of data (Structured, Semi-structured and Un-structured) and different departments within a company.
• Ensured sound operational database environment. Oversaw and supported key strategic projects.
• Helped to form new standards and processes for warehouse and BI development. Maintained the enterprise data model, business definitions of data, approved modeling tools, database technology buy list, enterprise metadata repository, enterprise data warehouse, database health and metrics.
• Worked closely with other Report Developers, Analysts, and Business Stakeholders, to provide guidance, analysis, and estimates of effort for new warehouse and analysis requirements.
• Provided insight and guidance into potential selection of effective outputs. Helped to guide the work of other members of the warehouse team.
• Collaborated with QA and Integration staff on the data warehouse team.
• Communicated and worked with the Enterprise Infrastructure Team, to as much as possible, standardize the warehouse functionality and processes across on-premises data warehouses and

Confidential

Tech Manager / Lead Dev

Hardware and or Software Used: MS SQL Server 2014, MS SQL Server 2012, Tidal, Hadoop, Hive, Pig, Tez, SVN, Erwin, Tableau, Informatica, Jira and RedMine

Responsibilities:

• Manage our China GDC staff and assigned tasks as appropriate, within our data warehouse solution.
• Modeled the dimension and fact tables in the data marts and data warehouses. Designed pre-calculated tables only when necessary and de-normalized as necessary. To prevent performance degradation, I judiciously applied slowly changing dimensions (SCD) type 2 dimensions.
• Manage modifications to our Insurance solution, by ensuring new and or modified objects are in SVN and details are stored in Jira or Redmine tickets.
• I also ensured that every change was done properly and reviewed code before our data warehouse solution was modified.
• Track the data marts and data warehouse development, by leading and participating in SCRUM activities, from the conceptual data model to the logical data model to the physical design.
• I have stored and managed metadata and did data governance.
• Created and or modified tables, indexes (Sparse, Column Store and Filtered etcetera), stored procedures, statistics, jobs, views and functions and other database objects within our data-marts if necessary. Implemented Id creation and maintenance, utilizing surrogate keys to hide sensitive data and lookup tables to get the latest values.
• Designed snapshot fact tables, to show the latest state of measures.
• Created a time dimension (conformed dimension) script, which created and populated a time dimension in any data mart.
• Prepare project plans and set and meet deadlines for deliverables.
• Resolve issues that block development of the data marts and data warehouses.
• Also ensured that database and data warehouse design best practices were followed.
• Lead projects (lead the Wealth project for some time) and assigned tasks to Senior Developers.
• Report on data mart development status and manage the full SDLC and DBDLC (DBLC). Created Master Data Management (MDM) for customers, to show a single version of the truth in the dimensions, to improve data quality.
• Designed solution architecture, which included Tidal jobs, SSIS packages, Database objects etcetera for different data marts and data warehouses, using both star and snowflake schemas. Implemented fact-less fact tables, without any measures, to assist with the relationship to dimensions.
• Wrote DOS scripts to call GPG4Win Kleopatra to automatically decrypt files.
• Created and ran report in Tableau. Implemented data mining techniques, non-additive measures of percentages and ratios, averages, min and max functions of semi-additive and additive measures. Designed junk dimension, to store indicator values, to reduce performance issues in the fact tables.
• Extracted and loaded data using SSIS and Informatica. Converted SSIS packages to Informatica Workflows.
• Created Hadoop tables, used Hive, Sqoop, Pig and Tez scripts.
• Wrote Technical Requirements (TRD), Functional Requirements (FRD), Test Plan, Data Dictionary, Stage-to-Target (STT), Length of Engagement (LOE) and other design documents for new or modified functionality. Lead and or participated in the requirements gathering and analysis, logical design, physical design, testing (automated), implementation and deployment, modification, monitoring and maintenance of the entire project for the data marts and data warehouses.
• Managed, created and modified data marts, Development and Production Environment (database, scheduling etcetera.). Did both top-down and bottom-up data warehouse designs. Participated in table partitioning and column store index creation.

Confidential, NY, New York

Lead ETL B.I. Architect

Hardware and or Software Used: MS SQL Server 2008R2, Board (Reporting Software), SAP, Erwin and Embercado

Responsibilities:

• Implemented Microsoft Change Data Capture on approximately ninety-five (95) databases.
• Partitioned the hard drive to separate, MSDB, TempDb, Backups, Applications, Transaction Logs and the data files.
• Created the Development, Stage and Production SQL Server environments.
• Installed and configured SQL Server 2008R2 on Dev, Stage and Prod.
• Implemented SQL Server maintenance Jobs, to maintain the databases, like indexing and statistics jobs.
• Created compressed log and full backups. Capped SQL Server memory usage.
• Designed an index maintenance database, which checks every database on the server and makes index creation or deletion recommendations.
• This was done because they use SAP, which creates a new database for each new branch or location that the Confidential opened.
• Designed SQL Server jobs to load the ODS every hour, the processing and loading of the ODS took approximately fifteen (15) minutes each time it ran, to get the data from approximately ninety (95) databases.
• Implemented a custom change data capture, which used a hash function (SHA1) to identify changed records.
• This along with Microsoft CDC updated the destination data by merging changes into it.
• Used Embercado and then switched to Erwin, to model the data.
• Created the ODS database, all indexes, custom statistics, automatic index recommendations (for data growth) and all stored procedures etc.
• Implemented logging, auditing, email error alerts and history retention for the ODS.
• Decided on which databases would be in simple recovery or full mode.
• Created code to kill long running transactions of the ODS.
• Designed the ODS and the Microsoft CDC code to return data for every new database created, along with the data from the existing databases.
• Designed an automatic restart process, just in case the main Custom CDC or the Microsoft CDC failed. This process quickly loads the destination tables, by truncating then loading, instead of merging.

Confidential, Orlando, Florida

Senior MS-SQL Server / Report Developer

Hardware and or Software Used: MS SQL Server 2008, SSIS, SSRS, T-SQL, TFS, BIDS 2008 and 2010, HEAT, SMS and Project Book,, VSS, Visual Studio

Responsibilities:

• Granted access to SSRS reports.
• Tuned the reporting database for the reports, by creating and modifying indexes, statistics, queries and SQL Server Jobs.
• Did basic presentation models in Visio then used Erwin to create models with more detail.
• Transfer database tables, views and programmability objects from DB2 to SQL Server 2008R2.
• Designed the OLAP logical and physical model, inclusive of the dimensions and fact table, which were a part of the data warehouse solution, using Erwin and SQL Server.
• Reverse engineered the physical model from SQL Server to Erwin; enhance the model to include in documentation.
• Used the row count transformation to keep track of the rows processed and write the data to a text file
• Utilized the multicast transformation to make copies of the data set to enable various conversions and profiling of the data.
• Lookup transformation was employed to find users that were in one database only or those that were in the French database with a slightly different name but were the same person in the USA database.
• Sequence containers were used to enable “if-then” conditional processing of multiple data sources and clean up tasks.
• Wrote rollback scripts for the conversion / export. Rollback scripts were both DDL and DML.
• Analyzed the schema of Goldmine etc. and created similar schema to import data into the Conversion environment.
• Used Package Migration Wizard to convert DTS packages to SSIS packages.
• Used jobs to schedule the SSIS and DTS packages. Created email alerts on package success or failure.
• Created events (OnError, OnTaskFailed and the OnPostExecute) to track data loading and store the information in text files.
• Created dynamic connection strings via variables in the connection string in the expression editor after selecting ConnectionString in the properties of the connection object.
• Used the Conditional Split to redirect rows depending on their values. A Merge Join was used to join common datasets
• Wrote custom code within SSIS to parse names etc. last names, salutations, first names, prefixes, suffixes and titles
• Create scheduled jobs to run the packages at the most convenient time
• Developed SSIS Templates which can be used to develop SSIS Packages in such a way that they can be dynamically deployed into Conversion and Production Environments
• Transfer the data from the staging / conversion environment to the live environment after user verification.
• Gathered and analyzed requirements for all the support services performed.
• Documented my requirements and test results (unit and regression tests) then get the requirements signed off.
• Configured and maintained Report Manager and Report Server for SSRS on Test server.
• Used expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report.
• Developed SSRS drill down, drill through, chart, cross-tab and sub reports. Scheduled the monthly/weekly/daily reports to run automatically.
• Involved in Debugging and Deploying reports on the production and UAT servers by modifying the RDL files using XML.
• Configured the report viewing security for various users at various levels using Report Manager.
• Documented and prepared project status report updates and audit reports.
• Used query plans to help optimize queries and stored procedures.
• Created MS Access reports. Created modules, forms and sub-forms using VB6.
• Used SQL Profiler to improve performance of stored procedures, ad-hoc queries and new reports.

Confidential, Tampa, Florida

Senior MS-SQL Server / Report Developer

Hardware and or Software Used: MS SQL Server 2008, SSIS, SSRS, T-SQL, Borland StarTeam.

Responsibilities:

• Created a modified version of the Tally Oh function from Jeff Moden.
• Created drill through, drill down and parameterized SSRS reports.
• Suggested changes to the requirements document then implemented the approved changes.
• Logged all database objects I created and modified in Borland StarTeam.
• Regularly interviewed offshore and USA potential SSRS, SSIS, SSAS and SQL Server Developers, at the request of my manager.
• In most of the interviews, I was the main Interviewer of candidates with SSRS, SSIS and SQL Server Developers skills.
• Participated in technical design, development and implementation of database requirements, which included creation, modification and deletion of databases, including the logical and physical database models for data warehouse applications.
• Automated data extraction, inclusive of initial data validation, lookups, un-compression, source file validation and email alerts.
• Adhered to Database Development Life Cycle by scoping, estimating, investigating, modifying and making suggestions about existing database structure and needs.
• Build and maintain data warehouse objects like indexes, dimensions, facts and views etc.
• Work with subject matter expert to evaluate current data quality, identify possible metrics to measure quality over time, implement metric collection and review process.
• Populate staging tables and log importation errors.
• Store and keep in-sync sample acceptable data to enhance data validation.
• Automate some data correction, based on sample acceptable data.
• Decode and encode ids and other sensitive data.
• Modified and or created views, SQL Server Agent Jobs, stored procedures, SSIS packages, ad-hoc queries and functions.
• Investigated, modified and made suggestions about existing database structure and existing programmability objects.
• Determined current areas of instability and duplication and developed resolution plan to address existing issues
• Brought the system to a point where it could be maintained without daily monitoring and adjustments. Set up self-monitoring and alert systems on critical areas.

Confidential

Senior MS-SQL Server / BI Developer

Hardware and or Software Used: MS SQL Server 2005 & 2008, SSIS, DTS, T-SQL, SSRS, SAP, VB.NET, ADO.Net, Windows XP, Windows 7.

Responsibilities:

• Optimized views, stored procedures, functions and SSRS reports by using SQL Profiler and the Database Engine Tuning Advisor.
• Optimized queries depending on the physical operators in the Execution Plan, the scan count, logical, physical and read-ahead read of existing T-SQL code.
• Improved the performance of queries which loaded column data variables, by using T-SQL XML.
• Created report metrics to track; total number of executions, average processing time, long running reports, execution patterns, popular reports, reports to be scheduled and reports with large outputs.
• Integrated SSRS reports in SharePoint and created a Dashboard, hosting was done and testing started for production deployment.
• Provided best practices for creating and maintaining programmability objects, indexes, reports, views, statistics and reports.
• Created, maintained, got dependencies and tracked database objects like SQL Server Jobs and SSIS packages utilizing normal ETL standards etc.
• Modify existing VB.NET and ADO.Net code for the JOR Approval program. Granted access to SSRS Reports and folders
• Created SSRS Parameterized, Drill Down, Drill Through, Sub, Chart, Dashboard and Scheduled Reports, with expressions to Calculate, Group and Filter data; some with XML data sources and custom VB.NET code etc.
• Use Team Foundation Server (TFS) for source control of programmability objects.
• Assist with the Data Center moving tasks, moving programmability and other objects.
• Traced SAP tables to SQL Server tables, then modified, queried, monitored their replicated data and created numerous programmability objects to use the data.
• Utilized the FTP task to send the finalized files to our partners.
• Used the file system task along with the script task to create a custom zip batch file
• Enable logging and used events and the email task to alert users, managers and IT personnel if an error occurred with the SSIS package, utilizing normal and advanced ETL methods.
• Created protected SSIS packages with login credentials. Created the logical and physical schema for the database.
• Loaded previous data from old Access database after data scrubbing and profiling.
• Created pivoted views at the database level to be viewed in the UI.
• Used VB.NET to create the front-end for some of the reports.
• Set up immediate saving and viewing (refreshing) of data through the data-grid views before the general saving of other data
• Encrypted user passwords for the application.

Confidential, Wilmington, Delaware

MS SQL Server / SSIS Business Intelligence Developer

Hardware and or Software Used: MS SQL Server 2000 & 2005, T-SQL, SSIS, DTS, Dbase and Windows NT / XP

Responsibilities:

• Profiled the data to check if it meets the company’s ETL data quality standards by using the Row Count transformation to count the records in the SSIS dataflow and store it in a variable, used the Multicast transformation to check the source data quality against a standard approved dataset and a Conditional Split to filter unacceptable data to flat files and SQL tables.
• Identified duplicate data by using an Aggregate transformation that groups data by contract id.
• An email task was used to point other team members and managers to the files with the unacceptable data and also state the data issues.
• A Percentage Sampling transformation was used to limit the profiling to partial datasets.
• Used the Fuzzy Lookup transformation to find the best Insured individual match (person that is being insured) by checking the Insured table.
• Used the Derived Column transformation to cleanse data, change column names and include additional columns.
• Use ForEach Loop to loop through all the files in the folder and save the location to a variable then used again in an SQL Task to delete the tables if they already exist and create the tables in the database with the exact names as the source files.
• Used one SSIS package to execute multiple SSIS packages in the same and also in different projects simultaneously.
• Used Copy Column and Data Conversion tasks to copy columns and change data types.
• Used the Multicast, Aggregate and Merge Join transformations to retrieve the most recent records and re-join them.
• Configured SSIS for logging. And used information from the SYSDTSLOG90 SSIS table to log package execution data and also used events to track inserts, updates and warnings.
• Used the OnError, OnTaskFailed and the OnPostExecute events to generate application specific log of inserts and updates etc.
• Converted DTS packages to SSIS. Performed Data Cleansing, Data Scrubbing and Data Migration.
• Made configuration changes and updated SQL Server generally and SSIS specifically to accommodate the ETL solution.
• Created, tested and modified stored procedures to fix identified problems with the software and improve functionality.
• Modified and tested User Defined Functions and Triggers to improve functionality.
• Created, modified and maintained Excel Pivot Tables
• Loaded data from pivot tables into SQL Server. Created data feeds using SSIS to load dimensions in the OLAP database
• Created linked server to pivot tables. Used pivot tables as views in front-end application.
• Migrated and upgraded databases from SQL 2000 to SQL 2005.
• Created scripts to test specific functionalities of the software and also made the requisite modifications when necessary.
• Worked on MS SQL Server tasks such as batch jobs, new builds (versions), and DTS and ad-hoc queries.
• Responsible for understanding the user requirements when creating SQL Server Reports using SSRS 2005 and also created some Crystal Reports.
• Identified and defined Data Sources to create data source views.
• Wrote SQL queries for various reports. Converted Crystal Reports to SSRS reports.
• Defined parameters for parameterized reports. Formatted the report layout for various reports.
• Modified SSRS XML file to enable reports that were created in SSRS 2005 to be published as SSRS 2003.
• Modified the Report Data Source Properties. Generated Reports using global variables, expressions and functions.
• Scheduled the reports with the subscription report wizard.
• Added new columns and expressions. Deployed the reports to the server.
• Gathered Requirements from the end user and checked the structure of the schema and data for SSAS cubes.
• Imported Metadata and Created Presentation Layer, Business Layer, Data Source layer, Physical Layer.
• Created Metadata Models and published package.
• Created dimensions and fact tables with type II SCD to preserve history, using the natural and surrogate keys.
• Created the structure of the model and cube in MS Analysis Services.
• Created Operational Data Store (ODS) to load data marts before loading the Data warehouse.
• Reviewed MDX Cubes with End user and changed the cube and documentation according to their Requirements.
• Defined aggregations and granularity that was required.
• Used SQL Profiler to test stored procedures and SQL statements.