SUMMARY

• Over 7 Years of extensive IT experience in design, development and analysis of Microsoft SQL Server /2008/2008 R2 and Successfully worked as a SQL Server Business Intelligence tools (BIDS) developer with SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) implementing technical skills along with interpersonal skills as per business needs.
• Experienced in extracting, transforming and loading the data using SSIS in SQL Server 2005/2008/R2 and 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.
• Migrated data using SSIS, DTS wizard (Data Transformation Services) tool through data flow tasks, look up transformations and script tasks.
• Developed database objects such as tables, views, stored procedures, triggers, row - level audit tables, indexes, user-defined data-types, functions and 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 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.
• Proficient in OLTP, OLAP and data warehouse design concepts, experienced in relational, multi-dimensional (Star) and snowflake, logical and physical data modeling and data mapping.
• Experienced in MS Analysis Services (SSAS) programming for data warehouses (Schemas), proficiency in data warehousing techniques for data cleaning, slowly changing dimension phenomenon.
• Proficient in processing OLAP cube, creating KPIs, dimension usage, calculated members, perspectives and hierarchies.
• Performance tuning in cube by creating storage modes (MOLAP, ROLAP and HOLAP), aggregations, usage based optimization, besides providing security by providing perspectives
• 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.
• 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).
• Strong Experience on framework manager modeling (Namespaces, Joins, Loops, and Dimensions) and creating packages and deploying onto server.
• Developed prompt pages and cascaded input prompts to display only the selected entries in report studio
• Worked on administration tasks such as backup & recovery, upgrades, creating Databases/file groups/files/transactions logs.
• Performance tuning of SQL Queries using execution plan, index scan, index seek and bookmark lookup.
• Experience in database architecture, design, coding, implementation and production support.
• Knowledge of SDLC Life Cycle (Initiation, Analysis, System Design, Construction, Acceptance, Implementation) and Maintaining triple constraint project scope, on time, on budget for information technology projects
• Posses excellent management skills of outstanding decision making with excellent verbal and written communication skills, Supervised in preparing and assisting formal walkthroughs and presentations of system designs for business analysts, stakeholders and clients.

TECHNICAL SKILLS

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

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), Import Export Data, Bulk Copy Program (BCP)

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

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

Database 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)

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, California

SQL Server/ BI Developer

Responsibilities:

• Worked 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 Reportsand 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, Pennsylvania

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.
• Created SSIS Packages to migrate slowly changing dimensions.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, 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, SSAS, Excel, Oracle10g.

Confidential, Red woods, California

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.
• Expert in creating parameterized reports, Drill down, Drill through, Sub reports, Linked reports, Snapshot, Cached and Adhocreports 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.

Confidential

SQL 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

Responsibility:

• 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.