SUMMARY

• Over 7+ years of IT Professional experience in Development, Client Analysis, Database Design, and Presentation using SQL Server 2008R 2/2008/2005/2000.
• Microsoft Professional Certified SQL Server/Bi Developer.
• Experience of the entire Software Development Life Cycle (SDLC), IT systems and processes, methodologies and their direct implementation to projects.
• Experienced in routine Database Backup/Recovery procedures & 3rd party tools.
• Knowledge and experience in dealing with Constraints, Querying, Joins, Keys, Indexes.
• Expert in writing T - SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stacks of BI solutions - SSRS and SSIS with MS SQL 2008R 2/2008/2005/2000 .
• Created User Defined functions to simplify code with in stored procedures as well as utilized data sources in complex ETL packages.
• Used DML triggers as well as DDL triggers as constraints, Complex queries, Stored Procedures, Views and Functions.
• Experience in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Expertise in building and migration of various DTS packages.
• Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008.
• Scheduled reports for Daily, Weekly, Monthly reports on sales and marketing information for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Proficient in design ofETLandSSISPackagesfor integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text, XML, Access, Oracle, DB2, SQL) by using multipletransformationsprovided bySSISsuch asAggregate,Data Conversion,Conditional Split,Bulk Insert, Fuzzy Grouping, Fuzzy Lookup andMerge).
• Created complex SSIS packages for data manipulation, data validation purpose using VB Scripts and C#.
• Deployed SSIS packages and scheduled the packages using SQL Server Agent.
• Created Sub-reports, Linked reports, Ad-hoc reports, Map reports (by territory, by country, by state), Charts, Gauges, Report Builder 3.0 in SQL Server 2008/2008 R2.
• Configured, administered Report Manager and created item level securities, group permissions in SQL Server Reporting services.
• Proficient in designing OLAP (Online Analytical Processing), OLTP (Online Transaction Processing) systems.
• Experience in creating Packages, scheduling Jobs and sending Alerts using DB Mail.
• Created Documentation, ER Diagrams using MS Visio and Erwin for ER modeling.
• Expertise in Database Consistency Checks using DBCC Utilities, DMVs and DMFs.
• Excellent problem solving skills for delivering useful and compact solutions. Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in development environment.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• A well-organized, goal-oriented, highly motivated effective team member.

TECHNICAL SKILLS

Operating Systems: Windows Server 2003, Windows 2000 Server, Windows 98/XP/Vista/7

Database Tools: Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

Internet Tools: HTML, IIS, LAN, WAN

GUI Tools: Visual Studio 2005/2008

Languages: C, C++, C#, T-SQL

Version Control: Visual Source Safe, Team Foundation Server

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , Oracle 11g

OLAP Tools: SQL Server Reporting Server 2008/2005, SSIS (as ETL), Crystal Reports

Third Party Tools: Red gate, MS Visio, Erwin, TOAD, IFS

PROFESSIONAL EXPERIENCE

Confidential, Shelbyville, TN

SQL Server Developer

Responsibilities:

• Designed and developed a full-scale reporting solution for the client using MS SQL Server 2012, Oracle 11g, SSRS and Crystal Reports.
• Designed, implemented and maintained a reporting suite of over 50+ reports while also customizing many reports to meet individual client needs.
• Created drill down, drill through, sub and linked reports using SSRS as well as managed the subscription of the reports.
• Generated Cascading parameterized reports in SSRS allowing users the ability to make selections before executing reports.
• Developed SSRS reports using SSAS data source.
• Assembled and converted user requirements from multiple clients into standard reporting solution and customized reports to client specific requests.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring during execution.
• Created Standard, Crosstab and custom reports using Crystal Reports.
• Used Toad Data Modeler for data mapping efforts and establishing relationships between tables.
• Designed, developed and enhanced Oracle queries, functions and Stored Procedures to encapsulate frequently used business logic and converted them to SSRS Reports.
• Designed complex TSQL queries using data warehouse and created multiple complex reports for forecasting future demand and raw material procurement.
• Experience in creating Ad hoc reports with complex formulas and to query the database for Business Intelligence.
• Involved in building and maintaining SSIS Packages to import and export the data from various data sources and deploying the SSIS packages to various environments using BIDS.
• Created Jobs using SQL Server Agent to execute SSIS packages as per the required schedule.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task, Sequence container and conditional split, Merge and Lookup while loading the data into Destination.
• Used IFS ERP (Industrial and Financial Systems) to create quick reports.

