We provide IT Staff Augmentation Services!

Business Analyst/sql Analyst/production Support Resume

5.00/5 (Submit Your Rating)

Charlotte, NC


  • A skilled software professional with around 5 years of industry experience in design, development and implementation of business requirements with MS SQL Server 2014/2012/2008 R2/2008/2005 database system in client/server environment.
  • Business Analyst with Hands - on experience in the fields of Information Technology and Quality Analysis..
  • Passionate and motivated individual who identifies and determines solutions to business.
  • Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005.
  • Implemented most of the ANSI SQL-89 specification for INSERT, UPDATE, DELETE and SELECT statements.
  • Experienced with Sun/Oracle J2EE Technologies: Servlets, JSP, JavaThreads, JavaBeans, JDBC, MVC.
  • Experience in Microsoft stack of BI solutions - SSRS, SSAS, and SSIS with MS SQL.
  • Expertise in Business Intelligence tools with Microsoft Technologies like SSIS/SSRS.
  • Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
  • Migration of Data from one database to another new or existing database or up gradation of Facets (4.71) Database using SQL Loader Tools
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.


Databases: SQL server 2005/2008/2008 R2/2012/2014, MS Access, Excel,SQL Server Management Studio

DW/OLAP: SSIS, SSRS, Business Intelligence Development Studio(BIDS), Enterprise Manager, Query Analyzer, Bulk Copy Program (BCP), Analysis Manager, SQL profiler.

Reporting: Report Builder 3.0, SSRS

Languages and Scripting: C, C++, C#, Java, HTML, CSS, PHP, SQL, T-SQL (Transact SQL)

Operating Systems: Windows 8/7/XP/Vista

Architecture: Relational DBMS, Client-Server Architecture, OLTP, OLAP


Confidential, Charlotte NC

Business Analyst/SQL Analyst/Production Support


  • Works as a part of Global Compliance team which test monitors the systems that acquire processes, reports and archives data from a worldwide network
  • Provides analytical support in EIT activities related to multiple Compliance Control Functions.
  • Gathers and organizes data in order to track, report and monitor effectiveness of controls and in tracking, monitoring and escalation of risk related issues to management
  • Works within the policies and standards regarding sampling methodologies.
  • Conducted detailed analyses of complex systems using Excel, Access, and SQL Server Management Studio.
  • Developed various backend application programs, such as Views, Functions, Triggers, Procedures and Packages using SQL and PL/SQL language.
  • Dataanalysis on climatic datausing cross validation techniques.
  • Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQLServer Reporting Services (SSRS).
  • Developed various operational Drill-through and Drill-down reports using SSRS.
  • Provided technical support to programmers. Handling production, scheduling, and processing.
  • Implemented modules using Core JAPIs, Javacollection, Threads, XML, and integrating the modules.
  • Developed user Interface using JSP, JavaScript and HTML.
  • Attended daily status meeting to follow-up and resolve outstanding group issues.
  • Development and maintenance of all technical documentation.
  • Analyzed and determined priority to escalate failed jobs in a shortest possible time resolution to deliver a regular production cycle without delay.
  • Assured the consistency of data transmissions.
  • Worked closely with test, development and requirements team members to analyze, investigate and resolve the Issues during transmission time inorder to deliver the data ontime
  • Followed daily workload process, monitored timely starts of downstream feeds, and investigated and expedited any delays.
  • Creates and maintains documentation for supported applications.

Environment: SSIS, SSRS MS SQLServer 2012, Java,2008, R2/2005, Teradata,Toad, SharePoint, Visual studio 2008/2010, MS Access, MS Excel

Confidential, RYE, NY

