CAREER SUMMARY:

Over 13 years, my career focus has been centered around Business Intelligence and Data Warehouse system design, with comprehensive hands - on expertise in Software Development, Data Warehouse Architecture, Big Data, SQL / ETL / ELT Development, BIA Applications and Reporting Development, with the ability to apply technical skills for business resolutions and the ability to switch easily between different projects with the flexibility to handle rapidly changing environments. Thus, allowing the application of extensive experience across multiple RDBMS and platforms has provided a strong aptitude for multidimensional database design coupled with robust operational architectures.

CORE SKILLS:

• SQL Server 2000/2005/2008- R 2/2012/2014/2016
• Confidential -SQL, PL/SQL, BTEQ
• Oracle 8.05 / 9i / 10g / 11g
• UNIX Shell Script, XML, Bash, WinSCP, Putty
• Teradata v13, MYSQL v5.6
• Course work - Perl, Python and .Net
• MS Visual Studio 2000/05/08/12/14
• Knowledge - Java, JavaScript, C , C++, XHTML
• UNIX/Linux
• MS Query
• TFS (Team Foundation Services), Azure Data Catalog
• BI / ETL Case Tools
• Microsoft - SSIS, SSRS, SSMS, SSAS
• SSRS
• Informatica v9.2
• Tableau
• Pentaho (Kettle)
• Power BI Desktop
• DataStage, DJ Cosmos, Data Junction
• SharePoint
• TFS (Team Foundation Services), Azure Data Catalog
• OBIEE, Crystal Reports, Brio and DCU
• TOAD v12.1
• Microsoft Office 2016
• Oracle PL/SQL Developer, SQL Navigator, SQL Plus
• Erwin r7, Power Designer, Visio, Siebel Analytics
• Version Control (svn Tortoise), SourceSafe
• Scheduler (Tivoli) and many other analytical tools
• Creative thinker - ability to think outside of the box to resolve complex issues

WORK EXPERIENCE:

Confidential, Alpharetta, GA

Sr. BI Developer / DBA

Responsibilities:

• Wrote complex SQL queries, stored procedures, functions, triggers, indexes, table variables and temp tables to satisfy business requisitions. SQL Server and Oracle.
• Created complex ETL processes to move data from Oracle and other data sources to SQL Server DB using stored procedures and/or SSIS packages.
• Created and maintained SSIS packages to load data into Data Warehouse using Various SSIS Tasks and Transformations, like Execute SQL Task, bulk insert task, execute package task, send mail task, Transfer database task, for loop & for-each loop containers, aggregate, merge, merge join, Pivot, etc...
• Created an in-house data security model in Oracle for all the data that will be accessed by the developers and end-users. The security model has all the user’s information grouped into roles which in turned defined what data a specific role can have access to. Reports on Who, When, What and Where the data was accessed and/or modified.
• Mentored Jr. Developers with MS SSIS and coding.
• Performed root cause analysis of infrastructure problems and made modification and/or recommendations to stakeholders.
• Worked on a cross-functional team using Agile/Scrum development methodologies.
• Conducted peer code reviews and made recommendations in line with best practices.
• Planed, coordinated, and administrated database systems, including base definition, structure, documentation, requirements, operational guidelines and protection
• Worked with internal customers to develop new value-added programs and data solutions with existing data warehouse structure.
• Analyzed and determined information needs and elements, data relationships and attributes, data flow and storage requirements, and data output and reporting capabilities.

Confidential

Sr. BI Developer Consultant

Responsibilities:

• Worked on various projects with the below listed companies in efforts to create and/or maintain data solutions using a multitude of technical tools to complete the assignments.
• Utilization of advance skills in creating Star / Snowflake schemas, Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts, ETL process and workflows and numerous stored procedure consumed Confidential various stages of migration/cleansing process, reports or data validation. Worked on multiple projects with multiple stakeholders on Agile, Scrum and/or Waterfall SDLC methodology and convey Analytical findings accordingly both written and verbal.

Confidential, Atlanta, GA

Sr. ETL Developer

Responsibilities:

