SUMMARY

• 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.

TECHNICAL SKILLS

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

PROFESSIONAL EXPERIENCE

Confidential, Charlotte NC

Business Analyst/SQL Analyst

Responsibilities:

• 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)

Responsibilities:

• 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

Confidential

SQL Developer(SSRS)

Responsibilities:

• 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.

Confidential

Business Analyst and SQL Server Developer(SSIS,SSRS)

Responsibilities:

• 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