SUMMARY

• Over 7 years of extensive IT professional experience with expertise in Database development, Database modeling, Design and Technical Management using SQL Server 2000, 2005, 2008, 2008R2 and 2012 in various domains like Insurance, Finance, Health Care, and Banking as SQL Developer and MSBI Developer.
• Expertise in Microsoft Business Intelligence tools (BIDS) like SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and designing reports using SQL Server Reporting Services (SSRS).
• Hands on experience in Installation, Configuration, Performance Tuning, Optimization, Backup and Recovery in SQL Server 2000/2005/2008.
• Sound knowledge in all phases of SDLC (Software Development Life Cycle) involving Initiation, Requirement Analysis, Software Design, Development, Acceptance, Implementation, Testing and Maintaining triple constraint project scope, on time, on budget for information technology projects.
• Extensive experience with different phases of project (project initiation, project requirement and specification gathering, designing system, coding, testing, and debugging new and existing client - server based applications).
• Expertise in Relational and Dimensional Data Modeling, Data Mapping, RDBMS Concepts, Database Management Systems, Database Physical and Logical design, Data Warehouses. Experience in design and implementation of On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP).
• Expert in using Complex Stored Procedures, User Defined Functions (UDFs), Triggers, Common Table Expressions (CTEs), Table Variables, Row-level audit tables, user-defined data-types, Views, Indexes and T-SQL queries (DDL and DML).
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.
• Diagnosed performance tuning, query optimization, client/server connectivity, and running database consistency checks.
• Extensively worked on DDL/DML techniques, joins, sub queries, passing variables, looping, dynamic SQL, managing indexes and deadlocks (troubleshooting).
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Experienced in Extracting, Transforming and Loading the data using SSIS in SQL Server 2005/2008/R2 and DTS (Data Transformation Services) in SQL Server 2000.
• Expert in data migration from OLEDB/EXCEL/FLAT fileto SQL Server 2000/2005/2008/ R2 and other destinations using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks.
• Experience in creating packages using Active X Scripts, performance tuning in SSIS, error and event handling, precedence constraints, break points, transactions, check points and logging using SSIS.
• Proficient in data migration between homogeneous/heterogeneous systems and SQL Server using DTS import/export utility, integration service (SSIS), BULK INSERT and BCP.
• Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Experience in creating the MDX queries to access cubes and dimensions, also creating complex SSAS cubes with multiple fact measures groups, KPIs, dimension usage, calculated members, perspectives and hierarchies based on the OLAP reporting needs.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, usage based optimization, besides providing security by providing perspectives
• High expertise in creating reports using Crystal Reports and SSRS (Ad-Hoc, drill-down, drill-through, cross-tab, sub-reports, pivot, tabular and parameterized reports).
• Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services, Experience in XML scripts, Dimensional Modeling, working with XML Documents.
• Extensive experience in reporting tabular forms, matrix (cross tab report) form, conditional, list items, charts and sub reports.
• Deploy reports, secure access, and schedule execution of reports and deliver them to the Web using reporting manager, Share Point, email recipients, file shares, and more, on a scheduled basis.
• A well organized team member with good communication skills and actively participated in problem solving and trouble-shooting issues.

TECHNICAL SKILLS

Programming Languages: SQL, T-SQL, PL/SQL, C, C++, VB 6.0,Perl, CSS, HTML, XML, MHTML, JavaScript, ASP.Net

Databases: SQL Server 2008/2005/2000/7.0, Oracle 9i/8.x, DB2, MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Data Stage, Import Export Data, Bulk Copy Program (BCP), FACETS.

Version Control: Team Foundation Server (TFS), Visual Source Safe (VSS)

Operating Systems: Windows / 98/2000/2003/ XP/Vista, Unix.

