SUMMARY:

• Over 6 years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS,SSAS and Data-warehousing.
• Experience in logical, physical, and dimensional data modeling, data mapping, and data normalization, well versed in ERWIN.
• Excellent Knowledge in creating databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User Defined data types, Cursors, Triggers and Indexes using T-SQL.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Experience in creating and managing fragmentation of Indexes to achieve better query performance.
• Experience in Performance Tuning and Query Optimization.
• Good understanding of (SDLC) software development life cycle process methodologies and principles.
• Good knowledge of Scrum process methodologies and principles .
• Strong technical knowledge in MS SQL Server development including DTS, Microsoft Integration Services Performance tuning, Reporting, Microsoft Analysis Services, Designing logical/physical databases and Troubleshooting.
• Good Knowledge about Extracting, Transforming and Loading (ETL) data using DTS Import/Export, DTS Packages and SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS/SSIS Packages and Backup/Restore of a database.
• Developing reports on SSRS on SQL Server (2000/2005/2008 ).
• Experience with Adhoc reporting, Parameterized , Custom Reporting using SSRS for daily reports.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill Through, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Sound Experience and understanding of SSAS, OLAP cube and Architecture.
• Involved in SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions.
• Expert in defining and deploying Cubes using SQL Server Analysis Services (SSAS).
• Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users .
• Excellent communication skills, analytical skills, understand business requirements in various domains.

TECHNICAL SKILLS:

Databases: SQL Server 2012,2008/2008 R2, SQL Server 2005, Access, Oracle 8i/9i/10g, MySQL, Data warehouse.

Database Tools: SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, ODBC, Business Intelligence Development Studio(BIDS), SQL CMD.

Languages: T-SQL, C, C++, PL/SQL, C# 4.0, UML, XML, MS SharePoint

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5, OLAP

Change Management Tool: Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems: Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0 Windows 7/vista/XP/98/95, MS DOS, Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Senior Sql Server Developer

Responsibilities:

• Developed stored procedures and triggers to facilitate consistent data entry into the database
• Wrote stored procedures to generate different market claims for different types of accounts.
• Imported the various files provide by the clients into the relational database systems.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Developed various Reports according to the client requirement.
• Designed C# code to implement in the packages.
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008 R2.
• Design and tested (Unit, Integration and Regression) packages to extract, transform and load data using Server Integration Services (SSIS).
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading.
• Developed SSIS 2008 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Created some reports (Drill down and drill through) for reporting data process. Automated and scheduled the reports.

Environment: SQL Server 2012/2008 R2 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Windows Server 2005, Oracle 9i, Control-M, UNIX.

Confidential, Bakersfield, CA

Sql Server Developer (SSIS/ SSRS)

Responsibilities:

• Worked with Business Analysts and Users to understand the requirements.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Used Temporary tables, table variables in Stored procedures to simply complex queries
• Optimized queries by analyzing different query options, and indexing strategies.
• Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers .
• Created SSIS packages to extract data to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008 R2.
• Design and tested (Unit, Integration and Regression) packages to extract, transform and load data using Server Integration Services (SSIS).
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in Incremental data loading.
• Developed SSIS 2008 Packages to migrate data from Oracle, Access, flat files and Excel into SQL server 2008 for further Data Analysis and Reporting by using multiple transformations
• Automated the SSIS Packages using the SQL Server Agent Jobs.
• Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Created Crystal Reports for different teams and groups in the organization to fulfill their business needs.
• Schedule the reports using Info View to run at specific times in a day/week as desired by the Business Users
• Created tabular, matrix, chart, drilldown reports, and parameterized, cascaded reports according to business requirement.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports

Environment: SQL Server 2008 R2 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Windows Server 2005, Oracle 9i

Confidential, Conshohocken, PA

SQL/ BI DEVELOPER

Responsibilities:

• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Have deployed packages on different servers by configuring it.
• Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Create and edit alerts on Reports, as per User request
• Modify the existing reports by adding new logic and deleting existing logic as the line of Business changes periodically
• Migrate reports from Dev to Production
• Provide on call support after reports are deployed to production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS)
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, database integrity verification, indexing and shrinking of databases and regular monitoring.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD, and SMO.

Environment: SQL Server 2008 Enterprise Edition, SQL, Enterprise manager, Crystal Reports, UML, VB.NET, MS PowerPoint, MS Project, Oracle.