Environment: s: SQL Server 2012/2008R2, SSIS, SSRS, Oracle 11g, Crystal Reports

Confidential, Okemos, MI

SQL Server Developer

Responsibilities:

• Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE’s, Table Variables and Stored Procedures using SQL Server 2012 and SQL Server 2008 R2.
• DeployedSSISpackages and Reports to Production Servers.
• Migrated data using ETL Tool inSSIS.
• Working experience in BI Solutions (ETL & Reporting) using SSIS and T-SQL Programming using DDL, DML commands for various business applications.
• Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and fine tune the same to improve performance.
• Well-versed in usage of SSIS Control Flow items(for Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping), Connections Managers, Log Providers.
• Experienced in creating configuration files to deploy the SSIS packages across all environments.
• Skilled in error and event handling: precedence Constraints, Break Points, Check points and Logging.
• Defined report layouts including report parameters and wrote queries for drill down reports, Linked reports, Ad-hoc reports using SSRS
• Generated on-demand and scheduled reports using T-SQL stored procedures, functions, SQL Agent Jobs for business analysis or management decision using SQL Server Reporting Services (SSRS)
• Used TFS to check in and check out SSRS reports.
• Worked with QA team to determine if applications fit specification and technical requirements. Tests and evaluates systems, subsystems, and components

Environment: s: SQL Server 2012/2008R2, SSIS, SSRS, Team Foundation Server (TFS)

Confidential, Milwaukee, WI

SQL Server Developer

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Letter format, Form format, Drill-through, Drill-down, Cross -Tab Reports and Sub-Report using SSRS.
• Assisted business users and end users to schedule subscriptions on report manager.
• Created and deployed several packages in SSIS.
• Extracted data from Heterogeneous sources such as DBF, flat files, Excel file to load to SQL Server tables.
• Used SSIS to create ETL packages to validate, extract, transform and load data into database tables.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Configured DB Mail for sending automatic emails when SSIS packages fails or succeeds.
• Created stored procedures, user-defined functions and correlated sub queries to generate reports.
• Extensive work on tuning the long-running Stored Procedures as required.
• Created Databases Tables, Clustered/Non-Clustered Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Modify SQL queries to upgrade SQL Server performance using SQL Server 2008.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Optimizing Stored Procedures and long running SQL queries using indexing strategies and query optimization techniques.
• Created SQL Agent jobs for maintenance tasks like Rebuilding/Reorganizing the indexes and updating the Statistics.
• Used TFS to maintain the versions of code.
• Created Documentation of daily activities and reporting services for further references.

Environment: s: SQL Server 2008R2, SSIS, SSRS, Team Foundation Server (TFS)

Confidential, Fort Worth, TX

SQL Server Developer

Responsibilities:

• Created stored procedure for Dash Board & for Portal. Implemented PII sensitive data masking project. Designed table structure for daily aggregated data for reporting & dashboard requirement.
• Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Manipulation languages (DML/DDL) and maintaining the load process for Daily Loan detail and summary purposes.
• Constantly involved in creation and maintenance of index using Database Tuning Advisor, Query optimizer, and selected the best indexing plan to be deployed.
• Thorough analysis & testing of database objects and T-SQL statements before deployment to the production server. Created couple of specific investor’s reports using SQL Server 2008 R2, SSRS and Report builder 3.0.
• Created databases and schema objects including tables, indexes and applied constraints, created objects to connect various applications to the database and worked with the front end developer in supplying the right data with specific parameter’s for interface. Performed optimization of stored procedures, which has resulted up to 45% increase in performance.
• Enhanced old SSIS packages by making it dynamic. Used SSIS to transfer data between servers, load data into database, send files to SFTP location of other client side locations, and tuned the package for better performance. Performed performance tuning by studying execution plan, analyzing indexes and using SQL Profiler.
• On call 24/7 support to databases on weekly rotation.

Environment: Windows 2008, SQL Server 2008R2, TSQL, SSIS, SSRS, Red Gate, MS. Visio, Report Builder 3.0.

Confidential, Fort Worth, Texas

SQL Server Developer

Responsibilities:

• Wrote complex T-SQL queries/Views to match data which came from different sources. Processed high volume data everyday using SSIS and efficient Stored Procedure.
• Implemented complex business logics to fulfill the reporting requirements of the business using complex T-SQL stored procedures and Views.
• Scheduled a job to run the whole process of getting the zipped files from the FTP site and then unzipping, staging, transforming and finally inserting into the reporting DW tables.
• Designed SQL SSIS Packages to extract data from various data sources such as FTP site, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations, scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. Used Joins, Sub-queries for complex business queries involving multiple tables from different databases.
• Design and develop SSIS packages, stored procedures, configuration files, tables, views, and functions; Implemented best practices to maintain optimal performance.
• Reduced the T-SQL overhead successfully by avoiding unnecessary joins, wildcard syntax & parsing using char index, pad index within the select statement to optimize the query performance.
• Enhanced performance of databases using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure completeness of batch processes, scripts and processes.
• Supported Application Development team with any database issues, updates or new releases. and deadlock issues, best practices in structuring SQL Queries, debugging unexpected SQL results, etc
• Used Ad-Hoc queries to generate Reports using SSRS to meet ad-hoc requests from different client’s needs. Created effective views for Micro-Strategy to generate reports.

Environment: MS SQL Server 2008/R2, SSIS, T-SQL, SSRS, C# within Script Task, Windows 2003 Server, ERWIN.

Confidential, Bethlehem, PA

SQL Server Developer

Responsibilities:

• Creating and managing schema objects such as Tables, Views, Indexes, Procedures, and Triggers and maintained Referential Integrity.
• Interacted with system users to identify data required for processing. Involved in logical & physical design, development and testing of the system. Developed complex T-SQL code for the application.
• Expertise in SQL Server Reporting Services (SSRS), Created Tabular, Matrix, Drill Down, Bar Chart, Pie Chart reports to analyze critical data in SSRS.
• Extensively used SSIS transformations such as lookup, merge, derived column, data conversion and aggregate.
• Handled large table loads and reporting from different source using SSIS and SQL Adhoc queries
• Modified the format and structures of the reports according to the end-user requirements.
• Created Ad-Hoc reports using Report Builder.
• Developed SSIS packages to extract and transform data from Flat Files, Excel Files, OLEDB and Access.
• Designed, developed and scheduled various SSIS package for data migration, bulk load data using BCP, import/export wizard.
• Involved in project planning, scheduling for database module with project managers.
• Worked with various business groups while developing their Applications, assisting in database design, phasing from Development to QA and to Production environment.

Environment: Windows 2003, SQL Server 2005, T-SQL, DTS, SSIS, Profiler, Erwin.

Confidential, New York City, NY

SQL Server Developer

Responsibilities:

• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2005. Created Parameterized reports and Linked reports and thorough knowledge of report servicing architecture using SSRS.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, <>, statement & using the TOP operator to limit the Select statement in certain queries.
• Designed, reviewed, and created primary objects such as Views, Indexes based on logical design models, user requirements and physical constraints.
• Worked extensively on creating SSRS ad-hoc reports (Model based) using Business Intelligence Development Tools.
• Extensive experience in designing, creating and deploying SSIS packages for transferring data from Flat files, Excels spreadsheets and heterogeneous data to and from SQL Server.
• Regular monitoring of Time/Data driven Subscription based SSRS reports (Daily, Weekly, Monthly) and SSIS external file transfers.
• Created parameterized reports for the users and clients, with drill-down, drill-through features.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Created Entity Relationship (ER) diagrams based on requirements.
• Generated Weekly and Monthly Trigger based Reports regarding assigned projects to designated Managers and Clients.
• Managed business issues on connectivity, permissions, data validation and worked closely with business analysts for report generation.
• On call 24/7 support to databases as needed.

Environment: Windows Server 2003, SQL Server 2005, SSIS, SSRS, SSMS, Erwin.

Confidential, Pleasanton, CA

SQL Server Developer

Responsibilities:

• Installation and configuration of MS SQL Server 2005 on Production and Test Servers.
• Developed SQL Queries and Stored Procedures to fetch data from different tables in remote databases using Joins.
• Used DBCC commands to check the physical and logical consistency of the Databases.
• Interacted with Business Users for Reporting Requirements.
• Experience in working with SSRS 2005 for generating reports like Drill Downs and Drill Through.
• Proper use of Indexes to enhance performance of individual queries for fast & efficient reporting.
• Created many SSIS packages using Import/Export Wizard and Control Flow and Data Flow Tasks with ETL Tool.
• Extensively involved in enterprise reporting in generating reports using Linked Reports, Sub Reports, Adhoc Reports, and Drill down reports, Drill through reports and filters, charts in SQL server Reporting Services.
• Involved in Reporting Services Administration by creating roles, users and providing security to Reports.
• On call 24/7 support to databases on weekly rotation.

Environment: Windows Server 2003, MS SQL Server 2005, Business Intelligence Development Studio (SSRS & SSIS).