IDE & BI Tools: SQL Query Analyzer, SWIFT Tool, ERwin, SQL Enterprise Manager, SQL Server Management Studio (SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio (BIDS), Power Pivot.

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling, 1.1 using Rational Rose.

Other Software: MS Office 2007/2003/2000, Adobe Professional, SharePoint

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

MS SQL Server BI Developer

Responsibilities:

• Great expertise in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications and developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server 2008 RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Wrote complex T-SQL batches with Common Table Expressions (CTE’s) for recursive operations.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Deployed the SSIS package on various servers using package configuration from test server to production servers. Performed Bulk data migration using DTS and SSIS from flat files.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance using SQL Server Profiler, Execution Plan and Performance Monitors.
• Experience in Report Builder in SSRS 2005 and 2008.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, Parameterized Reports and AD Hoc Reports using SQL Server 2005/2008 R2 Reports Services (SSRS).
• Report parameters included single valued parameters, multi-value parameters that also consist of different parameter types like hidden, internal, default (queried and non queried parameters) to minimize the report execution time and to limit the number of records required.
• Created Crystal reports in visual studio 8.0
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Designed models using Framework Manager and deployed packages to the Report Net Servers. Created pages in the reports to display depend on Prompt values.
• Delivering reports to Microsoft Share point, Strong Experience using Report Manger and report viewer.
• Handful of Experience in MS Access 2003.
• Experience in Performance Point Server 2007 and ProClarity.
• Designed complex SSRS reports, Excel templates and integrated automation methods as appropriate.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
• Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis.

Environment: Windows 2003 Server, MS SQL Server 2005/2008 R2, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker, MS Excel 2010, Crystal Reports, Business Objects.

Confidential, Camp Hill, Pennysylvania

MS SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008R2.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, complex joins, column conversions, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export data from Excel Spreadsheets, Text file, MS Access and CSV files.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, and send mail task) and Migrated data using SSIS, DTS wizard (Data Transformation Services) tool through Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Used Data Defractor tool to normalize semi-structured Spreadsheets, fed it into the SSIS pipeline in the form of normalized output of factual data and contextual metadata.
• Reduced the repetition of the particular group in the Excel sheet using the Vertical Sub-Pages and Horizontal Sub-Pages Layout features using Data Defractor Tool.
• Deployed the packages on staging and production.
• Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleaned and validated data from XML file into database using XML source.
• Set SQL Server configurations for SSIS packages and configured logging including windows event log and XML logging.
• Created ETL packages using Heterogeneous data sources (SQL Server, ORACLE, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS
• Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
• Used Event Handlers for Custom Logging using Complex Store Procedures for various events (On Warning, On Pre and Post Execution, On Task Failed etc.)
• Performed Performance Tuning by using unblocking Transformations and row transformations for better Performance of SSIS packages.
• Designed numerous Ad-Hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Stepped and Block reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Created Partition table for very large database for good performance.
• Created partition function, schema and file groups for fact tables.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS

Environment: MS SQL Server 2008/2005, TFS, Query Analyzer, Windows 2003, T-SQL, Server Integration Services (SSIS), SSRS, SSAS, Excel, Oracle10g, Crystal Reports, MS Visual SourceSafe, Ervin 4.0, Visual studio 2008, SharePoint(MOSS) 2007.

Confidential, Irving, TX

MS SQL Server BI Developer

Responsibilities:

• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Used various transformation components in the data flow task to implement business logic.
• Configured SSIS packages using Package configuration wizard to allow package run on different environments.
• Migrated data using ETL Tool in SSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Used SSIS for data population from different sources and create packages for data conversions and load data into flat flies or excel files.
• Conversion of DTS packages SQL Server 2000 into SSIS packages SQL Server 2005.
• Developed multiple reports using reporting services.
• Creating functions and developing procedures for implementing application functionality at the database side for performance improvement.
• Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Created ETL package for data conversion using various transformations tasks.
• Created various scheduled jobs to handle the data migration from SQL periodically.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created datasets for reports using T-SQL and stored procedures
• Responsible for Query optimization and Performance tuning.
• Used SQL Profiler for Monitoring memory, processor, Disk I/O, SQL Queries.
• Created logins, roles, and groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Worked on administration tasks such as data loading, batch jobs, configuring, data uploading, backup & recovery, Database mirroring, Log shipping, user and application table management, upgrades, creating database partitioning, databases/file groups, transaction logs.
• Experience in Data Analysis, Normalization, Data warehousing, Data Cleansing, Data Modeling, Data Mapping, Erwin 3.0 in OLTP & OLAP environments
• Experience in building star schema and snowflake schema depending on the business data requirement.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, and usage based optimization, besides providing security by providing perspectives.
• Created Database Maintenance plans for Full/Differential/Transactional backup Strategies and involved in database partitioning.
• Worked on developing the business requirements and use cases forFACETSbatch processes; automating the billing entity and commission process
• Involved in claim adjudication process of FACETS application
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached and Ad-hoc reports using SSRS.
• Created complex variables, multiple breaks, sorts in the reports.
• Created Tabular and Matrix reports using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.

Environment: SQL Server 2000/2005 Enterprise Edition, SSIS 2005, SSRS 2005,.NET Framework, C#, ASP.NET, ADO.NET, Erwin, XML, T-SQL, SQL Server 2000, SQL Server 2005, VisualStudio.NET IDE, Windows 2000/2003 Advance Server, ASP, XML, T-SQL, MS Excel, MS Access, Visual Studio 05, FACETS.

Confidential

MS SQL Server Developer

Responsibilities:

• Setting up new MS SQL Server instances and databases.
• Going through the clients' requirements and coming up with database design and application architecture. Plan capacity specification requirements for new database servers.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000.
• Capacity planning of MS SQL Servers. Implemented and maintained database security.
• Managing logins, roles, assigning rights and permissions. Created views to implement security.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.
• Troubleshoot and minimize production down issues.
• Have written several stored procedures and Triggers as per the client requirements.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Designed new job process, new database maintenance plans and DTS packages.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created scheduled maintenances and backup procedures to the database as a disaster recovery method.
• Data conversions and data loads from various databases and file structures.
• Monitor failed and long running MS SQL Server jobs.
• Monitor, tune, and analyze database performance and allocate server resources to achieve optimum database performance.

Environment: SQL Server 2000, Transact-SQL, Enterprise Manager, Query Analyzer, Oracle 8i, DTS Designer, SQL Profiler, Index Tuning Wizard and MS-ACCESS 2000.

Confidential

Database Developer, Application Developer

Responsibilities:

• Written various stored procedures for the purpose of application development.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Administrator tasks like managing users, roles, and profiles.
• Performed database backups (operating system, flat file backups & export/import).
• Used snapshot replication for creating multiple instances of a database for distributing the workload.
• Tuned SQL statements using indexes and stored procedures combined a few simple, unrelated database accesses to improve performance and done data volume estimation and planning.
• Designed the forms & created reports using form builder & report builder in Developer 2000.
• Developed standards and guidelines to maintain develop and administer the SQL Server database and handled corrupt databases and diagnosed and repaired them.
• Maintained the physical Databases by monitoring Performance, space utilization and physical integrity.

Environment: SQL Server 7.0/2000, Windows NT/2000, IIS Server, Query Analyzer, MS Exchange Server, .NET, Report builder, Access Reports-SQL, UML, DTS.