We provide IT Staff Augmentation Services!

Data Architect Resume Profile

4.00/5 (Submit Your Rating)
Hire Now

TECHNICAL SKILLS:

- Databases: MS SQL Server 2000 - 2012 , Teradata , Oracle databases, MS Access, ODBC. 12 years of SQL development experience: stored procedures, views, T-SQL framework, database design, administration, reporting.

- BI Development: Visual Studio 2012 Services, SSIS, SSRS, SSAS.

- Visual Studio 2010 C , ASP.NET, VB.NET, ADO.NET : experience in creating web based application, custom software for databases, tools and libraries.

EXPERIENCE:

Data Architect

Confidential

  • Digital coupon distribution and redemption.
  • - Design of the back-end processes, Databases, ETL and Reports on MS Azure Cloud Platform using Visual Studio 2012.
  • - Prepare packages and reports to move to Visual Studio 2013.
  • - Data Modeling, Development of Server objects using MS SQL Server 2012.
  • - Setup and support of the MS SQL and SSRS servers.
  • - Creating of daily jobs using SSIS development in Visual Studio 2008.
  • - Support of the management and clients on access and security.

Reporting DBA Confidential

  • - Creating SSIS and SSAS packages for SSRS reporting and data migration.
  • - Support of C and ASP.Net User Interface.
  • - Data integration in using web services, multi-source data connections and other SSIS tools
  • - Development on MS SQL: T-SQL, SP, triggers, jobs.
  • - Design logical and physical SQL Server database environments, migration, integration, scripting.
  • - Data Modeling for Multi-dimensional databases and Data Warehouse using star and snowflake schema.
  • - Daily duties of the Production DBA: scheduling and control of the processes, error fixing, data update.
  • - Worked with QA on troubleshooting.

Business Intelligence Developer Confidential

  • - Migrating off of Cognos platform and developing a new Microsoft BI Stack solution within SQL Server 2008.
  • - Creating the Data Mart. Scripting databases and processes.
  • - Creating BI data exchange structure using C and SSIS
  • - Creating Reports in using SSRS and C User Interface.
  • - Migrating off of Crystal Reports and Interactive Reports into SSRS.
  • - T-SQL coding of stored procedures and other SQL Server tools for special solutions.
  • - Building and publishing C web based applications for User Interface.

Data Management Specialist Confidential

  • Medical billing, Insurance Hospital Patient reconciliation
  • - Coordinate daily import and export of client data, and administer all data conversion processes in using ETL, SSIS, DTS, XML, VBScript, MS Excel, HL7 and MS Access.
  • - MS SQL 2005 data maintenance Administer and execute advanced query and report creation requests
  • - Support and maintain C , VB.NET and ASP.NET proprietary application
  • - Data warehousing, architect and create new databases, back up and optimization.
  • - Create reports based on SQL server database in using T-SQL, SSRS, OLAP, Cubes and Crystal Report.
  • - Develop Web User Interface in using HTML, JavaScript, and Web Services.
  • - Secure data transfer in using PGP Data Protection, Secure FTP service.
  • - Business object development and exposure of business logic via .NET Web Services.
  • - Seamless integration of new applications into a high-volume 24x7 production environment.
  • - Setup and maintain automated Report modules in ASP application, and monitor the process.

Data analyst Confidential

  • Corporate clients and special projects department.
  • - Migration of DTS into SSIS packages
  • - Creating and support of back-end SQL database for large multi tiered web based and local applications. T-SQL, DTS, stored procedures, functions, triggers, views, and etc.
  • - Reporting in using MS SQL server 2005 SSRS and OLAP
  • - Determining the specifications and design as the project leader.
  • - Data analyzing, transferring, reporting in using ETL, SSIS, DTS, XML, EDI.
  • - .NET auto ETL applications in using VB.NET, SSIS, PGP, and SFTP tools.
  • - Publishing of reports and tools in using Sharepoint.

Software Developer Confidential

  • - Upgrading application from VB6 and MS Access up to VB.NET and SQL Server.
  • - Applications for Quality Control Systems, for Management of Special Testing tools
  • - Creating and support reporting in Crystal Report, MS Access, MS Excel.
  • - Data Transformation Service. Moving the data for better reporting, reformatting from MS Access, Excel, ASCII, SQL Server 2000.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship