b7891e9c-6a99-4c42-ad17-907236df72f5

Andrew Smith

287 Custer Street, Hopewell, PA 00000
andrew_smith@example.com
(000) 000-0000

Professional Summary

Innovative, forward-thinking executive offering over 4 years of success in various leadership roles in the areas of Information Technology consulting, customer support, global business development.  Expert in strategic and tactical planning, client relationship management (CRM), corporate governance, and change management.

Employment history

SQL Developer, Mann-Daniel. Charisseland, Utah
Dec. 2018 – Present
  • Project Names: Infor PLM, LTP, GORE, Dansk, Future Retail Limited (Big Bazar)
·         Created new tables, written stored procedures for Application Developers and some user defined functions. Created SQL scripts for tuning and scheduling
·         Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes and Execution Plan)
·         Trouble shoot problems with the various teams.
·         Developed Addins
·         Creating and automating the regular Jobs
·         Worked on SSRS (Sql server reporting services). Used matrix and Tablix and sub report for creating reports.
·         Transformation of data from one server to other servers using tools like bulk copy program (BCP), data transformation services, data conversions from legacy systems to SQL server.
·         Worked on Dev Ex. Used matrix and Tablix and sub report for creating reports.

Junior Developer, Von Group. Mraztown, Rhode Island
Feb. 2015 – Feb. 2016
Project Name: Vichare Courier, Fort Point,COSMOS,KAIZEN Framework
·         Worked as Assistant Software Engineer.
·         Worked on Platform of MSSQL
·         Analysing and handling MS SQL related issues.
·         Extending high-end technical support
·         Handling issues related to Procedures, Functions, Views, Triggers, Complex Queries, etc.

Education

The Purdy College, West Cory, Alaska
Master of Technology, Computer Science, Present

West New Mexico Institute, Jeremiahhaven, Illinois
Bachelor of Engineering, Information Technology, Jan. 2012

North Prohaska, West Brittanyshire, California
High School Diploma, Feb. 2007

Skills

SQL
Experienced

SSRS
Experienced

SSIS
Beginner

DevEx Report
Skillful

sql developer

  • Took part in providing sandbox presentation to clients on WebEx and Skype calls.
  • Took a major role in answering questioner to RFP. 
  • Testing the website based on the provided test cases.
  • 24/7 support to on weekly rotation. 
  •   Involved in creating SSIS Package Configuration using variables and SQL Server. 
  •   Created Master Package to call other packages and Processing Cube using SSIS. 
  •   Deployed SSIS packages using File System Deployment. 

sql developer

  •  Created and integrated a component for scanning purposes based on SQL Server.  
  • Managing the CRUD operation of database to meet the requirement of different clients at US E-Direct.
  • Extracting the data from different table by performing join methods.
  • Provided Level 1 and Triage support.

sql developer

  •   Designed and created database systems on the end users requirements. 
  •  Wrote SQL queries using programs such as Payroll Modules (Salary,Attendance,Employee Induction,Employee Personal Information) and HM Related Queries. 
  • Perform analysis and effective diagnosis of issues. 
  • Changes in business logic and implement them in the application using SQL Techniques. 
  •  Mainly working on making D-Cube Reports and Management of Software RAMCO. 
  • Worked extensively with engineering staff to better understand Query Optimisation related solutions and benefits to projects. 
  • Maintained quality-focused performance benchmarks and schedules when directing project teams. 

sql developer

  • Dealing with the forms requested by clients through agile process.
  • Analysis of user requirements, create and modify block diagrams    and logic flowcharts.
  • Oversee architectural development and software activities.
  • Assisted with detailed technical designs to develop project-specific   programs.
  • Strong debugging skills, creative preparation of user-level documentation 
  • Expertise in SQL Technologies, SDLC (Software Development Life Cycle), and design and development of web-based application.
  • Detailed hands on experience with scripting languages such as Linux and Unix.

sql developer

  • Creating new database, tables, and views using SQL Server 2008 R2 (SSMS).
  • Converting ad-hoc query into stored procedure
  • Reviewed DB Scripts from the development team before releasing them into the production
  • Trouble shooting problems by using SQL server profiler and DTA
  • Generated drill down, drill through, sub reports, cube reports, multi parameterized reports using report designer and created template reports for business usage
  • Create cube reports using Analysis tool to meet business requirement
  • Worked on SVN for managing task requirements and deployments  

