We provide IT Staff Augmentation Services!

Lead Etl Developer/bi Developer Resume

Jacksonville, FL

P ROFESSIONAL SUMMARY:

  • 10+ years of experience in analysis, design, development and implementation (includes specialization in Web enabled, Exposure to data/process modeling skills. and Client Server Technology applications)
  • Excellent knowledge in database normalization techniques with specialization in designing and building databases in SQL Server 7.0/2005/2008/ R2
  • Extensively involved in T - SQL Stored Procedures, Functions, Views,CTE, Indexes, Triggers, Sub-queries implement Best practices.
  • Expertise in Converting 2008 and 2008R2 DTX packages from Package model to the 2012 Project model.
  • I have 8+ years of IT experience focusing on Data warehousing, Data modeling, Dashboards,Data integration, Data Migration, ETL process and Business Intelligence.
  • Designed SSIS Packages to extract data from various data sources such as Sybase, As400, Oracle,Excel spreadsheet, and flat files into SQL Server 2014 for further Data Analysis and Reporting by using multiple transformations provided by SSIS; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks in Autosys.
  • Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
  • A bility to gather and translate requirements into effective, high-quality designs and solutions .
  • Excellent in design and developing reports using SQLServer Reporting Services (SSRS) and Crystal Reports.
  • Knowledge of BI Related tools like Tableau, Power BI.
  • Working Experience on slowly changing dimensions, CDC and creating SSIS packages using Active X scripts with Error Handling.
  • Extensively used SSIS transformations such as Lookup, Derivedcolumn, Dataconversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
  • Created and designed complex reports like reports using Cascading parameters, Dashboards,Drill-Through Reports, Parameterized Reports, Sub Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on business requirements
  • Experience in all phases of software development life cycle (SDLC) including client interaction, design/architect, development, implementation, integration, documentation, testing, deployment, builds, configuration and code management, production/customer support, maintenance, enhancements and quality control of n-tier architecture applications and desktop client-server software.
  • Excellent experience in Object Oriented Analysis and Design (OOA/OOD) and in developing large scale, fully normalized, and highly complex relational databases
  • Expertise in Memory Optimization and performance Techniques and Good Exposure to data/process modeling skills.
  • Analytical, versatile, quick learner, excellent problem solving, debugging and communication skills
  • Team player with proven multiple platform adaptability skills and motivated to excel.

TECHNICAL SKILLS:

.NET Technologies: Microsoft .NET Framework CLR, VB.NET, ASP.NET, ADO.NET, XML Web Services, Win Forms, Web Forms, SOAP 1.1, WSDL, UDDI, .NET Remoting, COM/COM Interoperability, NUnit, WCF, WPF.

Web Development: ASP.NET, ASP.NET MVC, ASP, IIS 6.0, VBScript, JavaScript, CSS, HTML, HTML5, AJAX, XML, XSL, XPath, XQuery, jQuery, JSON.

Programming Languages: ASP.NET, VB.NET, ADO.NET, JAVA, XML, XSL, XSLT, VB6.0, ASP, Transact SQL T-SQL, PL/SQL, C, C, VB Script

Development Tools: Visual Studio .NET 2003 /2005 /2008 /2010 /2012, Visual Source Safe, Microsoft Visio, Microsoft Team Foundation Server, Microsoft Application Center Test, Visio, Toad for Oracle 11g, SSIS Process Studio, CozyRoc, ERWIn, MS VISIO RDBMS MS-SQL Server 2000/2005/2008/2012, Oracle, DB2, Sybase

Reporting Tools: SQL Server Reporting Services SSRS, Crystal reports 8.0/9.0/10.0, MS Excel.

PROFESSIONAL EXPERIENCE:

Lead ETL Developer /BI Developer

Confidential, Jacksonville, FL