• Designing, development, documentation of the Data Warehouse models.
• Developed Pentaho ETL processes from various data file types into MySQL.
• Assisted in ongoing development of technical best practices for data movement, data quality, data cleansing and other ETL related activities.
• Provide technical knowledge of extract, transform and load solutions for auto billing project.
• Conducted root cause analysis, thus identifying data anomalies and resolved UAT / Production problems and applied / documented resolutions.
• Performed Data validation and created test cases according to business requirements
• Implemented best practices and performance tuning for automation and optimization.

Confidential, Macon, GA

Sr. BI Data Architect / Developer

Responsibilities:

• Supported multiple projects in efforts to define and manage the data sets and structures as required and for managing the distribution, replication and archiving of data throughout the EDW.
• Assisted in the creation and maintenance of database models for OLTP (Online Transactional Processing), Dimensional Modeling using Kimball Methodology, Star/Snow-flake schema design and ETL Architecture for Employment EDW.
• Responsible for extracting and transforming data from Legacy systems into staging and then Data Warehouse.
• Created data models for Cubes, Dashboards, and real-time reporting solutions
• Monitored BI usage capture and maintenance of metrics. Developed and managed the BI dependency plan, job scheduling and cycle management.
• Mentored Jr. Developers on developing SSIS process for project.
• Researched and evaluated alternatives and recommend solutions for business needs.
• Created and maintained automated ETL processes by coding, testing and implementing ETL mappings and scripts.
• Utilized Microsoft-Visual Studio-Team Foundation Server platform to process stories and create/maintain SSIS Catalog.
• Maintained data integrity, restorability and appropriately handled data loading errors
• Agile /Scrum methodology

Confidential, Atlanta, GA

Lead BI Developer

Responsibilities:

• Assisted with the design of the Enterprise Data Warehouse as well as supporting domain specific data marts and associated analytical capabilities.
• Used Pentaho to Extract, Transform and Load data from various sources into DB.
• Extracted salesforce.com database using SOQL&SOSL queries using Force.com Explorer and Pentaho.
• Design of robust, user friendly applications using a wide range of BI tools. Assisted the business and Supply Chain IT teams in troubleshooting technical issues and provided guidance and support in the design and implementation of enhancements to databases, ETL processes, and analytic tools.
• Supported the development of program backend processes, business requirements and program specifications; Worked with Hadoop developers to import/export data to Hive using Sqoop.
• Support business in determining client needs and solutions via client Stories.
• Document best practices and standards for using BI tools and solutions.
• Used a wide array of BI systems and tools.
• Collaborated with IT management to define enterprise data architecture strategy. Researched /analyzed legacy systems to convert to MySQL DB and created ETL processes via Pentaho.
• Assisted with the creation of project timelines and worked closely with management team to design application data flow and processes, created and maintained various legacy systems.

Confidential, Sandy Springs, GA

Sr. SQL Developer

Responsibilities:

• Worked with .Net developers to build BIA web applications and resolve application issues. The ability to read C#, C++ code in efforts to assist the .Net developers with resolutions and development.
• Created SSIS packages to extract data from flat files, Teradata, Oracle and DB2 and transform the data according to the business requirements and load the data in SQL server tables.
• Performed Incremental Loads, Data cleaning, Error handling, and logging using Event Handlers using SSIS.
• Created and maintained scalable solutions based on business specifications, knowledge, and current data to support Confidential web applications and Reports via Power BI Reports and Dashboards.
• Designed and implemented database scheme and process flows including writing advanced SQL code to develop stored procedures, triggers, functions, Informatica and SSIS/SSRS processes. Developed, analyzed and executed system test plans;
• Worked closely with management and other teams to maintain application accuracy; analyzed company data to determine the necessary data constraints and to resolve data anomalies.
• Analyzed various web-based applications for performance related issues; and took full ownership of applications as it relates to automating production posting cycles and communicating with the various stakeholders,
• Reviewed, analyzed, and modified backend systems including encoding, testing, debugging and documenting programs.
• Migrated SQL code and DTS packages from a 2000 environment to 2008/2012 (SSIS and SSRS).
• Designed and developed ETL solutions ( Confidential -SQL, SSIS, SSRS and XML) to support operational management of data solutions
• Worked with technical leads to review requirements, design spec, code, and to implement a variety of SQL database solutions to meet company needs.
• Contribute to the development of data management strategies, policies and best practices through participation in management meetings and other direct contributions.

Confidential, Atlanta, GA

Teradata Informatica Developer

Responsibilities:

