We provide IT Staff Augmentation Services!

Data Architect, Etl Lead Resume

CAREER OBJECTIVE:

To pursue a challenging career that gives me scope to apply my knowledge, experience and skills and provides many opportunities to grow allowing scope for both personal and professional growth.

PROFESSIONAL SUMMARY:

  • 7 years of professional experience as Application Development Lead in Confidential with a skill set of Microsoft BI implementation, Data Modeling, Data visualization, Data Analysis, IT support.
  • End - to-End BI implementation using Microsoft technology (MSBI). Implemented BI solution for 4 projects so far
  • ETL Architect, experienced in creating ETL framework solutions
  • Data visualization and analysis using tools like Qlikview, SSRS
  • Designed, Developed and maintained Relational databases
  • Data modeling using Erwin, MS Visio. Normalizing data, start schema, snowflake schema
  • Experienced in handling all the project life cycle phases i.e. requirements gathering, proposing the solution, UAT and Deployment
  • Hands on experience in multiple technologies like SSIS, SSAS, Qlikview, SSRS, SQL Server, C# .NET, Informatica MDM, Teradata, Oracle, Powershell
  • Involved in SQL technology upgrade and migration
  • Worked in Agile environment leading production support team, testing team
  • Skilled in error and event handling and troubleshooting
  • Worked on data quality scenarios involving data cleansing or data scrubbing
  • Experienced in configuration management of version maintenance
  • Client site experience in Jubail Saudi Arabia as a Onshore lead and technical architect for DOW Chemicals
  • Worked in multiple domains like Insurance, Life Science and Energy (Petro chemicals)
  • Excellent verbal/written communication skills and strong analytical abilities, and can perform well both independently and as a team player
  • Ability to handle multiple tasks, Initiative and Adaptable. Self-motivated, organized team player with strong problem solving and analytical skills and total commitment to the organization goals
  • Interested and passionate about learning other big data technologies and BI technologies

TECHNICAL SKILLS:

Database Systems: SQL Server 2008R2 / 2012, 2016,2017, Teradata

Operating Systems: Windows Server 2008 R2, Windows 10

Microsoft Technologies: MSBI (SSIS, SSAS) 2008R2,2012 and 2016, C# and .NET, SharePoint

Development Tools: T-SQL

Reporting tools: SSRS, Qlikview

Source Control: Team Foundation Server 2010, Tortoise SVN

Other Microsoft Technologies: Informatica MDM (Siperian Tool), Oracle10g

Petrochemical Industry Technologies: Meridium and RTMS, Web Services and Powershell

WORKING EXPERIENCE:

Confidential

Technology-: MS SSIS and SQL Server 2012, 2016, Qlikview, Teradata, Autosys, Excel 2103, VB .NET, Tortoise SVN, AQT, host mainframes

Data Architect, ETL Lead

Responsibilities:

  • Requirements Gathering
  • Data analysis and data modeling
  • Design, build data models for BI operations
  • SME in ETL, SQL and data model
  • Business specific report development
  • Report delivery and signoff
  • Design and develop ETL framework
  • Leading offshore team
  • Support applications after Go-Live

Confidential

Data Architect, ETL Lead

Technology-: MS SSIS and SQL Server 2008R2, Biztalk,2012, Webservice, Powershell, Meridium, RTMS, Mustang, AspenTech, VB .NET, Erwin, Tortoise SVN

Responsibilities:

  • Requirements Gathering by communicating to various vendors across US and Europe
  • Doing research and Creating POCs for achieving connectivity to systems built in technologies such as Powershell commands for IP21 and E CEMS, Webservice for Meridium
  • Supporting Data loads and validation for MOM applications in production environment being at client’s place (Saudi Jubail Industrial Area) interacting with clients, verticals for sign off process
  • Lead IDC team in design, development, testing and deploy phases.
  • Designing and Development of SSIS packages for MOM base applications for referential Data Loading providing a centralized approach
  • Designed and Developed ETL Frame Work and Data base model and Project Documentation
  • Guiding and mentoring end User and Onsite team for Data Loading using executables
  • Support applications after Go-Live
  • Created asset for Confidential and Avanade on Data Load approach for MES Industry

Confidential

Data Architect, ETL Lead

Technology-: MS SSIS, SSRS, SQL Server 2008R2, SSAS

Responsibilities:

  • MSBI developer mainly on SSIS and SQL Server 2008 R2. Developed SSIS Packages for Data Extraction, handling transformations and generating text files, Created complex Views for data extraction, Stored Procedures and functions
  • Developed handling of Change Data Capture
  • Working on Claims Fraud Analysis, single handed interacting directly with onshore and SIRA to understand requirement and developing the components accordingly
  • Worked on other two projects on Data Warehouse modeling, SSRS development, testing Facts and Dimensions functionality, performance improvement and assisting ASE’s

Confidential

Data Architect, ETL Lead

Technology-: MS SSIS, SSAS, SSRS and SQL Server 2008 R2, Oracle 11g, Informatica MDM Siperian, C# and .NET, SharePoint

Responsibilities:

  • MSBI developer (SSIS, SSRS) Developed Fact packages and basic project internal packages using SQL Server Integration Services, fact packages were developed using business rules and transformations using Avanade ETL framework
  • Implemented change Requests in Cube using SQL server Analysis Services for CPD and I360 reports work streams
  • Developed reports for Business analysis using SQL Server Reporting Services. The reports were navigational reports using which the business people can see the customers (physicians) data and the interactions, meetings made by those physicians. These reports were deployed in Microsoft Share point -2010
  • Informatica MDM Developer Developed Base Object model and mapping between layers using business rules for Referential Data using Informatica MDM. This model consists of different layers through which Referential Data was passed and cleansed
  • Unit testing and Data Analysis for 10 source files.
  • Dot net developer, Developed a tool for the deployment of all MSBI components (packages, cubes and reports)

Hire Now