We provide IT Staff Augmentation Services!

Senior Bi Etl Developer Resume

Atlanta, GA

SUMMARY

  • Over 10 years of IT experience in Analysis, Database Design, development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives. Good Confidential communicating and solving complex problems, leading development teams, improving data management, automating and integrating systems, and delivering projects on time. Skills in: Business Intelligence SSRS, SSIS, Database Design and Development, Enterprise Reporting and Confidential - SQL
  • Expertise in scripting Confidential -SQL queries, complex stored procedures, user defined functions (UDF), Database triggers.
  • Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
  • Experience in Data Modeling, Databas e Design, Programming, Development and Implementation of Client-Server Applications & Database systems using MSSQL 2000/2005/2008 for both OLTP (Batch Processing, Online Processing) & Business Intelligence (SSIS, SSRS) applications.
  • Strong technical knowledge in MS SQL Server development including DTS, Microsoft Analysis Services, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
  • Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
  • Basic understanding of SSRS and converted the SSRS reports from SQL 2005 to SQL 2008 R2.
  • Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
  • Upgrade DTS packages to SQL Server Integration Services (SSIS).
  • Have a decade of experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
  • Designed, implemented and managed MS SQL Server 2008, 2012 database systems. Implemented backup & restore strategies and replication features.
  • Experienced on setting up SQL cluster including Always ON setup in SQL 2012.
  • Proficiency in data extraction from Salesforce data structures.
  • Expertise in various ETL processes such as CDC (Change data capture), MDM (Master data management) extracts, MDM salesforce and IDQ data processing.
  • Extensive analysis experience in NetSuite and Informatica.
  • Experience in SQL day to day administration tasks such as SQL job status, database health, replication health etc.
  • Experienced business analyst focused on understanding end users/customers business requirements, recommending technical solutions and required documentation functional requirements.
  • Excellent analytical communication and interpersonal skills. Proficient in technical writing and presentations and a good team player.
  • Excellent troubleshooting skills and ability to solve complex issues.
  • Appreciated for my timely and detailed communications to all release stake holders keeping everybody in sync with current situation and progress.
  • Known for building partnerships, driving clarity, attention to key details and my focus on continuous learning..

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior BI ETL Developer

Responsibilities:

  • Maintained the researcher related data critical to Cancer research with utmost precision.
  • Migrated all the datasets from legacy Siebel to Salesforce to meetfor more modern better visualization and reporting needs as needed
  • Performed extensive analysis ETL & scheme analysis projects in NetSuites, Informatica, and core DBs ETL projects to improve reliability of the data in terms of accuracy.
  • Maintained various development & testing environments to support our projects
  • Fulfilled various additional roles of vendor resource manager, solutions architect, and technical analyst on various projects.

Environment: SQL Server 2005/2008 R2/2012, Windows 7, Informatica, MDM, IDQ, Salesforce, Teradata, SMTP, Excel

Confidential

Senior Applications Developer

Responsibilities:

  • Developed and maintained an enterprise application to provide executive reporting of infrastructure projects across North America.
  • Developed various automated SSIS workflows & C# scripts responsible for fetching complex data from various network resources and systems.
  • Developed the database scheme and table relationships to support the reported data.
  • These workflows are also responsible for validating and analyzing the data to produce an executive summary report.
  • Created the SDLC maintenance process, servers, and environments for the application.
  • Maintained the Development and Test servers and environments for the application.
  • Created and maintained the daily schedules for the SSIS workflows.
  • Developed and managed scripts to maintain periodic backups of the three environments.
  • Developed an alert system into workflows that emailed daily run statuses, and critical data validation failures.
  • Created the user and process documentation for the application.
  • Developed Stored Procedures, User defined Functions, Constraints and so on as needed for the data processing.
  • Created impromptu SQL queries for data verification and analysis.
  • Generated server-side Confidential -SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
  • Escalation point for Application troubleshooting in case of failures or errors reported by the alert system.
  • Responsible for conducting root cause of defects and issues found by the QA team.

Environment: SQL Server 2005/2008 R2, Windows 7, .Net, C#, ColdFusion, HTML, SMTP, Excel, VB.Net

Confidential, Atlanta, GA

MS SQL Senior Developer

Responsibilities:

  • Created and modified Stored Procedures, User defined Functions, Constraints and so on depending upon the business logic and user requirements.
  • Created SQL reports, data extraction and data loading scripts for different databases and schemas
  • Created impromptu SQL queries for data verification and analysis.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
  • Developed Transact SQL utilities to generate table insert and update statements
  • Developed various Transact SQL utilities to add functionality to E-enterprise system.
  • Generated server-side Confidential -SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins database links and formatted the results into reports and kept logs
  • Responsible for troubleshooting SQL in case of any failures and to implement automatic alerting in the event of a failure to address the issue in time.
  • Worked with SQL and .Net Forms development team to do code and defect reviews.
  • Responsible for representing the historical data in graphical form using MS Access.
  • Represented Confidential in working with an external vendor to identify business requirement gaps, define data exchange rules, troubleshoot errors, and correct defects in design and data.
  • Worked with QA team to troubleshoot code & data defects.
  • Assisted QA lead in identifying root cause of defects and issues across the entire end-to-end process.

Environment: SQL Server 2005/2008 R2, Windows 7, .Net, HTML, XML, SMTP

Hire Now