SUMMARY:

• Around 9 years of experience in SQL Server 2014/2012/2008 R 2/2008/2005/2000 Development and data migration.
• Lead a team of report developers; taught them how to write optimized SQL to have the report created. Using BI Developer 2008, TFS 2008, SQL Server 2008.
• Ability to document test events and coding details.
• Complete knowledge of Excel functions and macro programming.
• Experience in Version Control Tool like TFS,SVN.
• Sound knowledge of SSDS design principles and applications.
• Excellent Analytical and creative problem solving skills with ability to design, create and test SSDS systems and Ability to provide SSDS system diagnoses and resolution.
• As I am thorough with standard SSDS procedures, I have been put in charge of repairing, maintaining and upgrading present SSDS systems using necessary solutions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Prepared maintained and modified SQL server configuration documents.
• Proficiency in Performance Tuning, Query Optimization.
• Soundknowledge of stored procedures, Indexed views, User Defined Functions (UDL), Triggers Distributed Queries and Common Table Expressions.
• Builtcomplex SQL queries (ex: using various joins andsub - queries) and stored procedures.
• Exposure to all phases of the project- Documentation, Designing, Unit testing and Defect Fix.
• Develop and tuneSQL Server Integration Services (SSIS) packages and reporting services (SSRS) reports and models.
• Created packagefordata transfer between the SQL and Oracle environments.
• Designed and tuned SSIS packages (ETL) to implement Business rules.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Very well aware of the changes made to Configurationfiles and deploymentmodels and other changes in SQL Server 2012 and SQL Server 2014.
• Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.
• Good knowledge on creation and scheduling of T-SQL jobs.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2008, 2003R2, 2003, 2000 Advanced Server, Windows NT, Windows 95/98/2000 XP/Unix

Databases: MSSQL Server 2000/2005/2008/2008 R2/2012/2014, MS Excel/MSWord/MS Access

Database Tools: SQL Enterprise Manager, SQL Profiler, Power Shell, DTS Import/Export, SQL Client Configuration utility, MS OLAP Services, SSMS, SQL Server BIDS/SSDT(SQL Server 2012)

Modeling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams, MS Visio, Rational Rose, ERWIN.

ETL Tools: Experienced working with SSDT/BIDS-DTS, SQL Server Integration Services (SSIS), SQL Server Reporting (SSRS).

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports, Elixir Report

Development skills: Transact SQL (T-SQL)

Languages: C, HTML5, XML, VB.Net, VBA

PROFESSIONAL EXPERIENCE:

Confidential - South Boston, MA

SQL Developer

Responsibilities:

• Perform MS SQL database programming tasks and use ETL software to support changes
• Use scripting languages to provide technology solutions (Batch, Shell, Dot Net, Scheduler)
• Develop professional database design in Microsoft SQL databases for enterprise applications.
• Develop sql queries, views, triggers, stored procedures, call functions, and replication/mirroring.
• Develop and tuneMicrosoft SQL Server Integration Services (SSIS) packages and reporting services (SSRS) reports and models.
• Analyze information on storage, plan storage needed, monitor available space, watch growth trends and advise on long term capacity planning
• Performance monitoring and tuning-- monitor the database server on a regular basis to identify bottlenecks and address the issues
• Perform analysis, QA, implementation, and deployment tasks as part of the software development lifecycle.
• Use source code control software to manage source code and application development projects
• Assist senior team members to drive technology projects to completion as per department goals
• Develop applications using SQL server, Access, Excel,XML.
• Import data from a variety of formats and transform them using business rules to output to formatted reports
• Utilize proprietary SSC.dlls that import data from SQL server systems to allow the user to review financial entries and book the entries back into SQL server using VBA automation
• Develop ad-hoc reports for SSC client reporting, departmental and inter-departmental financial reports and accounting entries using VBA automation.
• Import data from SSC intranet pages for review and transformation by the user.
• Develop data migration processes, integration processes for a vended application that has a .Net, SQL Server, IIS as technology stack.
• Act as a Prod Support Person for the vended GRC application
• Resolve customer issues by establishing workarounds and solutions and by debugging and creating defect fixes.
• Build new services to get the details from the External/Internal Systems.
• Demonstrates creativity, the ability to develop and present new ideas and conceptualize new approaches and solutions.

Confidential, Lancaster, South Carolina

Lead SQL /MSBI Developer

Responsibilities:

• Understanding the functional specifications. Estimating the effort Involved in fulfilling the requirements and preparing the analysis document.
• Lead programming team to redesign and implement the existing software. Using VB.net, SQL server, Access, Excel,XML.
• Lead a programming team in developing designing and implementing the database and the middle-tier objects, which allowed smooth communication to the database and speeding of developing the interface. These objects provided the capability to complete every form within 2 hours. Using VB, SQL server.
• Export and import data to and from database into Excel sheet.Plan, test, and implement templates.
• Developed Charts and other visualization using Power View.
• Developed Power Pivot Reports in Excel 2013 by publishing them to SharePoint 2013 for providing ad-hoc reports according to client need.
• Loading data in various Wave environments and Bug Fixing of the application in various areas.
• Moving/Coping data from APPX environment to SQL environments and preparing windows batch scripts. Communication to stakeholders - Business partners and IT Management.
• APPX activities on various Servers TMG, STG, PROD, Wave 1,2,3,4,5,6,7 environments.
• Worked in Grouping, Summing, totaling, Case Limits, Common Table expressions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Hands on experience in VBA, EXCEL, MS Access and CSV.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed model.
• Provide technical support for Unix systems and Optimize performance and resolve problems using programming skills.
• Develop and write code for Unix platform and wrote Unix shell scripts for system administration.
• Involved in writing MDX Scripts for the OLAP CUBES.
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Supported regular production runs through scheduling FTP, Encryption and Frequency.
• Setup the MS Team Foundation Server (TFS) environment for development team, Build definitions, and other SDLC related processes.
• This application included team members from other countries using TFS in environment for collaboration.
• Created XMLPackage Configurations,Error Handling usingEvent Handlersfor On Error, On Warning, On-Task Failed Event Types.
• Worked with re-directing outputs into different formats including XML Files and various other data sources.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool and ER Studio.
• Helped in the design of the Architecture of the Data Warehouse and helped in performance tuning of the database.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server using Microsoft Sql Server BI Suite.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, ExcelSpreadsheet to SQL Server 2012.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS (Microsoft Visual Studio 2010).
• Selected and implemented agile development practices according to the application requirements for every project.
• Ensured participation of clients in the process of development.
• Extracting data from Oracle and loading to SQL server 2012.
• Developed & maintained Web Forms with ASP.Net, Silverlight and C#, .Net.
• Provided assistance for integration of front end and back end applications.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Experience in Design and Development of GUI (Graphical User Interface) usingC# Win Forms and ASP.NET Web Forms.
• Microsoft .Net application development, Object-Oriented Analysis/Design.
• Significant understanding of the Microsoft .NET Framework with significant programming experience in C# .NET, ADO.NET, Web Services and Remoting.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Tasketc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data ware house.
• Extracted data from XML to SQL server.
• Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.

Environment: SQL Server 2008, SQL Server 2012, APPX, AS400, SSIS 2014,MS Visual Studio 2010,c#,Oracle DB,TFS,XML

Confidential, Smyrna,GA

Lead SQL /MSBI Developer

Responsibilities:

• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Developing the Applications using HTML5, JQuery, Java scriptand Preparation of Unit Test Plans, System Test Specifications.
• Packages created in Jenkins and deployed into Unix servers through HP Opsware tool.
• Package implementations are verified using Unix shell script.
• Wrote Unix scripts to validate the implementation and to pull data from the database for reports.
• Filter and Sorting Data using Power View in Excel 2013.
• LEAD SQL developer, who designed and developed many complex stored procedures, triggers, views, and tables.
• Participated in the designing and development of software using agile development practices.
• Hands on SSIS, SSAS development and production of around 32 data marts and the Enterprise Data Warehouse, Meta data and Universe creation for reporting
• Hands on architecture and creation of Business objects universes, cube universe, business views for crystal reporting, developed security implementation, basic administration.
• Performed the research and development tasks to design and implement new components.
• Worked in Grouping, Summing, totaling, Case Limits, Common Table expressions.
• Hands on experience in VBA, EXCEL, MS Access and CSV.
• Analyzed needs of modification and implemented development. Provided maintenance and security to Excel worksheet and database.
• Supported Product Engineering team and monitored product design activities.
• Maintained system entries and handled customer product qualification activities.
• Bulk Import and export of xml documents and data into the system.
• Handled Customer Issue Resolutions and aided 8D activities.
• Managed daily line management and assisted full turn-key applications.
• Coordinated in Technology Review Meetings and corresponded about engineering activities.
• Developed user interface (UI) and data analysis component with integration of duplicate file finder.
• Designed a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.
• Created and maintained the Data Model repository as per company standards.
• Performed data extraction and migration activities for populating test (or non-production) and customer databases.
• Created automated diagnosis, testing and debugging modules
• Leadership abilities and team work skills as well as the ability to accomplish tasks under direction and supervision.
• Handled numerous change management requests on Development servers.
• Handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores.
• Involved in complete Software Development Life Cycle (SDLC), which includes requirement gathering, analysis, design, development, and Implementation
• Successfully tested all task in staging and stored all versions of data using team foundation server (TFS).
• Created a new mapping document with EDI team to transfer data outside the company. We follow the standard format to transfer the data to third party.
• We tested the data file transfer through EDI.
• Prepared daily and weekly status reports and collaborated with other team members.
• Writing server side code for various web forms using c#.
• Development of ASP.NET user controls/ Classes using c#.