Business Analyst/SQL server Developer(SSIS,SSRS)


  • Responsible for creating the reports based on the requirements using SSRS 2005/2008.
  • Migrated DTS packages from SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008 as SSIS Packages.
  • Working on PL/SQL, T-SQL to migrate data into (Facets) application.
  • Created SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Installed SQL server 2012 and migrated all ETL packages and reports from 2008 to 2012.
  • Designed SSIS packages to extract, transfer, load existing data into SQL server from different environments.
  • Performed analysis and presented results using SQL, SSIS, MS Access, Excel, and Visual Basic scripts.
  • Imported, exported and manipulated large data sets in multi-million-row databases under tight deadlines.
  • Wrote and automated tools and scripts to increase departmental efficiency and automate repeatable tasks.
  • Manipulated files and their associated data for rapid delivery to clients or loading onto internal databases.
  • Collaborated with project managers, legal counsel, and other team members to gather data for projects.
  • Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
  • Technical hands-on expertise using OLAP tool Business Objects 4/5.x/6.0 /XIR2(Reports, Designer, Web Intelligence, Info view, and Supervisor)

Environment: Microsoft SQL Server 2008/2012 Enterprise Edition,SQL server reporting services, MS Access, ETL Packages (SSRS,SSIS),SQL Server BI Development Studio(SSIS,SSRS)Great Plains, PL/SQL, Visual Studio 2008 & 2005, Visual Source Safe, DTS, T-SQL, Oracle 10G,nt scripting, SQL Server Integration Services (SSIS) 2012


SQL Developer(SSRS)


  • Analyzed data collected in stores (DTS Package, T-SQL, jobs, stored-procedures and queries) and provided reports to the commercial team (Excel, VB Script, Macro).
  • Compiled lists of stores respecting criteria given by client services, while minimizing collection costs (T-SQL, Queries, Views).
  • Assured and checked the quality and the integrity of the data received from the store collectors (T-SQL, Queries, jobs, stored-procedures).
  • Wrote and analyzed trending reports, drew extrapolations from findings to/with the project manager and the commercial team (SSRS Excel, T-SQL, Queries).
  • Optimized DTS, stored procedures and jobs into SQL Server to increase overall performance and time/server use of daily functions.
  • Defined parameters for parameterized Reports using SSRS.
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Perform data collection and analysis for senior living projects utilizing cost reporting data and other client financial information.
  • Performed sophisticated ad-hoc or ongoing custom analyses against medical claims to support business stakeholders
  • Developed and deployed quality T-SQL codes, stored procedures, views, functions, triggers and jobs
  • Created SSIS packages to retrieve data from Legacy sources and also to retrieve PII user data from the Flat files on monthly and weekly basis.

Environment: Microsoft SQL Server 2008/2008 R2 Enterprise Edition, MS Access, ETL Packages (SSRS,SSIS),Great Plains, PL/SQL, C#,VB.Net,ASP.NET, .Net 3.5 SP1, SQL Diagnostic Manager, SP2 & 3.0, HTML, IIS, Visual Studio 2008 & 2005, DTS, T-SQL, Oracle 10G,nt scripting, TFS.


Business Analyst and SQL Server Developer(SSIS,SSRS)


  • Created daily reports in designed Excel spreadsheet with pivot tables.
  • Identified data issues and provided recommendations for resolution to ensure optimal performance.
  • Performed and conducted complex reporting analytics
  • Diagnosed and addressed operational data requests
  • Interacted and communicated with colleagues as needed as both a technical and functional expert.
  • Reated SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
  • Unit/System Testing & validation of reports using Complex SQL,PL/SQL scripts
  • Developed complex SQL code using complex Joins, Group By, Having, Subqueries, Correlated Sub queries, Functions, and User Defined Functions.
  • Maintained Database backups for the team using performance tuning and migration methodologies for improvement.
  • Gathered requirements to identify and create database objects such as tables, views, triggers and indexes.
  • Involved in creating, deploying and configuring as per the requirements.
  • Developed and deployed SSIS packages and maintained the jobs running on servers.
  • Managed the security of the servers.
  • Involved in fixing reports and bugs in stored procedures.
  • Created views to enforce security and data customization.
  • Created stored procedures for commonly used complex queries involving join and union of multiple tables.
  • Developed user requested reports using Excel.
  • Created drill down and drill through reports.

Environment: DTS, Windows XP, MS Projects 2000, Windows 2000 Server, Windows 2003 Server, SQL Server Integration Services (SSIS 2008), SQL Server 2005/2008, MS Access, T-SQL, PL/ SQL, Triggers, Packages & Stored Procedures, SSRS 2008

We'd love your feedback!