We provide IT Staff Augmentation Services!

Data Architect Resume

0/5 (Submit Your Rating)

NewyorK

SUMMARY

  • Over 11 Years of experience in Software Development involving Analysis, Design, Implementation and Enhancement of systems
  • Holds a valid H1B US VISA valid till September 2018 and B1 US VISA valid till December 2023
  • About 5 years of experience in SQL server BI (SSIS/SSAS/ SSRS)
  • Good experience in writing MDX and DAX Queries
  • Strong ability to analyze existing system and design logical/Physical data base design for data dawarehouse/DataMart applications in star schema/snowflake schema
  • Good Hands on experience on creating architectural document to design the information/data flow from various source systems to staging database and from staging to datamart.
  • Developed and implemented various ETL processes by using SSIS to move data from different sources to targets
  • Proven proficiency at Data Transformations like Derive Column, Conditional Split, Aggregate, Union all, Merge join, Lookup, Sort & Execute SQL Task to load data into Data Warehouse
  • Experience in developing and troubleshooting of SSIS packages
  • Performance optimization for SSIS packages
  • Preparing and managing the reports using SQL server reporting services for tabular, matrix, chart and image
  • Excellent experience in sql query performance optimization
  • Excellent experience in application development using SSIS, SSAS, SSRS, SQL Server, ASP.NET, Web Forms, C#, VB.NET, AJAX, JavaScript, VBScript, JQuery, Entity Framework, LINQ, ADO.NET, Web Services, User Controls, Custom Controls, SQL Server, SSIS, SSRS, Design Patterns, HTML, XML, CSS, Data Modeling, SOA and others
  • Experience in upgrading and porting legacy applications to .NET framework
  • Expertise in N - tier Web Development analysis, implementation, interfacing/reporting, data migration and troubleshooting. Extensive work in Developing web forms, web controls, and user controls in asp.net
  • Excellent experience with the entire Software Development Life cycle (SDLC) process including requirement analysis, conceptual and detail design, development, verification and testing. Experience in Agile software development
  • Developed project relevant documents like Software Requirement Specifications, High level design, Low level design, Technical Architecture, Unit Test plans, System Test plans, Project Release notice, Checklists for coding and reviewing, Coding standards, Project induction manual, Project plan, Statement of Work
  • Proven ability to getting the job done right the first time, building and motivating teams, meeting deadlines and operating within budget
  • Strong problem solving, logical implementation and trouble-shooting skills
  • Acceptance of new technologies with very quick learning approach
  • Excellent oral and written communication skills

TECHNICAL SKILLS

Software: SQL Server, SSIS, SSRS, SSAS, T-SQL, MDX Queries, C#, Visual Basic, VBScript, Visual Studio.Net, VB.Net, ASP.Net, AJAX, log4net, JavaScript, JQuery, Entity Framework, LINQ, Web Forms, HTML, XML, CSS, Web Services, ADO, WinForms, XPath, MS Project, Visio, PowerPoint, Excel, Crystal Reports, Visual Source Safe, ErWin, Design Patterns

RDBMS: MS SQL Server, MySQL, MSAccess

PROFESSIONAL EXPERIENCE

Confidential

Data Architect

Responsibilities:

  • Analyzing existing system, creating data dictionaries, creating ER diagram for existing system, identifying measures and dimensions and develop dimension model
  • Create a architectural document to design the information/data flow from source systems to staging database and from staging to datamart
  • Defined process for Error handling/ Error logging / Cleansing the bad data using DQS (Data Quality Services)
  • Developed SSIS packages to load data from source to datamart database on an incremental basis
  • Designed packages Using Control Flow Tasks like For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task and Transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations
  • Created Event Handlers for the Packages Using Event Handler for Error Handling based on client requirement
  • Maintained logging information in SQL table to tracking Errors and recording package execution status
  • Developed Logistics SSAS cubes
  • Unit testing the SSAS cubes

Confidential

Data Architect

