SUMMARY:

• Database developer experienced working with large complex DBs based on MS SQL Servers.
• Worked with SQL Server2005 - 2014, Visual Studio Data and ETL tools (SSIS).
• Working knowledge in Oracle 10g and PL/SQL.
• Experienced in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Strong T-SQL Programming skill with experience in query optimization & performance tuning by using SQL Profiler, Execution Plan, Performance Monitor and DBCC Command.
• Experienced in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.
• Performed Log Shipping and Database Mirroring.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Working experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL server 2008/2005/2000.
• Created Linked Servers between SQL Server 2008 R2 & Oracle 9i and 10g. Also, created DTS package for data transfer between the two environments.
• Experience in designing and optimizing the various T-SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.
• Experience in designing and handling SQL Reports, Sub Reports and Drill Down Reports with proficiency in designing report layout, sorting the data, defining subtotals for the reports using SSRS 2008/2005.
• Skilled in Report authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.
• Utilized SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report.
• Hands-on in ETL tools (SSIS) MS SQL 2005 and DTS in MS SQL 2000.
• Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Rules and SQL Performance Tuning.

TECHNICAL SKILLS

Languages: VBA, Visual Basic, SQL/TSQL, PL/SQL, C, C++

Databases: SQL Server 2000/2005/2008 , and Oracle 8/10g, MS-Access

Other: Red Gate, Cognos, Crystal Reports, SQL, ETL, T-SQL, Transact-SQL, DTS, SSRS/SSIS/SSAS, MS-Excel

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

SQL Developer

Responsibilities:

• Design and develop analytics/reporting solutions using SQL Server 2014, SSIS 2008, SSRS 2008, and Excel
• Support the Pricing team SQL database, standard data layer and ETL processes.
• Including processes around maintaining data integrity and proactively identifying data issues and improvements. 
• Implement necessary processes around documentation and development best practices across the group. 
• Oversee and ensure ETL processes are running properly and identify areas of improvement. 
• Understand schematic tables within core systems to obtain new/different pieces of data
• Build and maintain ETL data processes  

Confidential

Technical Operations Engineer/ Database Analyst

Responsibilities:

• Collaboration with Developers and QA departments on system changes/improvements for more sufficient data storage and processing.
• Creating complex ad hoc reports for Data Science analysis of business progress for different time periods.
• Designing and implementing a life cycle of Marketing Test-Control process that utilizes activity of three departments: Analytics, Account Management and Tech Ops.
• Design and implementation of standard and custom Tech Ops reports and report processing.
• Training and supervising tech ops engineers locally and remotely, both in USA and overseas.
• Creating technical documentation.
• Analyzing list comparison of participants against internal user tables, loading new participants to internal databases, and data scrubbing.
• Creating and designing ETL packages utilizing SSIS to import data from various sources and for SSIS packages providing data profiling, data quality and clean.

Confidential, Naperville, IL

SQL Database Developer

Responsibilities:

• Developed T-SQL statement to solve user incident issues
• Document changes, perform basic unit testing tasks, maintain versioning requirements and uphold all company development standards as related to the software development life cycle.
• Ensure all coding efforts are submitted for peer review to ensure accuracy and maintainability of software enhancements.
• Devise and create test data, test plans and benchmark measures of application performance.
• Assist Quality Assurance teams in debugging and testing developed software products.
• Perform per reviews of software development efforts to ensure accuracy and maintainability.
• Assist the supervisor in monitoring any assigned application systems or products.
• Maintain accurate documentation with regards to work performed, issues or problems defined and meetings attended.

Confidential, Chicago, IL

Product Data Analyst

Responsibilities:

• Develop and design packages, reports by using SQL Server Integration Service (SSIS). 2005, SQL Server Report Server (SSRS) 2005, Visual Studio 2005 and SQL Server 2005
• Developed and optimized database structures, stored procedures, views, triggers and user-defined functions.
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases
• Created SSIS Packages to extract data from Oracle 10g (using PL/SQL), Excel Files, MS Access files using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task to generate underlying data for the reports and to export cleaned data from Oracle 10g, Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse using VB.Net
• Developed the Stored Procedures, Triggers, Functions, T-SQL scripts

Confidential, Westmont, IL

Senior Business Intelligence/Reporting Consultant

Responsibilities:

• Meet with business users and stakeholders, create detailed requirements and build new reports in both Crystal Reports Enterprise Edition and SQL Reporting Services (SSRS).
• Development and designed reports using SQL Server Report Server 2008, Visual Studio 2008, SQL Server 2008 on Share Point Environment
• Business analysis, designing, developing, and testing before reports go into production
• Coordination with the Off-Shore team and QA of the Reports before reports go back to the business use
• Develop and design reports by using SQL Server Report Server (SSRS) 2005, Visual Studio 2005 and SQL Server 2005
• Migrated and upgraded SQL Server 2005 database to SQL Server 2008 environment using upgrade advisor and tested their applications.
• Installed and configured the database server (SQL Server 2008) in production, development and testing environments
• Developed the Stored Procedures, Triggers, Functions, and T-SQL scripts