SUMMARY

• Around 8+ years of experience in Database Design, Development and maintenance of database applications on SQL Server 2012/2008 R2/2008/2005 in OLTP/OLAP/BI environment
• Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Experience in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance
• Excellent experience in monitoring SQL Server Performance tuning in SQL Server 2000/ using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor
• Excellent hands - on experience developing components using SQL and PL/SQL
• Extensive experience in creating stored procedures, views, triggers including data pivots
• Expert in developing DB objects like Stored Procedures, Functions, Triggers and Packages
• Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS
• Experience in creating Jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages
• Extensive Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management
• Hands-On Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging
• Good experience in Creating, Populating and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snow Flake Schemas of Data Marts
• Experience in creating reports by using ProClarity Views and Dashboards strategy
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS)
• Excellent hands on experience scheduling and the deployment of the reports and uploading files to a report server catalog from the report manger
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services
• Experience in XML scripts and working with XML documents
• Experience in Dimensional Modeling
• Good hands on experience with Advanced Excel skills like VBA, macros, Pivot Tables etc
• Experience in writing VB scripts for user defined functions in SSRS
• Experience in Database Backup, Recovery and Disaster Recovery procedures
• Ability to work optimally under scheduled deadlines, and have passion for delivering high quality output
• Capable of handling responsibilities independently as well as a proactive team member
• Logical, Analytical and good inter personal skills, commitment to perform quality work and an excellent team player
• Flexible, enthusiastic and project-oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs

TECHNICAL SKILLS

Integration Tools: SQL Server Integration Services 2012/2008/2005 , BCP, SQL Loader, Import/Export Wizard

Reporting Tools: SQL Server Reporting Services 2012/2008/2005

Databases: SQL-Server 2012/2008/2005 , Oracle 12c/11g/10g

Languages: C#.Net, VB.NET, VBA, T-SQL, PL/SQL

SQL Server Tools: SQL Server Data Tools (SSDT), SQL Server Management Studio, Business Development Studio, Visual Studio 2005, 2008

Operating Systems: Windows 10, 2007, 2003

PROFESSIONAL EXPERIENCE

Senior SQL/MSBI Developer

Confidential, Houston TX

Responsibilities:

• Actively contributed in requirements gathering, analysis, design and coding phases
• Developed Stored Procedures, Functions and Packages for Financial team using SQL and PLSQL
• Developed Integration Services (SSIS) packages to perform ETL operations on the source data and load it into staging and destination data marts
• Creating SSIS Configuration files to handle database connection strings during run time
• Implemented Logging with SQL tables in SSIS to monitor package execution
• Used Event Handlers to handle bad data during data loads
• Built and used indexes to improve query performance
• Extensively involved in development of various SSRS reports including Drill-Through, Drill-Down, Linked reports, sub-reports etc. and charts
• Involved in loading data from flat files into Oracle using SQL Loader
• Developed scripts for creating new tables, views and triggers in Oracle
• Extensively made use of PLSQL advanced features like Records, Collections, Object Types
• Exported SSRS reports to Excel and PDF formats to be delivered to the users
• Coordinated with the offshore counterparts in fulfilling the client’s requirements and ensured timely deliverables to the client
• Worked on enhancing existing packages as per the project requirement
• Worked on existing report enhancement and developed few new reports along with integrating them to web solution
• Good working knowledge on the business flow, and existing reports and packages
• Created Job Schedules using Subscriptions for the exported reports to be delivered to the users
• Trained users on usage of Reporting Services
• Fixed issues on Ad-hoc client request, as this application is widely used
• Handled performance tuning of SPs
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, indexing and statistics updates
• Incorporated exception handling in PLSQL objects to capture errors and to aid in debug
• Performed unit testing on deliverables
• Experience on working in Agile/Scrum environments

Environment: SQL Server Data Tools (SSDT), Oracle 12c, SQL Server 2012, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio, C# .Net, Visual Basic, Advanced Excel

Senior SQL/SSIS Developer

Confidential, Dallas TX

Responsibilities:

• Analyzing the existing system and understanding the business requirements
• Creating the Data model and Schema for the new Warehouse
• Developed PLSQL objects like stored procedures and functions for validating and moving data from staging area to data mart
• Identifying the relationships in the existing schema
• Created mappings to extract data from SQL Server and to migrate and transform data using SQL Server Integration Services.
• Conducted data cleansing to remove redundant and inconsistent data and unwanted columns SSIS transformations.
• Worked on enhancing the existing packages as per the requirement
• Design and implement reusable components
• Create ETL best practices and Developers guide
• Used Oracle standard util packages like UTL FILE, DBMS SQL etc., while building data processing packages
• Made good use of Bulk Collections, Records, Objects types etc., for faster and efficient data processing
• Create reusable Sub graphs and functions to use in multiple mappings
• Involved in physical/logic data model reviews
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit/Integrations testing
• Extensively used excel features like Pivot Table, macro scripting etc., for data analysis and excel reporting
• Good experience incorporating exception handling and debugging errors
• Experience in supporting integration testing and regression testing
• Automate the Production jobs using SSIS job scheduler
• Monitoring SQL Server performance using Profiler to find deadlocks.

Environment: SQL Server Data Tools (SSDT), SQL Server 2012, SQL Server Integration Services, SQL Server Reporting Services, Oracle 11g, Visual Studio, Excel (Pivot Tables, Macros)

SeniorSQL/MSBI Developer

Confidential

Responsibilities:

• Key projects worked on - COMET - Fallout, NSOCC (National Service Order Completion Center), Rep Power Coach on Blackberry
• Interacted with the client directly for requirements and clarifications
• Responsible for Plan, design, and implement application database code objects
• Developed SQL scripts, indexes, and complex queries
• Performed quality assurance and testing of SQL server environment
• Performed normalization of database
• Identified business requirements and provided solution options
• Coordinated between project management and development teams
• Identified data issues and provided solution options for resolution
• Monitored entire application development, execution, and maintenance
• Was involved in the complete database migration from version

Environment: SQL Server Data Tools (SSDT), SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio

Senior SQL/SSRS Developer

Confidential

Responsibilities:

• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server and Flat files
• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS)
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production)
• Involved in the complete database migration from version
• Designed and developed SSRS reports in accordance with the requirements.
• Developed various types of reports such as complex drill down reports, drill through reports, parameterized reports, matrix reports and charts using SSRS
• Used VBA scripting and macro scripting during report building
• Scheduled jobs for the reports using subscriptions
• Developed xsdl files to format the SSRS reports while exporting to various formats.

Environment: SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio, C# .Net, Excel (VBA, Macro)

SQL Developer

Confidential

Responsibilities:

• Designed the database and developed all the required objects
• Created Stored Procedures to pull the required data
• Designed and created SSIS packages to implement the data flow and scheduled them using SQL Agent
• Worked with XML inputs as SQL objects

Environment: Oracle 9i, SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Visual Studio, C# .Net

MSBI Developer

Confidential

Responsibilities:

• Analyzing the Existing System and Understanding the business requirement
• Creating Data model and Schema for the new Warehouse
• Identifying the relationships in the existing schema
• Involved in designing SSIS packages to implement business work flows
• Populating the Data from different source systems into DW using SSIS
• Involved in preparing unit test cases and doing the unit testing
• Deploying the packages to Integration, Acceptance and production environments

Environment: SQL Server 2008R2, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Confidential Office SharePoint Server 2007 (MOSS), MS Excel 2007, VBA, Visual Studio

MSBI Developer

Confidential

Responsibilities:

• Understanding the requirement and the Business involved
• Designing and populating the Metadata database
• Developing Excel reports
• Developing SSRS reports
• Involved in preparing unit test cases and performing the unit testing

Environment: SQL Server 2008R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Confidential Office SharePoint Server 2007 (MOSS), MS Excel 2007, VBA, Visual Studio, Silverlight, ASP .Net

BI Developer

Confidential

Responsibilities:

• Gathering the functional requirements
• Dimensional modeling
• Developing database, cube
• Developing reports, scorecards and dashboards
• Publishing reports on SharePoint
• Coordination with the Client

Environment: SQL Server 2008R2, SQL Server Integration Services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services(SSAS), Confidential Office Performance Point Server 2007, Business Scorecard Manager 2005, ProClarity, Dundas Charts, MS Office Visio, Confidential Office SharePoint Server 2007 (MOSS), MS Excel 2007, VBA

BI Developer

Confidential

Responsibilities:

• Analyzing the Current System and Understanding the business requirement
• Loading data from different sources
• Developing SSIS packages for achieving the required functionality
• Developing reports in SSRS
• Knowledge transition documents preparation
• Giving KT sessions

Environment: SQL Server 2005, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Confidential Office SharePoint Server 2007 (MOSS), MS Excel 2007 and VBA