We provide IT Staff Augmentation Services!

Senior System Architect Resume

Sacramento, CA

PROFESSIONAL SUMMARY:

  • Over 6 years of professional IT experience in design, development, implementation, maintenance and Testing in MS SQL Server 2012/2008 R2/2008.
  • Involved in the SDLC (system development life cycle) of a data warehouse and responsible for designing, coding, testing, implementing, supporting the ETL processes for data warehouse solutions/data marts and implementing the reporting requirements.
  • Experienced in SQL Server Business intelligence tools like SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS) as a back end developer in financial, health care, insurance and retail companies.
  • Experience in Logical and Physical Database design & development, Normalization and Data modeling using Erwin.
  • Experience in using T - SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
  • Experience in writing T-SQL queries and Rank functions.
  • Hands on Work experience in developing SSIS Packages to Load data into the Data warehouse from Heterogeneous databases such as Oracle, DB2, Sybase and MS Access.
  • Good understanding of ETL, Dimensional Data Modeling, Slowly Changing Dimensions (SCD) and Data Warehouse Concepts.
  • Hands on experience in creating Configuration files and deploying into file system and SQL Server database.
  • Experience in report building using SQL Server Reporting Services (SSRS) and creating various types of reports like Table, Matrix, Chart Reports.
  • Experience in Creating and Deploying SSRS Reports on the portal for user accessibility.
  • Experience in the field of Unit testing, have tested codes of T-SQL and SSIS Packages in the testing environment.
  • Knowledge in Backup and Restore.
  • Strong working experience in the Data Analysis, Data Profile, Data Quality, Design, Development, Implementation and Testing of Business Intelligence applications using ETL and ELT methodology.
  • Experience in creating SQL Server Maintenance Plan.
  • Experienced in creating Indexes, planning and implementing Server Security and authentication.
  • Experienced in using tools like MS SQL Profiler, Index Tuning Wizard, and Red Gate Data Generator.
  • Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

TECHNICAL SKILLS:

Operating Systems: Windows 2003/2000/NT, UNIX

Languages: SQL, Java 2, C, C++, T-SQL, PL/SQL

Database: Oracle, MS-SQL Server, DB/2, MySQL, MDM, Mainframes

Tools: Eclipse, RAD, WSAD, XML Altova, Rational Rose, ANT script,Log4jWeb Technologies: EJB, JSP, J2EE, JMS, JNDI, SOAP, Servlets, HTML, CSS, JavaScript, XML, XSLT, WSDL, Struts, Hibernate, And Spring.

Application Server: BEA Web Logic, IBM Web Sphere, JBoss, Apache Tomcat

System Design: OOAD/UML, MS-Visio, Rational Rose, RUP, J2EE Patterns

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento,CA

Senior System Architect

Roles and Responsibilities:

  • Created and executed SQL statements in both SQL production and development environments.
  • Provided SQL Support to front end users.
  • Resolved issues within production database using T-SQL queries.
  • Created SQL instances and databases as needed.
  • Executed daily batch processes, and researched file share for a duplication project.
  • Worked with Data Analyst to write user-interface.
  • Design, write and implement application database code objects, such as tables, views, functions, store procedures for different applications.
  • Utilized SSIS to manage and create ETLs to transfer data from various sources.
  • Able to communicate clearly and get along well with other coworkers.
  • Excellent understanding of database structures, principles, theories and practices.
  • Diagnosing and resolving database access and checking on performance issues.

Environment: SQL Server 2012, SSIS, VB.NET, ADO.NET, Microsoft Excel, Microsoft PowerPoint, SQL Server 2008 R2, Windows Enterprise Server 2010, MS Office 2010.

Confidential, Santa Ana, CA

Technical Analyst

Roles and Responsibilities:

  • Actively participated in interaction with users, team, DBA’s and technical manager to fully understand the requirements of the system.
  • Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
  • Successfully migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2008 using SSIS, BCP and Bulk Insert.
  • Expertise in enhancing and deploying the SSIS Packages from development server to production server.
  • Hands on experience on all phases of Software Development Life Cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
  • Creation, manipulation and supporting the SQL Server databases.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
  • Used ETL tool like SSIS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
  • Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
  • Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
  • Relocation of Databases from one server to another server using attach and detach databases.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Rebuilding the indexes at regular intervals for better performance.
  • Involved in Weekly Change Management, in which code developed by developers is being run on production server.
  • Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
  • Monitored and modified Performance using execution plans and Index tuning.
  • Installation of new SQL Server databases and upgrades.
  • To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: SQL Server 2012, SSIS, VB.NET, ADO.NET, Microsoft Excel, Microsoft PowerPoint, SQL Server 2008 R2, Windows Enterprise Server 2010, MS Office 2010.

Confidential, East Greenwich, RI

Data Analyst

Roles and Responsibilities:

  • Actively participated in interaction with users, team lead, DBA’s and technical manager to fully understand the requirements of the system.
  • Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
  • Implemented Functions, views, triggers and stored procedures and enforced business rules via checks and constraints.
  • Created indexes on selective columns to speed up queries and analyses in SQL Server Management Studio.
  • Created SSIS Packages user data from the Flat files on monthly and weekly basis.
  • Created Database objects - views, and functions and developing procedures for implementing application functionality at the database side for performance improvement.
  • Defined constraints, rules and defaults and developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
  • Assisted and supported issues related to the queries and database systems.
  • Designed SSIS packages to load data from different sources Text files, Excel to staging and staging to Data warehouse.
  • Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
  • Created datasets, data source and involved in deploying the reports in to the report server.
  • Created SSIS packages using script task by C#.
  • Created reports using SQL Server 2008(SSRS) and integrated into the web front end.

Environment: SQL Server 2012, SSIS, SSRS,VB.NET, ADO.NET, Microsoft Excel, Microsoft PowerPoint.

Confidential, Costa Mesa, CA

ETL Developer

Roles and Responsibilities:

  • Actively participated in gathering User Requirements and Online System Specifications.
  • Performed query plans and making sure every query is using appropriate useful indexes.
  • Modified current database by adding tables and relationships to support online system.
  • Coordinated with the front-end developer to put in the business rules and wrote procedures to check some of the rules at the backend at the time of entering data.
  • Worked in extract, transform and load(ETL).
  • Worked in Import and Export Wizard.
  • Developed SQL scripts to Insert/Update and Delete data in MS SQL database tables.
  • Created views as required by front end developer for easier implementation on web pages, and triggers on those views to provide efficient data manipulation.
  • Experience in ETL Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format
  • Data).
  • Expertise in using TFS to open bugs, create tasks and user stories, initiate change requests.
  • Used TFS source control to deploy application.
  • Created various connection managers (OLE DB connection, flat file connection,
  • ADO.NET connection, FTP Connection) available in SSIS to collect data from heterogeneous sources such as SQL Server, flat files.
  • Managing Extraction, Transformation and Loading (ETL) process pulling of data from various data sources using into staging areas and then target data base.
  • Created stored procedures and functions to support efficient data storage and manipulation.
  • Documented all processes involved in maintaining the database for future reference.
  • Worked on database system construction to include stored procedure construction and testing, persistence and business logic layer development.
  • Have experience working in ticketing system.

Environment: SQL Server 2008 R2, SSIS, Windows Enterprise Server 2010, MS Office 2010, VB.Net.

Hire Now