• Designed and developed dataflow paths for loading transforming and maintaining DW.
• Extracted several types of data (EBCDIC, ASCII, XML, unstructured datasets and other data types) data from numerous, heterogeneous OLAP and/or legacy data sources using programming code, batch files (.bat) and etc…then transform into the targeted structure using SQL Scripts, BTEQ, Mload, Fload and various ETL utilities and tools.
• Developed Fast Load and MLoad scripts in control file, developed BTEQ scripts to process the data into staging utilizing Informatica to execute BTEQ processes.
• Extracted data from various data sources SQL Server, Teradata, Oracle, UNIX and Mainframe to create reports and streamline data reporting.
• Debugged and tuned queries of various degrees of complexity.
• Worked closely with management and other teams to maintain application accuracy; analyzed company data to determine the necessary data constraints and to resolve data anomalies.
• Developed Informatica processes, workflows, UNIX shell scripting to complete weekly/monthly data loads and processing.
• Determined script load dependences for Production and scheduled jobs utilizing Tivoli Enterprise Scheduler.
• Worked with technical leads to review requirements, design spec, code, and to implement a variety of SQL database solutions to meet company needs.
• Contribute to the development of data management strategies, policies and best practices through participation in management meetings and other direct contributions.
• Prepared technical presentations and interface with senior client management and business users to map and document business requirements.
• Participated in Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.

Confidential, Atlanta, GA

Sr. SQL Developer

Responsibilities:

• Designed and developed SSIS package to load data from heterogeneous sources and load into target environment, utilizing Derived Columns, Unions, Aggregations, Lookups, For Each Loops, Scripts, Multicast, Conditional Splits and other functions.
• Configured and tuned ETL workflows designed in DTS to SSIS
• Tuned and optimized queries and store procedures by altering database design, analyzing different options, and indexing strategies to ensure Optimal Query Performance. Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Developed/Modified reports using SSRS i.e. Drill Down, Drill Through, Sub Reports, Charts and uploaded to SharePoint server.
• Created jobs, alerts to run SSIS, SQL Mail, SSRS packages periodically. Created/Modified complex stored procedures and triggers
• Implemented complex business requirements on backend using efficient stored procedures and flexible functions and facilitated easy implementation to the front-end application.
• Created and maintained Windows Logins, roles and privileges to User Accounts/Groups and objects for login authentication and validating permissions. Created DB links to various databases.
• Received all request via SpiceWorks logging system. Validated request, gathered requirements, executed the development and/or maintenance of the request and documented the outcome.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Utilized Visual and Management Studios 2008 and 2012 using Subversion controls (svn tortoise)

Confidential, Atlanta, GA

Sr. SQL Developer

Responsibilities:

• Managing day-to-day Production data operations for company financial systems in Microsoft SQL Server 2005/2008 environments.
• Worked with .Net developers to build and support BIA web applications and resolve application issues
• Designed and developed SSIS and SSAS packages to load data from heterogeneous sources and load into target environments such as Data Warehouse and/or Data Mart and Cubes utilizing Derived Columns, Unions, Aggregations, Lookups, For Each Loops, Scripts, Multicast, Conditional Splits and other functions.
• Created, designed, implemented and maintained Database Schema, Entity relationship diagrams, Data modeling, complex stored procedures, Functions and Triggers, Constraints, Indexes both (Clustered and Non-Clustered), Functions, Views, Defaults and complex SQL statements.
• Deployed application changes to Dev, QA and Production environments.
• Tuned and optimized queries and store procedures by altering database design, analyzing different options, and indexing strategies. Used Execution Plan, SQL Profiler and database engine tuning advisor to optimize queries and enhance the performance of databases.
• Performed backup and recovery operations. Detached/Attached and restoring DB’s, wrote Confidential -SQL and Unix Shell Scripts to copy and/or move DB’s.
• Responsible for working assigned tickets via TrackIt system to resolve Application issues reported by end-users. Also, received new development request via TrackIt.
• Worked closely with the Business, Front-end application developers, source systems owners and users to ensure design and implementation of optimal solutions - with emphasis on data integrity, near-real time data currency and fast response time.
• Resolved DB performance issues and implemented the necessary DB changes and processes to ensure Optimal Query Performance.
• Developed and maintained data interchange interfaces between SAP R/3, Clientele CRM, and the Legacy Softrax financial systems. Largely written in Transact-SQL, these interfaces provided periodic and real-time exchange of customer, financial, iDoc and transactional data.
• Designed and maintained reporting databases to minimize potential performance degradation in production systems due to complex and/or frequent report requests. Developed processes to refresh the Reporting Server nightly with Production data.
• Analyzed and resolved production issues related to ETL processes and data integrity. Identified the root cause of the issue and provided downtime support as needed.
• Involved in XML Development and XML File Parsing from raw data sources to populate database tables for reporting purposes.
• Designed a backup and restore process to refreshed Dev and QA environment with copy of PROD quarterly.
• Created and maintained Windows Logins, roles and privileges to User Accounts/Groups and objects for login authentication and validating permissions.
• Created jobs, alerts to run SSIS, SSRS packages periodically. Created automated processes for activities such as ETL processes utilizing SSIS, SSRS Packages running sequentially using SQL Server Agent job.

