SUMMARY

• Over SEVEN years of experience in Information Technology field as a SQL Server Developer with strong expertise in SQL server development, designing Stored Procedures/T - SQL coding, SSIS/SSRS and OLTP.
• Extensive experience in MS SQL Server 2000/2005/2008 , Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin, MS Visio and ER/Studio.
• Experience with T-SQL (DDL and DML) in constructing tables, user defined functions, views, complex stored procedures, clustered and non-clustered indexes, relational database models, data dictionaries, data integrity and appropriate triggers to facilitate efficient data manipulation and consistent data storage.
• Efficient in writing complex T-SQL queries using Joins.
• Experience in creating SSIS packages and migrating DTS packages from SQL server 2000 to SQL server 2005/2008.
• Extensive ETL experience using DTS/SSIS for data extraction, transformation and loading from OLTP systems to ODS and OLAP systems.
• Experienced in implementing Slowly Changing Dimension wizard and Check Sum Transformation to load data into slowly changing dimensions in data warehouse.
• Experience in providing Logging, Error handling by using Event Handler and Custom Logging for SSIS Packages.
• Expert in scheduling jobs, SSIS Packages and sending Alerts using SQL Mail.
• Expert in generating Sub reports, Drill down and Drill through reports with drop down menu options, sorting the data, defining sub totals in SSRS 2008.
• Proficient in handling parameterized reports in SSRS 2008.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading parameters, matrix dynamic reports and other features of reporting services.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Good understanding of Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions using MS Analysis Services 2008/2005.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard, Database consistency check using DBCC utilities and Database Engine Tuning Advisor.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• MCSA, CCNA, CWNA.

TECHNICAL SKILLS

Databases: MS SQL server 7.0/ 2000/2005/2008 , Oracle, Teradata, MS Access.

Languages: Transact- SQL, SQL,HTML, XHTML, C#, VB script.

Operating Systems: Windows NT/98/2000/XP/Vista/2003, MS-DOS.

OLAP/Reporting Tools: SQL Server Analysis Service (SSAS), SQL Server Reporting service (SSRS), MDX, Crystal Reports 9/10/XI, Cognos.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Other Tools: Erwin, Microsoft Visual Source Safe, Microsoft Office, MS Visio.

Data Modeling Tools: Erwin tool, Microsoft Visio 2000/2003.

SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, BCP, SQL server profiler.

PROFESSIONAL EXPERIENCE

Confidential, San Antonio, TX

SQL Server Developer/SSIS/SSRS

Responsibilities:

• DesignedSSIS packages to extract data from different file sources like copy book (txt), MS Excel, transform and then load into SQL Database
• Created packages in SSIS with error handling and worked with different methods of logging in SSIS.
• Worked with T-SQL (DDL, DML) statements using dynamically generated SQL and developed complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive and delete after processing.
• Used various SSIS tasks such as Conditional Split, Derived Column, script task using visual basic which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Databases.
• Used various transformations in SSIS like Lookup, Fuzzy grouping, Row count transformations
• Schedule jobs for SSIS Packages using Autosys (r11).
• Involved in the NDM (Network Data Mover) processing using windows shall script.
• Involved in deploying SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report.
• Wrote complex SQL queries and stored procedure to create reports using SSRS 2005/2008
• Generated parameterized/Drilldown reports using SSRS 2005/2008
• Created Subscription/Data driven Subscriptions using Snapshots to improve the performance of Reporting Server 2005/2008.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
• Experienced in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Developed and maintained system documentation, diagrams and flowcharts.