Responsibilities:

  • Involved in presales activities include effort estimation, creating WBS, project plan and BRS document
  • Analyzed existing payroll system, Played a role of Data Architect and developed datamart in Star schema format
  • Create a architectural document to design the information/data flow from various source systems to staging database and from staging to datamart
  • Defined process for Error handling/ Error logging / Cleansing the bad data
  • Developed various complex stored procedures, functions to fetch data from different source systems
  • Developed SSIS packages to load data from different sources to data ware house database on an incremental basis
  • Designed packages Using Control Flow Tasks like For Each Loop Container, Sequential Container, Execute SQL Task and Data Flow Task and Transformations like data conversion, derived columns, look up, Conditional Split, Aggregate, Union all, merge join and multi cast transformations
  • Created Event Handlers for the Packages Using Event Handler for Error Handling based on client requirement
  • Maintained logging information in SQL table to tracking Errors and recording package execution status
  • Developed several complex reports using SSRS and made them available on Web for user community
  • Implemented role based securities for SSRS reports
  • Developed SSAS cubes to analyze the payroll datamart
  • Created dashboard using Qlik view to analyze the payroll datamart
  • Assisted team to work on SSIS & SSRS
  • Responsible for Code Review and design documents
  • Client interaction that includes verbal and written communication
  • Providing day to day support and maintenance for datamart application

Confidential, NewYork

Data Architect

Responsibilities:

  • Create document for Logical/Physical database design,
  • Enhanced existing web application written in C#, SQL server for market research application
  • Worked on very complex logic that uses lexical analysis, created a parser that parse the string for syntax validations
  • Worked on interop assemblies to create various charts using excel and PPT chart templates
  • Written SSIS package to extract the data from SQL source and convert into suitable format
  • Creation of configurations, Logging, Deploying packages to target server
  • Created Event Handlers for the Packages Using Event Handler to send an email to a group on any error
  • Scheduling SSIS packages Using SQL Server Agent in SSMS
  • Designed different types of reports like Drill Down, Drill Through and Parameterized Reports
  • Scheduled Reports on weekly basis as per the Client Requirement
  • Client interaction that includes verbal and written communication
  • Providing day to day support and maintenance for the application

Confidential, Saint Loius, MO

Software Developer

Responsibilities:

  • Proposed MSBI to develop such application instead of using dynamic T-SQL
  • Analyzed existing system and developed datamart in Star schema format
  • Developed SSIS packages to load data from sources to data mart database on an incremental basis
  • Developed SSAS cubes to analyze the datamart, that could be analyzed with MS-Excel
  • Developed web based application using C#, ASP.net, SQL Server, Dundas charts
  • Written complex MDX queries to retrieve data from SSAS Cubes and creating charts using Dundas charts
  • Analyzed various charting tools and proposed the best relevant tool for the application

Confidential, Westborough, MA

Data Architect

Responsibilities:

  • Comprehended various complicated process related documents to achieve EPCIS mark by the EPCGlobal Software Certification Program, a standards-based compliance testing program sponsored by the GS1 organization
  • Worked as an Data Architect to accommodate new database changes to support EPCIS standards
  • Based on existing application architecture, suggested technical solution to business problems
  • Upgraded the existing application to support EPCIS standards
  • Client interaction that includes verbal and written communication

Confidential, Austin Texas

Sr. Software Engineer

Responsibilities:

  • Supported existing web based application for enhancements and issues resolutions
  • Performed impact analysis for any new enhancement
  • Created a snapshot database to use only for information retrieval
  • Analyzed existing system and developed datamart in Star schema format
  • Developed SSIS packages to load data from sources to data mart database on an incremental basis
  • Developed SSAS cubes to analyze the datamart, that could be analyzed with MS-Excel
  • Responsible for Code Review and design documents
  • Client interaction that includes verbal and written communication

Confidential, Saint Loius, MO

Software Developer

Responsibilities:

  • Developed from scratch 3-tier .NET PDF forms based application using C#, ASP.NET, SQL server and Adobe Live Cycle Designer
  • Gathered user requirements and developed prototype for this application
  • Performed research to create a 3-tier application from scratch
  • Performed lot of research for cost effective PDF forms based application
  • Worked on XQuery to get access individual information from XML
  • Provided day-to-day support and maintenance for the application
  • Led team to develop and implement numerous PDF based forms using Adobe Live Cycle Designer

Confidential

Software Developer

Responsibilities:

  • Gathered requirements and analyzed how CRM can be customized to fulfill those requirements
  • Developed ASPX pages to customize CRM
  • Developed SSRS reports to customized CRM reports
  • Located at client side in Johannesburg (South Africa)
  • Supported CRM installation on client location

Confidential, Camarillo, CA

Software Developer

Responsibilities:

  • Developed windows based application from scratch for employee login-logout and generating their payroll reports based on their working hours and hourly pay rate for a shuttle service using VB.Net and SQL server
  • Provided day-to-day support and maintenance for complex scheduling and routing .NET application
  • Provided day-to-day support and maintenance for on line reservation systems for web based .NET application

We'd love your feedback!