Confidential, Birmingham, AL

Sr. ETL Developer / Data Architect

Responsibilities:

• Designed, developed Oracle based total banking solution. The system had 3000 tables and 1500 stored procedures, among others.
• Tuned existing store procedures by modifying the code resulting in a 20% performance boost. These stored procedures were used to process the Oracle Credit processing system and data warehouse system totaling more than 4 TB.
• Utilized Bill Inmon’s Data Warehouse methodology to design and maintain a centralized repository to store atomic data Confidential the lowest level of detail.
• Created data mart to store historical data and provide logical framework for delivering business intelligence.
• Assisted with planning, design and development of a new, crucial reporting data mart for use with MicroStrategy in just three short months
• Designed, developed, tested and implement data integration solutions to support Customer Portal using Informatica (PowerCenter and PowerExchange), Unix Shell scripts, PL/SQL and other ETL tools and technologies.
• Created and analyzed the functional specs for mapping documentation.
• Defined various Facts and Dimensions in the data mart including Aggregate and Summary facts.
• Wrote advance PL/SQL and Confidential -SQL code to create functions, store procedures, build/alter tables, create views, and perform system updates, deletions and other functions needed.
• Identified gaps, bottleneck issues, discrepancies, anomalies in the initial data as well as in any newly imported data. Validated the integrity of data relationships, mappings and table definitions.
• Designing and implementing ETL (Extract, Transformation and Load) processes, programs, stored procedures and complex SQL scripts via Informatica and SQL scripting.
• Extensively used Informatica PowerCenter to design multiple mappings, workflows with embedded business logic. Used PowerExchange to read source data from various environments such as Mainframe and SAP.
• Created advance mappings, mapplets, SQ Transformations - lookups, joiner, rank from heterogeneous sources such as VSAM, Flat Files, Oracle, SQL Server, Unix and many others.
• Wrote code to obfuscate data to adhere to confidentiality policies.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin. Also, Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Converted the Oracle data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Reviewed source systems and proposed data acquisition strategy.
• Created and updated technical documentation relating to database schema and ETL design and implementation: Technical Architecture Specifications, Source to Target Mappings and Data Flow Diagrams.
• Supported the business needs and overall collections strategic initiatives related to risk management and reporting.
• Created Test scripts for uniting testing purposes.
• Documented processes and design docs. Utilized Jira and SharePoint to store, share documentation and track timelines.
• Provided Knowledge Transfer to the technical writers and end-users to create extensive documentation on the design, development, implementation, daily loads and process flows of mappings.
• Mentored / assisted junior developers and support staff; perform peer code reviews as needed.
• Worked within a small team taking on more responsibilities to get the job done.

Confidential, Atlanta, GA

ETL Developer/Data Analyst

Responsibilities:

• Developed mappings needed to load the staging area of the DW for both dimensions/facts and lookup tables
• Identified gaps, bottleneck issues, discrepancies, anomalies in the initial data as well as in any newly imported data. Validated the integrity of data relationships, mappings and table definitions.
• Designing and implementing ETL (Extract, Transformation and Load) processes, programs, stored procedures and complex SQL scripts.
• Extracted, transformed and loaded data from / to various source / target systems.
• Conducted root cause analysis and resolved UAT / Production problems and data issues
• Performed Data validation and created test cases according to business requirements
• Utilized ETL tools such as Pentaho (Kettle), SQL Server 2005/2008 SSIS and SSRS