Responsibilities:

  • Worked on Various Maintenance ETL Packages related to Client Information Namely Account/Account Holder personal information, Alerts, Phone and Contact Addresses and other banking details. This data was integrated into MS Dynamics CRM Database (Client Connect) from Everest Data Warehouse. Used CozyRoc Integrated tool to Insert/Update to the MS Dynamics CRM. Used Balance Data Distributor (BDD) for Improving Performance Issues.
  • Successfully, developed packages that have dynamic package configuration and Error event handling using On Error, SSIS Logging and has Failure email notification as well as storing SSIS error log into tables.
  • Involved in fixing few issues with the CUBES with Enterprise Data Warehouse System.
  • Created various New SSIS ETL Packages for Marketing Banking Product Initiative.
  • Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
  • Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
  • Accountable for building Package deployments and package Configurations.
  • Redesigned and optimized ETL package Reconciliation of documents for OnBase Document Management.
  • Used PowerShell Script for Generating scripts for Various QA /Stage Environment for OnBase Database.
  • Fixed and enhanced some methods with REST Web services in integrating Data with TIAA.
  • Provided 24/7 production support for the production database and to the code deployed into the production environment.

Environment:: SQL SERVER 2012(Project Model), C#, PowerShell, SSIS, REST web services, JSON, CozyRoc.

Lead ETL Developer

Confidential, Jacksonville, FL

Responsibilities:

  • Worked on Trade Transaction Management Projects Like Fixed Income Business Automation, Mortgage Based Securities and Consolidated Data Repository (CDR).
  • Created various ETL Jobs in SSIS namely ICITrades, ICISecurityData, Bloomberg Trades, Global Transaction Trades, Factors, Financial Monitoring Units using Integration Catalogue 2014.
  • Created various Real Time and Batch Jobs Scheduling in Autosys.
  • Created various SSRS Reports Broker Dealer Liquidity Forecasting Reporting for FINRA4210. Legal/Regulatory, Unclassified Report Enhancements, Extended Settlements Reports, FINRA Master Summary reports, LOB Monitoring Reports.
  • Created SSIS packages to extract, transform and load (ETL) data from different sources into destination target like data warehouse, Flat File, Excel, OLE DB using SQL Server integration Services.
  • Involved in monitoring the workflows and in optimizing the load times.
  • Handled Performance Tuning and Optimization on SSIS and MDX, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
  • Involved in Tabular Datawarehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.

Environment:: SQL SERVER 2012, PERL, Web Services/ WCF, ASP.NET, JSON, T-SQL, ASP.NET/C#, LINQ, Entity Framework, Tableau, ORACLE, SSIS,SSRS and SSAS, MDX Queries.

BI Developer

Confidential, Jacksonville FL

Responsibilities:

  • Worked on various SSRS Reports Projects Green Sheet Capacity Planning Management Reports, Release Calendar Reports, Quality and Chargeback Reports, Dashboards on Capacity vs estimates using SQL server 2012 Reporting Services.
  • Created various Chargeback Reports for Quality Center Team.
  • Created various Data based subscriptions for various reports.
  • Created various SSIS ETL packages for Retrieval and Updating of Global Directory, Loading QC / and Projects, Regions, Cost Center/GOC, Loading of Actuals and Estimates from External System i.e. Plainview and Loading various SSAS (Dimension and Facts) related Tables. Moving data from Production to Development, UAT and staging environments.
  • Experience on optimization of complex SQL queries.
  • The signing Party Requests application (MVC) provides the interface to create and maintain those requests for Travel, Headcount and other requests each week and these requests and provide an automated workflow solution. These requests are reviewed by GCT chief information officer for exception approval. Tools used are ASP.NET, WCF web services, C#/LINQ, AJAX, jQuery, JSON for validation rules, Infragistics Web controls.
  • Worked on some modules of TCAP windows application to maintain and monitor estimates for Resources. Some of them are Resources Time Off, Integration of Reports
  • Created various Dashboards for the Quality Center.
  • Imported data to SQL Server from Teradata and Oracle Databases.
  • Created SSAS Cubes for the Estimation vs actuals and for Quality Center Management Statistics Analytical Dashboard Reports.

Environment: SQL SERVER 2012, Web Services/WCF, MVC, ASP.NET, Jquery, JSON, T-SQL, ASP.NET/C#, LINQ, Entity Framework, ORACLE, SSIS,SSRS and SSAS, MDX Queries.

