We provide IT Staff Augmentation Services!

Etl Architect Resume

Louisville, KY

SUMMARY:

  • Technically - sophisticated professional with 12+ years of pioneering career reflecting Technical leadership, Data Warehouse Architecture, Data Modeler and Designer in Healthcare, BFSI, Telecom and Retail industries.
  • Database Modelling ( Microsoft Visio ) and Development of database objects like Tables, Stored Procedures, Triggers, Views & Indexes using Transact SQL ( Confidential -SQL ) as per the business & functional requirements using Microsoft SQL Server 2005/2008R2/2012/SQL Azure
  • Extensive experience in Data Migration i.e. BI projects from Requirement Gathering, Estimation, Interaction with various stake holders, Development and Implementation.
  • Design & Implementation of Extract, Transform, and Load (ETL) process using SQL Server Integration Services (SSIS) in Microsoft SQL Server 2008R2 from various source systems like Text files, Excel Spreadsheets & RDBMS.
  • Design and development of Cubes using SQL Server Analysis Services (SSAS) in Microsoft SQL Server 2008R2, 2012
  • Performance tuning or query tuning of SQL queries in stored procedures.
  • Monitoring of SQL Queries using the tools such as SQL Profiler & Database Engine Tuning Adviser to identify the performance bottlenecks in Confidential -SQL Queries
  • Expert in SSRS, Excel & PowerBI reports development and design.
  • Bug Fixes and enhancements; Implementation of validations, error handling, and logging; Code review and cleaning; Unit testing.
  • Initiated and implemented best practices, standard and guidelines on SQL Scripting; and Mentoring team members; Communication with onsite Coordinator and Customer; Status Reporting
  • Development of database objects like Tables, Procedures, Views as per the business & functional requirements.
  • Specialized in data analysis, data migration, database system implementation, DWBI Development and testing methods.
  • Possess in-depth Business knowledge on Telecom, excellent understanding of the quality standards.
  • Good understanding of Software Development Life Cycle (SDLC), Object Oriented Programming principles and experience on UML modeling tools.
  • In-depth knowledge and hand-on experience on Database Objects like stored procedure, functions, Trigger, strong query design and optimization.
  • Business Integrating diverse businesses and their processes through shared data requires a data integration solution.
  • Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations.
  • Excellent understanding of database concepts SQL and performance tuning of queries.
  • Good understanding on Data Warehouse Top-Down ( Corporate Information Factory" (CIF) and Bottom-Up (Ralph Kimball) approach.
  • Expert level skills on Confidential -SQL and query optimization, developing ETL strategies using SSIS, Database designing using SQL Server 2008/2012.
  • Good technology exposure on Microsoft .Net technology with C# and VB.Net.
  • Strong experience in Extraction, Transformation and Loading (ETL) in SQL Server database.
  • Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.

TECHNICAL SKILLS:

BI Tools: SQL Server Analysis Services 2008/2012, Integration Services, Reporting Services, Crystal Report 10, Share point Server 2010, Informatica 8.0

Languages: C Sharp, VB.Net

Microsoft Technologies: Framework 1.1/3.0/3.5, Windows Service, SQL Server Reporting Services (SSRS), Integration Services (SSIS), SQL Server Analysis Services (SSAS), PowerBI

Database: Oracle 8i, MS-Access 97, MS SQL Server 2008/2012, Teradata

Reporting Tools: SQL Reporting Services 2008/2012, SAP Business Objects, Cognos

ORGANIZATIONAL SCAN:

ETL Architect

Confidential, Louisville, KY

Responsibilities:

  • Creates and maintains the logical and physical data models for the production and Business Intelligence data warehouse and data marts.
  • Participates in data design walkthroughs to communicate data warehouse and Data Mart table designs to ETL developers.
  • Develops prototype views and reports of the data, and work with business users both internal and external to refine their requirements.
  • Demonstrates self-reliance in researching technical solutions and product functionality.
  • Continuously improves upon existing approaches by seeking opportunity to creatively transform current business practices into fresh alternative solutions.
  • Identifies critical integration issues and develop corrective solutions. Communicates with team members to assess progress of deliverables.
  • Performs maintenance and administration of the database platforms and data protection needs as they relate to the database platforms and solutions. Conducts performance tuning of existing data structures.
  • Assist the various stakeholders by providing them with process and program related data as requested.
  • Gather reporting requirements from customer meetings, ad hoc requests, types of questions that are asked and hand them off to the development team.
  • Develop impactful reports using Microsoft Reporting Services platform (SSRS), MS Excel, Pivot tables and other intuitive graphical add-ons.
  • Design layout of reports and determine the best way to present data to end users.

ETL Architect

Confidential, El-Segundo, CA

Responsibilities:

  • Gather requirements from the business users, and design a database with the compatible structure and data types of the vendor Facility.
  • Design ETL architecture and create highly complex SQL Server Integration Services packages that load data from various sources into the production servers.
  • Create highly critical data mapping, technical and process documentation of the data load process from various facilities into the Data ware house.
  • Assist the team in Data recovery of the critical clinical data feeds when any of the SQL server processes fails, which directly affects the business.
  • Create new complex stored procedures, queries, functions, triggers, Common table expressions to capture the production data accurately and assist the end users to recognize process bottle necks.
  • Automate packages, Visual Basic scripts and stored procedures to run on a scheduled basis to keep track of the production numbers Confidential the end of the specified period.
  • Perform rigorous tuning in SQL Server, and modify and create new indexes, database statistics and hints.
  • Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Designed a new schema for the Data Mart databases.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
  • Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
  • Generated Daily, Weekly and Monthly Trigger based reports regarding assigned projects to designated Managers and Clients.
  • Created simple data entry applications using C#.Net 2005 and SQL 2005 Server.
  • Used HTML code to make Report manager more functional & customizable.
  • Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

ETL Architect

Confidential, Nashville, TN

Responsibilities:

  • Design ETL architecture and create highly complex SQL Server Integration Services packages that load data from various sources into the production servers and to consequently create data extracts to be fed into the Hospital management systems.
  • Creation of new procedures and UDFs to validate the business rules and deliver reports with a Key progress indicator for marketing department.
  • Enhancement and troubleshooting of the developed code for performance and run times and also Audit trailing of the databases from the Source systems to the Data ware house.
  • Conduct meetings with the SMEs Confidential Community Health Systems to assist them in the streamlining and data management processes and to roll out reports to validate the business logic.
  • Create new complex stored procedures, queries, functions, triggers, Common table expressions to capture the production data accurately and assist the end users to recognize process bottle necks.
  • Created data sources and data source views (DSVs), named calculations and named queries calculated members, named sets, KPIs, drill through, report actions and perspectives as per the business requirement.
  • Maintenance of the data dictionary and adding the change requests.

ETL Architect

Confidential

Responsibilities:

  • Provided technical solutions and managed the ETL-Simplification project team of 5 members.
  • Fine-tuned the complex ETL’s of the Data loads
  • Evaluated existing ETL process model and provided solutions to ensure efficient load processes through parallel loading strategies
  • Provided Technical design documents to help the development teams for comprehending business requirements, building reusable components and successful Implementation
  • Design and developed ETL packages and PL/SQL procedures, Unit Testing of ETL packages and PL/SQL procedures.
  • Preparing Technical Specification documents based on Functional Specifications.
  • Used Multidimensional expressions (MDX) to retrieve values from Multidimensional cube.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other Confidential -SQL code and SQL joins for applications.
  • Developed Queries for generating drill down reports and SQL server reports in SSRS 2005.
  • Identified and worked with Parameters for parameterized reports in SSRS 2005.
  • Generated Reports using Global Variables, Expressions and Functions.
  • Deployed the generated reports directly on the client’s workstation.
  • Improved Report Performance and performed unit testing.
  • Looked Confidential the reports and fixed bugs in stored procedures.
  • Monitored Scheduled jobs and alerts.
  • Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
  • Managed index, statistics and optimizing queries by using execution plan for tuning the database.

Confidential, Atlanta, GA

SR ETL Developer

Responsibilities:

  • Develop technical architecture based on detailed requirements
  • Infrastructure, architecture and environment evaluation.
  • Multidimensional cubes design and develop using SSAS.
  • Dimensional Modeling, ETL, OLAP, Reporting and Active Batch Monitoring/Scheduling.
  • Interfaces with Business users and Technical SMEs to clarify requirements, review design, test case and UAT and deployment. Design fact and dimension tables.
  • Creation SSIS Packages using SQL Server.
  • Ensures deliverables meet Quality standards.
  • Regression testing, Integration testing, Re-testing, Ad-hoc testing and Web services testing.
  • Working on Medical Networks Configuration under module in Facets to gather agreement information while processing claims like allowed amount and contract terms and Pricing details to process claims and for successful adjudication.
  • Created SQL server dynamic configurations for SSIS packages.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Used BCP to transfer the data files to other server.
  • Scheduled the packages to run automatically for incremental data and deploy them to their destination servers.
  • Responsible for creating reports based on the requirements using SSRS 2008.
  • Developed tables, Views, Stored Procedures, Functions, Indexes and Triggers using SQL Server Management Studio.
  • Optimized the performance of queries with modifications in Confidential -SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
  • Responsible for creating parameterized and drill down reports based on the requirements using SSRS 2008.
  • Modified the existing ERD’s to insert more tables, columns and constraints using MS Visio 2008 for more refined data models.
  • Used TFS to store, run, view, edit and revert back to different versions of the design in case of a system crash.

Tech Lead

Confidential

Responsibilities:

  • Interfaces with Business users and Technical SMEs to clarify requirements, review design, test case and UAT and deployment.
  • Devising the Report delivery mechanisms.
  • Design fact and dimension tables.
  • Creation DTS Packages and SSIS Packages using SQL Server.
  • Ensures deliverables meet Quality standards.
  • Create complex reports using Cognos.
  • Performed Functional testing, GUI testing, System testing and Database testing.
  • Experience with Facets System implementation, Claims and Benefits configuration set-up testing, Inbound/Outbound Interfaces and Extensions, Load and extraction programs and proprietary format files and Reports development.
  • Defined parameters, variables and run time parameters within the SSIS package Execute SQL task and executed stored procedures within the packages by passing parameters and loaded the data into the tables.
  • Documented standard operating procedures for all facets of Direct Mail Postal Logistics.
  • Once the data is in place developed the cube “Campaign Cube” with multiple cube dimensions, hierarchies, measure groups and calculated measures using MDX queries.
  • Developed the various R12 Shared Campaign reports (Tablix, Chart, Grid, Guage and inter linked drill through) reports using SSRS with multiple shared data sources and shared datasets.
  • Ensure all the code and versions are properly maintained in the TFS while migration is progress.
  • Monitoring and supporting the existing Enterprise Data warehouse environment.

Offshore Lead

Confidential

Responsibilities:

  • Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
  • Writing Lotus Notes agents, ActiveX script for pulling data from Lotus Notes db.
  • Designing and Implementing the ETL processes.
  • Creation of Canned reports, Cube-Based Reports, Report Models for Ad-Hoc.
  • Using Reporting Services Capabilities and 3rd party tools accordingly to build Dashboards.
  • Troubleshooting reports issues, ETL job failures, optimizing query performances.
  • Coordinating with onsite folks and leading and mentoring the offshore team.
  • Creation parameterize reports using filter and search conditions.
  • Travel to various locations to train people in new project specific technologies.

Software Specialist

Confidential

Responsibilities:

  • Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
  • Involved in designing physical and logical layers in databases.
  • Design and development of Tables.
  • Involved in designing and documenting the architecture of the system.
  • Involved in writing Stored Procedures and Functions in SQL Server 2000 for backend development and use Reporting Service for generating report.
  • Designing and implementing the ETL processes which involves collection of data from heterogeneous source databases like Oracle, DB2and SQL Server 2000/2005.
  • Used the VSS as version control tool for project management.
  • Involved Integration testing of the windows application.

Hire Now