SUMMARY

• 6+ years of experience as MS - SQL Server Developer, involved in Design, Development and Support of MS SQL Server 7.0/ 2000/2005/2008 for both OLTP and OLAP Systems.
• Experienced with various SDLC methodologies such waterfall, RUP, Agile/scrum and other hybrid methodologies.
• Excellent working skills in MS SQL Server business intelligence tools SSIS, SSRS and SSAS.
• Configured report subscriptions both data driven and time driven.
• Extensive knowledge and experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors.
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities.
• Experience in integration of various data sources like SQL Server, Oracle, DB2 UDB and Flat Files.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source systems.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2005/2008.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues. Expert in generating drill down Reports in SSRS 2005/2008.
• Experience in providing Logging, Error handling using Event Handlers, Pre, and post for SSIS Packages. Deployed reports across Test, Dev and production environments.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Experiences in SQL Server Analysis Services OLAP Cubes, and Data Mining.
• Performed Data Mining activities on central repository for various application and dashboard functionalities. Actively involved in the analysis of Cubes and added the Key Performance Indicators (KPI) to the created cubes.
• Created Scorecards/Dashboard Pages in Performance Point Server (PPS).
• Involved in creating daily full backups, hourly transaction log backups and weekly maintenance plans. Creating and Managing logins, users, roles and assigning necessary permissions.

TECHNICAL SKILLS

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS)

Reporting Tools: SQL Server Reporting Services ( 2008/2005/2000 ), MS Access, MS Excel

Database: MS SQL Server 2008/2005/2000 , MS Access, Oracle 9i/8i

Programming: T-SQL, PL-SQL, C

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS, PERL

Operating Systems: Windows (95/98/2000), Windows 2003 Server, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash

PROFESSIONAL EXPERIENCE

Confidential, Orlando, Florida

SQL Server/SSIS developer

Responsibilities:

• Support all production operation activities, with focus on integration and development of new and existing products and services.
• Use multiple join statements to retrieve data from multiple tables.
• Extensively use Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources.
• Create and develop thestored proceduresto handle complex business rules, history data and audit analysis.
• Generate complex reports usingSQL Server Reporting Services (SSRS) 2008.
• Create and deploySSRS Report Models using BIDS in SQL Server 2005 and SQL Server 2008.
• Publish Reports and Report Models on toSharepoint2007Server.
• Develop Triggers to raise events on executing insert, delete and update stored procedures.
• Develop Cross-Tabbed and Sub-Reports in SSRS 2005/2008.
• Generate reports using the Reporting Services 2005/2008 Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services 2005/2008.
• Work under Agile workflow management. Be part of backlog grooming, sprint planning and all other agile ceremony.

Environment: Windows server 2000, MS SQL Server- 2008, SSIS, SSAS, SSRS, T-SQL, Tortoise SVN, Team Foundation Server, Oracle 11g, Attunity CDC, VersionOne.

Confidential, Tampa, Florida

SQL Server / SSIS and SSRS Developer

Responsibilities:

• Analyze Report design requirements and actively participate and interact with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrate reports from Cognos to SSRS.
• Create SQL Server Reports based on the requirements using SSRS 2008.
• Work on OLAP Data warehouse, Model, Design, and Implementation.
• Develop Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Create complex reports involving more number of groupings and multi-value parameters.
• Develop FAS 115 and 157 reports and some end user request reports on periodic basis.
• Create multiple reports with drop down menu option having complex groupings within the report.
• Generate matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Develop reports and deployed them onto SharePoint using SQL Server Reporting Services (SSRS).
• Troubleshoot performance issues and fine-tune queries and stored procedures.
• Create Complex SSRS Reports and validate SSIS packages.
• Create and schedule jobs for various tasks and maintain jobs.
• Work very closely with Business owners, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Erwin, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Round Rock, Texas

