SUMMARY:

• 3+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2008 R2, 2008 and 2005.
• Working noledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.
• Experience in SQL Server Replication, Backup/Recovery, Disaster recovery and planning
• Very good T - SQL Programming skills. Experience in query optimization & performance tuning by using SQL Profiler, Execution Plan, Performance Monitor and DBCC Command
• Experience in data transformation services like SSIS, DTS, BCP and Bulk Insert.
• Expertise in Database Administration on Production Servers wif server configuration, performance tuning and maintenance wif outstanding troubleshooting capabilities.
• Having hands on experience in Log Shipping and Database Mirroring.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Experience 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 teh two environments.
• Experience in designing and optimizing teh various T-SQL database objects like tables, views, stored procedures, user defined functions, cursors, indexes and triggers using Management Studio and SQL Profiler.
• Experience wif SQL Server 2005 and worked Experiencely on BI Tools (Integration services (SSIS) and Reporting services (SSRS) and Analysis services (SSAS).
• Experience in designing and handling SQL Reports, Sub Reports and Drill down Reports. Proficient in designing report layout, sorting teh data, defining subtotals for teh reports using SSRS 2008/2005.
• Experience in Microsoft Reporting Service (SSRS) wif Report authoring, Report Management, Report formatting, Report distribution, Report delivery and Report security.
• Experience in report, writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report
• Experienced in using ETL tools in (SSIS) MS SQL 2005 and DTS in MS SQL 200
• 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, COBOL, JCL, C, C++

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

Other: Red Gate, Business Object XI, Cognos, Crystal Reports, SQL, ETL, T-SQL, Transact-SQL, DTS, SSIS, Reflection, MS-Excel, PowerBuilder, IDX, SAS, SSIS, SSRS, SSAS

Operating Systems: Windows XP/NT/ 2000/1995/3.1

PROFESSIONAL EXPERIENCE:

Confidential, Oak Brook, IL

SQL Database Developer

Responsibilities:

• Research, troubleshoot, debug and support Healdation products using SQL Server 2008 and SSIS.
• Develop and maintain Healdation software products based upon technical specifications and / or verbal direction from supervisors.
• Document changes, perform basic unit testing tasks, maintain versioning requirements and uphold all company development standards as related to teh 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 teh supervisor in monitoring any assigned application systems or products.
• Maintain accurate documentation wif regards to work performed, issues or problems defined and meetings attended.
• Maintain ownership and accountability to teh issue management queue.
• Maintain a client - based communication style in both oral and written communications.

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 teh performance of SQL Server databases
• Designed and created different ETL packages using SSIS, Created SSIS Packages to import and export data from Excel, Xml and Text files.
• Created SSIS Packages to extract data from 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 etc to generate underlying data for teh reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse using VB.Net
• Developed teh Stored Procedures, Triggers, Functions, T-SQL scripts
• Creation and maintenance of interface tools dat upload data to teh AS400 or SQL Servers, such as Mass Add, Mass Maintenance, Related Item Load, and STEP Sku Create Spreadsheet,
• Produce adhoc queries and recurring reports from STEP or SQL servers for business users
• Interface wif Product Management and/or Item Content Group on STEP reporting, queries and exceptions
• Create and maintain data extracts and data imports to various systems including teh STEP system
• Assume overall responsibility for automated jobs

Confidential

Senior Business Intelligence/Reporting Consultant

Responsibilities:

• Meet wif 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 wif teh Off-Shore team and QA of teh Reports before reports go back to teh business use

Confidential, Schaumburg, IL

SQL Database Developer

Responsibilities:

• 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 teh database server (SQL Server 2008) in production, development and testing environments
• Developed teh Stored Procedures, Triggers, Functions, and T-SQL scripts
• Writing new stored procedures and modifying existing ones and tune them such as they perform well.

Confidential, Rosemont, IL

SQL Database Administrator

Responsibilities:

• Installation of SQL Server 2005 production, development and testing environments
• Designed and developed new models databases
• Migrated and Upgraded SQL Server 2000 database to SQL Server 2005 environment using upgrade advisor and tested their applications.
• Administering teh SQL Servers Security by creating users logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, granting privileges to users and Roles.
• Setting up database backup and recovery procedures for SQL Servers
• Setup log shipping for production databases to DR Servers.
• Configured and maintained Transactional Replication environments.
• Writing new stored procedures and modifying existing ones and tune them such as they perform well.

Confidential, Chicago, IL

SQL Database Administrator

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Rebuilding teh indexes at regular intervals for better performance
• Designed and implemented comprexhensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• 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 teh performance of SQL Server databases
• Provide database component solutions dat utilize stored procedures, SQL, SSIS and views to contribute to teh technical code and design documentation.
• Demonstrate teh ability to design data aggregation and manipulation solutions dat will translate from a database/transaction store to teh corresponding application user-interface.
• Designed, ddeveloped deployed and maintain SSIS Packages including upgrading DTS to SSIS.

Confidential, Chicago, IL

SQL Database Developer/Cognos Report Writer

Responsibilities:

• Provide day-to-day support for all COGNOS users.
• Coordinate technical maintenance of COGNOS applications including necessary upgrades for reporting applications wif IT.
• Created parameterized Cognos Reports and SQL Server Report Service Reports
• Customizing existing reports for presentations using Cross-Tab reports, sub-reports, Running Totals, Sorting,Visual Basic syntax to create formulas and adjusting reports wif program logic
• Strong experience wif designed, developed formulas using Visual Basic for Application based spreadsheet applications in MS-Excel

Confidential, Mt. Prospect, IL

SQL Server Administrator/Developer

Responsibilities:

• Designed, supported and maintained multiple relational database environments
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding teh indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers wif sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Designed and created different ETL packages using SSIS, Created SSIS Packages to import and export data from Excel, Xml and Text files.
• Develop and design reports by using SQL Server Report Server (SSRS)
• Administering teh SQL Servers Security by creating users logins wif appropriate roles, dropping and locking teh logins, monitoring teh user accounts, granting privileges to users and Roles.
• Configured and maintained Snapshot Replication, Transactional Replication and Merge Replication environments.
• Writing new stored procedures and modifying existing ones and tune them such as they perform well.
• Implemented auditing using triggers and proper use of views to prevent unauthorized access to sensitive data.
• Periodic checking of all databases wif DBCC commands for maintaining data consistency and integrity.