BI Developer

Confidential, Jacksonville, FL

Responsibilities:

  • Worked on Account Receivables, Billing and Invoice Creation modules.
  • Worked on various SSIS packages like Eligibility Load Process, Synchronization of Invoices and Claims and Oracle AR extracts.
  • Worked on various SSRS reports like Automated Sedgwick Monthly Best Practice Report, Missing Images Report - Invoices on Hold (Detail) and Daily 7-Day CBM Billing Report.
  • Created WCF services for Billing and Oracle Interfaces with Account Receivable Team. Created Windows Services (TCP/IP) and MSMQ WCF services for Logging and Lookups.

Environment: C#, XML, XSLT, WCF, TFS, .NET Framework 4.0/3.5, ORACLE, SSIS, SSRS, ADO.NET, VB.NET, LINQ, Entity Framework

Sr. Database Developer

Confidential, Jacksonville, FL

Responsibilities:

  • Created various nightly Agents and Agent services using SSIS packages relating Renewal Processing, email notifications and escalations, Reviews, past dues agent and Work requests processing.
  • Used TSQL to develop and debug various complex SQL queries, stored procedures, triggers, functions and views.
  • Worked in Tuning of several Stored Procedures for improving their Performance for Reports.
  • Worked on various reports using SSRS on Renewal List, Workbook Requests, past due accounts List.
  • Participated in various design meetings and peer reviews.
  • Performed Database Refresh tasks from production to Development and Staging Server .
  • Created WCF web services which interfaces with other Systems.

Environment: C#, XML, XSLT, WCF, TFS, .NET Framework 4.0/3.5, Infragistics Controls, SQL Server2008, SSIS, SSRS, ADO.NET, VB.NET

Sr. Database Developer

Confidential, Jacksonville, FL

Responsibilities:

  • Integrate various systems by capturing data and entering data between them; and navigating through them through the Windows API and Screen Scrapping Techniques.
  • Used SQL Server Integration Services to create various packages for care giver management systems.
  • Used TSQL to develop and debug various complex SQL queries, stored procedures, triggers, functions and views.
  • Designed User Interfaces using Win forms and Web Forms.
  • Architect designing and implementing object oriented techniques for solution of various business processes.

Environment: Agile Development, C#, Visual studio 2010, XML, .NET Framework 2.0/3.5, SVN, CVS, SQL Server2005, SSIS, SSRS, ADO.NET, VB.NET

.NET Developer

Confidential, Atlanta, GA

Responsibilities:

  • Designed and developed various business Forms and Data Access components in WinForms using C# and ORACLE.Worked on Monthly Reconciliation which is a process of comparing with the actual and original Budget for Generating Various MIS Charts and Analysis Reports using MS Report Viewer Control and SSRS.
  • Retrieval and Manipulation of Information is done through the Spreadsheet Gear Control.
  • Used Extensive Object Oriented Techniques and Design Patterns.
  • Extensively used SharePoint site to monitor various defects assigned to Developers and uses for various other tasks like Retrieving project documents/coding standards, Tips and Tricks etc.
  • Worked on Converting the Data from ORACLE to SQL Server for future use of Cubes and Reporting Services.

Environment: C# (2.0), WinForms, NET Framework 2.0, .NET Remoting, ORACLE 10 g, SSRS, ADO.NET, TFS, Spreadsheet Gear, Nunit, XML/Web Services.

Senior Programmer Analyst

Confidential, Portland, Oregon

Responsibilities:

  • Designed and developed various business components using C# and SQL Server 2005.
  • Maintained and added new developments to the Confidential Education Initiative websites and portals using C# and .NET 2.0
  • Converted Classic ASP pages to .NET ASPX pages.
  • Enhanced and resolved various defects to the Assessing Projects, Workspace and Education Content Management System (CMS).
  • Localization of web sites to 18 Languages including RTL formats.

Environment: C#, .NET Framework 2.0/3.5, SQL Server2005, AJAX, R.A.D.Telerik Controls, Reporting Services, T, Web Services and JavaScript, and Share Point/Microsoft Content Management.

Hire Now