sql developer

  •   Involved in designing of Datamart using Star Schema. 
  •  Created Views, Stored Procedures and scripted Sub Queries using T-SQL involving multiple numbers of tables. 
  •  Involved in creating a script for the entire database. 
  • Designed and Developed SSIS Packages using various Control Flow and Data Flow items to extract, Transform and Load the Data from various Sources to Database and Vice Versa. 
  •   Involved in importing and exporting data from MS Excel and other OLEDB sources into SQLServer using SSIS. 
  •   Developed SSIS Packages to populate Datamart from various types of source files (EXCEL,Access, Flat files, CSVs, OLEDB Sources). 
  •   Involved in using the Script Control flow task to find the last written time of the file. 

sql developer

  • It includes importing data, updating data, extracting data on Development, pre-production and Production server.
  • My Major Role at organization is to take regular calls with US Project Manager analyzing the requirement to perform DBA task. 
  • Importing region, place, facilities, unit’s data on server using temporary table method.
  • Running the scripts against temp table to distribute data to actual tables. The same data will reflect on both Recreation Dynamics Software & Websites.
  • Data updated done using temporary table method.
  • Importing and updating Image path on server, plotting images & creating maps.
  • Creating store by importing specified data for different parks and assigning different security level such as Admin, Super-Admin, Manager, and Booking-Agent to access RD App at Store level. 

sql developer

  • Have independently handled projects and have fixed defects individually.
  • Learnt technologies like Mongo DB, SSIS, SSMS and T-SQL according to the requirement of business projects.
  • Have taken initiative to handle projects individually and took full ownership of support projects.
  • Have trained interns on SSIS and SSMS and have attended daily scrum calls and client calls.

sql developer

  • Designed and created database systems on the end user’s requirements.
  • Wrote SQL queries for Attendance Management and Leave Modules and Payroll and Time Office.
  •  Mapped industry standard design patterns to existing codebase to derive a component architecture model of the system. 
  •  Set and achieved product quality objectives while meeting product specifications. 
  •  Provided senior technical support to both in-house staff and user departments for all network applications.
  •  Chosen as the main corporate office contact, answering questions and resolving issues from customers and vendors.
  •   Worked closely with clients for the duration of the projects. 

sql developer

  • Project Names: Infor PLM, LTP, GORE, Dansk, Future Retail Limited (Big Bazar)
  • Lifelong Medical care
  • Bulamu Healthcare
  • Bluenovo

sql developer

  • Worked on building Management System solution for business enterprise.
  • Document and archive database schemas, ER Diagrams for Databases for system owner usage.
  • Writing Triggers, Stored Procedures, Functions, define User Defined Data Types, T- SQL, and Create and maintain physical structures. 
  • Create / Manage Table Indexes, Query Tuning, Performance Tuning.
  •  Wrote T- SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs 

sql developer

  • Understanding the requirements, coding and Development.
  • Creating stored procedures and query in Teradata SQL and SQL Server.
  • Worked on SQL commands like Rank, Rownumber, where, like, in, and, group by, order by, having and various aggregation functions, temp table, table variable etc
  • Performance tuning on T-SQL queries and stored procedures.
  • Creating query in Teradata. 
  •  Creating the missing index to improve the performance
  • Configuring User application to Database

senior sql developer

  • Joined as a SQL Developer for a US based auto price comparison website “Compare.com”.
  • Worked on sales matching mechanism which increased the Quote Sales match to 95%.
  • Worked on upgrading the data warehouse from SQL Server 2012 to SQL Server 2016.
  • Implemented XML Shredding using X-Query for some new products e.g. Bundled,EQS.
  • Used Tableau for building reports for better user experience.
  • Used SSIS for Extracting, Transforming and Loading data into data warehouse.
  • Worked on improving data quality in data warehouse by updating it historically.

sql developer

  • Communicating with the business users regarding software requirements
  • Creating reports using IIS and Microsoft Reporting Services
  • Coding Transact-SQL procedures and other local DWH developments
  • Falls Lake Insurance