SQL Server Developer/ SSRS Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS packages.
• Created SQL Server Reports based on the requirements using SSRS 2008.
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Developed reports like Claim Statements, Fee Bills Transactions and some end user request reports on periodic basis.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Render the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Schedule the SSIS packages and Jobs.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: Windows server 2003, IIS 6.0, MS SQL Server-2008/2005 Enterprise Edition, SSIS, SSRS, T-SQL, DTS, SQL Profiler, Erwin VB.NET, OLAP, OLTP, Erwin, Performance Point Sever, Office-2007, MS Excel, C#.NET, ProClarity Analysis.

Confidential, Maumee, Ohio

MS SQL Server Developer

Responsibilities:

• Interact with SME’s and End Users for requirement gathering, process improvement, problem identification, project analysis & review meetings and progress reporting.
• Designed SSIS package for automatic data migration to transform Data from SQL Server 2000 to SQL server 2008.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server Analysis Services (SSAS)-2008/2005.
• Designing OLAP cubes, Data Modeling, Dashboard Reports, and scorecards according to the business requirement.
• Served as technical expert guiding choices to implement analytical and reporting solutions for complex financial scenarios.
• Created/Updated Stored Procedures, Triggers, Functions, Views, and Indexes with extensive use of T-SQL.
• Design and develop SSIS (ETL) packages for loading data from Oracle and Flat files (3GB) to SQL Server Database.
• Created packages in SSIS with error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies.
• Created clustered and non-clustered indexes on tables for new database to faster retrieval of data for the Reports.
• Responsible for processing CUBE Partitions and Dimensions.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports.
• Helped Quality Assurance Team to generate Test Plans and Test Executions.

Environment: Windows 2003 Server, SQL 2008/2005 Enterprise Edition, Import-Export (DTS), SSRS, SSAS, SSIS, OLAP, OLTP, T-SQL, ASP.NET2.0, C#.NET, ADO.NET, Microsoft Visual Studio.Net 2005, .NET Framework 2.0, EXCEL 2007.

Confidential, Santa Clara, CA

SSIS/SSRS Developer

Responsibilities:

• Analyzed all the Database Structure and prepared a reference guide to understand the existing system better.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Created SSIS packages to Oracle and other SQL Server instances and used configuration files and variables for production deployment.
• Involved in making mappings and transformations using DTS Transform Data Task, Data Driven Query Task.
• Scheduled SSIS Packages for loading Facts and Dimensions.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Created complex SSIS packages using proper control and data flow elements.
• Involved in updating slowly changing dimensions strategies.
• Designed and built OLAP cubes to meet reporting needs.
• Responsible for identifying and defining Data Source and Data Source views.
• Created cubes and defined the dimensions.
• Responsible for defining calculated members.
• Defined attribute properties in a Parent Child Dimensions.
• Used Joins to write queries that retrieve data from more than one table.
• Responsible for hiding and disabling attributes and attribute hierarchies.
• Developed reports that deliver data from cubes.
• Created and managed subscriptions for the reports.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Created stored procedures to calculate pension and annuity information, when called will give the details for an employee on the website.
• Defined specific read/process permissions for the users in SSAS instance.

Environment: Windows 2003/XP, SQL Server 2005 BI Suite, SSAS, SSIS, SSRS, ETL, OLAP, OLTP, ASP.NET, PROCLARITY, T-SQL, MS Visual Studio 2005.

Confidential, Boston, MA

SQL Server/BI Developer

Responsibilities:

• Database upgrade from SQL server 2000 to SQL Server 2005.
• Perform Back-ups, Restores, Scheduling, Maintenance
• Created SSIS packages to ETL data into production system and to produce/schedule management control reports.
• Converted DTS packages to SSIS packages.
• Developed SSIS packages to load data from application database and flat files into destination database.
• Used Derived Column transformation to perform various calculations.
• Implemented package configurations in SSIS packages that allow transferring packages from one environment to other.
• Deployed SSIS packages to production, schedule them to run on routine basis and monitor the error log for any errors.

Environment: SSIS, MS SQL Server 2005, DTS, SQL Server 2000, Windows, C-Sharp, Erwin Data Modeler