Environment: MS SQL Server 2005/2008, Windows 2005/2008, SSIS, SSRS, SQL Server, Management Studio, SQL Server Business Intelligence Studio, VB.NET, SQL Profiler, COBOL, Autosys r11(Workload Control Center), NDM(Network Data Mover), Pac2000 v7.1, CVS(Control Version System

Confidential, New York

MS SQL Server

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirement and provided documentation. Gathered data and documenting it for further reference. Designed Entity Relationship Diagram using Erwin.
• Experienced with creating logical and physical database design for development projects.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages and stored procedures. Modified the existing SSIS packages to meet the changes specified by the users. Coordinated with SQL DBA in Backup and Recovery.
• Created Alerts for successful and unsuccessful completion of scheduled jobs. Created simple data entry applications using VB.Net and SQL 2008 Server. Created DTS packages to transfer data from SQL Server 2005 and scheduled jobs for batch processing.
• Upgraded server from MS SQL Server 2005 to MS SQL Server 2008.
• Configured and maintained Log shipping architecture to provide backup server solution for 4 environments.
• Implemented transactional replication for data refresh.
• Extensively used SQL PROFILER and QUERY TUNING Wizard to troubleshoot problems and queries.
• Created the DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers.
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional expression (MDX) to access them.
• Created and Configured OLAP Cubes (Star Schema and Snow flex Schema) using SQL Server 2008 Analysis Services (SSAS).
• Performance tuning, MDX and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating KPI, Actions and Perspective using SQL Server Analysis Services 2008(SSAS).
• Involved in Cube Partitioning, Refresh strategy and planning and Dimensional data modeling in Analysis Services (SSAS).
• Designed, Developed and Deployed reports in MS SQL Server2008 environment using SSRS.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports: Designed and created Report templates, bar graphs and pie charts based on the financial data
• Wrote queries to generate reports for analysis of data; Used table control, matrix control to create cross tab reports; handled sub reports and defined query for generating drill down reports in SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.

Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services, MS SQL Server Integration Services, MS SQL Server Analysis Services, T-SQL, Visual Studio 2005/2008, Erwin v7.2., VB.Net 2005,Oracle 10g,MS Access 2007.

Confidential, DC

SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• Installation of SQL Server on Development and Production Servers, setting up databases, users, roles and permissions.
• Responsible for all technical SQL Server database operations, Administration, ongoing development for various in-house databases.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the data loads and transformations using SSIS.
• Involved in migration from Oracle to SQL Server 2005 using SSMS and SSIS.
• Developed Cubes using SQL Analysis Services (SSAS).
• Deployment of SSAS Cubes to the production server.
• Generation of reports from the cubes by connecting to Analysis server from SSRS.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
• Used SQL Profiler for troubleshooting, Monitoring, Optimizing SQL Server and T-SQL statements from developers and testers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Implemented automated backup and database maintenance / cleanup jobs.
• Managing Logins, Users, Roles and User permissions.
• Running Trace from the Profiler to trouble shoot database and running DBCC consistency checks for other database maintenance aspects.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created and scheduled jobs for various tasks and also was responsible for maintaining jobs.

Environment: Rational Rose 4.0, UML 2.0, SQL Server 2005 Business Intelligence Development Studio (SQL Server Integration Services SSIS, SQL Server Analysis Services SSAS, SQL Server Reporting Services SSRS and SQL Server Management Studio SSMS ), MS IIS, MS Office XP, MS Windows XP.

Confidential, Schaumburg, IL

SQL Server BI Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specifications.
• Designed and Developed Database Objects like Tables, Stored Procedures, Triggers, Rules, Defaults, user defined data types and functions for this project.
• Maintained databases, performed software installations and monitored Database Performance.
• Managing Logins, Users, Roles and User permissions.
• Regular responsibilities for updating staging and dimensional databases as well as rebuilding the dimensions and cubes on Analysis Services (SSAS).
• Created Views for specific columns on a table to maintain privacy of a customer data.
• Created Indexes to get the high level performance.
• Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS.
• Designed SSIS packages for loading data from ODS to Data mart.
• Designed SSIS packages for synchronizing the data between two different servers.
• Maintained databases, performed software installations and upgrades, monitored Database Performance.
• Involved in reverse and forward loading of the schema of a database using Erwin.
• Responsible for gathering Business Requirements and System Specification from users.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Created various Tabular and Matrix Reports using SSRS.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report.

Confidential

SQL Developer

Responsibilities:

• Actively involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Thorough understanding of physical database design for constraints and data types for figuring out the sequence for modification (insert, update, delete) of data in various tables.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implemented batch processing using Jobs and DTS.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Rules, Indexes, and Views.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Scheduled Jobs using SQL Server Agent.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, Tables, indexes and constraints on existing databases.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Environment: SQL Server 2000, Microsoft Visio, Replication, Windows 2000/XP, IIS 5.0, ASP.

Confidential

Junior SQL Developer

Responsibilities:

• Gathered functional requirements and written the technical specifications.
• Designed logical / physical data models and defined primary key, foreign key using Erwin tool.
• Wrote T-SQL statements using DML and DDL for retrieval of the data.
• Created complex stored procedures, triggers and cursors in SQL Server.
• Developed source to target specificatios.
• Developed stored procedures, functions, views and triggers.
• Developed stored procedures to transform the data from enterprise data warehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Performance tuning to optimize SQL queries using query analyzer.
• Created indexes, constraints and rules on database objects.

Environment: MS SQL Server 2000, MS Access, DTS, Erwin 4.1, SQL Query Analyze, VB, Crystal Report.

Confidential

SQL Server developer

Responsibilities:

• Involved in normalization and de-normalization of database.
• Designed DDL, DML for SQL Server 2000.
• Created rules, defaults, tables, views, clustered and non-clustered index, user defined data types and functions.
• Designed database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Wrote T-SQL statements for retrieval of data.
• Involved in performance tuning of T-SQL.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Perform daily database backup and restoration and monitor the performance of database server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Developed complex stored procedures to create various reports.

Environment: MS SQL Server 2000, T-SQL, DTS, SQL Server Enterprise Manager, SQL Server Query Analyzer, SQL Profiler.