Environment: HTML5,DB2, SQL Server 2014,SQL Server 2012,SSIS 2012,Visual Studio 2012,c#,TFS,XML,Java Script

Confidential

Lead SQL /MSBI Developer

Responsibilities:

• Work with DBA’s on Production issues and provide resolution.
• A thorough professional with proactive attitude, out of the box thinking and generating new ideas.
• A keen communicator with the ability to relate to people across all levels in the organization.
• Demonstrated leadership abilities and teamwork skills as well as the ability to accomplish tasks under minimal direction and supervision.
• Involved in SourceData Analysis, analysis and designing mappings for data extraction.
• Change management requests on production and Development.
• Involved in Unit testing, debugging and handles datasets using complex queries and stored procedures.
• Prepared, maintained and modified SQL Safe installation and configuration documents.
• Participated in Deployment release of the third party tools.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. This involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Used SQL Server 2008 Activity Monitorwhen troubleshooting a performance issue or monitoring a server in real time.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Conducted root cause analysis of application availability and narrow down the issues related to coding practices, database bottlenecks, or network latency.
• Prepared detailed design documents identifying program and database design changes.
• Reviewed third party tools to automate routine tasks such as monitoring, blocking and consolidate status of scheduled jobs.
• Monitoring LOGS, Application logs and analyzing the logs.
• Developed Power Maps using Excel 2013 for Reporting.

Environment: Elixir Reporting tool, Oracle, SQL Server 2012,SSIS packages,Visual Studio 2012,c#

Confidential

Lead SQL /MSBI Developer

Responsibilities:

• Created SSIS packages for importing the Excel layouts into the database using SSIS.
• Study and understand the requirements of the information required by company’s Procurement Department about the vendors.
• Used BIDS to design SSIS packages to transfer data between servers, load data into database, and archived data file from different DBMS. Scheduled the job to do this task periodically.
• Loaded data from ODS to Data Warehouse using SSIS packages.
• Using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes.
• Designed and developed Drill down and Drill Through reports with Drop down menu option using SSRS.
• Did Migration of the data from DTS to SSIS packages.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Configured the SSIS Packages using Environment Variables for Dynamic Selection of Development and Production Environment.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queries.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved in SourceData Analysis, analysis and designing mappings for data extraction.

Environment: SQL Server 2012, SSIS 2012,DB2,Oracle,Teradata,Visual Studio 2012

Confidential

Lead SQL /MSBI Developer

Responsibilities:

• Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.
• Improved data load performance by analyzing database design and query plans.
• Modified and Create Joins to Improve the Database and execution speed.
• Experience in optimizing the database by creating various clustered, non-clustered indexes and indexed views.
• Involved in Performance Tuning using SQL Server Profiler and SQL server Hints. Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Worked with T-SQL development and performance tuning in T-SQL code. Participated in Performance Tuning of Code using execution plan and SQL profiler.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Added Indexes to improve performance on tables. Used multiple join statements to retrieve data from multiple tables.
• Wrote custom T-SQL stored procedures and triggers to improve performance, reduce latency, preserve referential integrity, and provide additional application functionality.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database.

Environment: SQL Server 2005, SSIS 2008, DB2,Oracle, Teradata

Confidential

Database Programmer

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Created checkpoints and configuration files in SSIS packages
• Implemented slowly changing dimensions in SSIS packages.
• Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.
• Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and Named queries.
• Involved in defining d relationships with measure group and fact tables.
• Defined Granularity with in a measure group and drill through actions.
• Implemented the calculations to aggregate physical measures.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: SQL Server 2005, SSIS 2008,DB2,Vb.net,SQL Profiler, ASP.NET

Confidential

Software Engineer

Responsibilities:

• Functionality representative for the Execution Module and Involved in designing of screens using Crystal Reports and MS SQL.
• Involved in coding of application components and Involved in Writing Stored Procedures,functions,triggers, packages, designing forms and reports.
• Created SSIS packages to clean and load data to data warehouse and package to transfer data between OLTP and OLAP databases.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Created several materialized views and UDF’s to be accessed by the new front end applications.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases
• Optimized the performance of various SQL scripts, stored procedures and triggers by using embedded UDFs, CTEs and System stored procedures.

Environment: SQL Server 2005, QBDesign(Inhouse Tool),VB.net,Business Objects Crystal Reports,SSRS,asp.net