SUMMARY

• Over 9+ years of experience in teh field of Information Technology working as SQL Developer and Business Intelligence Analyst.
• Motivated team player with excellent analytical, communication, management, technical and written skills
• Experience in Data Warehousing and Business Intelligence applications design, Development and Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS)
• Expertise in all areas of SQL Server development including tables, user functions, views, indexes, stored procedures, functions, triggers, clustering, T - SQL relational database models and data integrity.
• Good understanding and designing of Star and Snow Flake Data Models Schema used in relational, dimensional and multidimensional data modeling.
• Worked extensively on Extraction, Transformation, Loading data from DB2, AS400, SQL Server, Access, Excel, Flat Files and XML using DTS and SSIS
• Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
• Expert in monitoring SQL Server Performance, troubleshooting using SQL Profiler, Index Tuning Wizard (DTA), Windows Performance Monitor and Maintenance plan.
• Experience with Performance Point Server.
• Experience working as Sharepoint Administrator
• Expertise in designing Database Models using MS Visio and ER-Win.
• Generated reports in various formats like Table and Matrix format using Reporting Services (SSRS).
• Experience in creating Linked Reports, Sub Reports and Filters in reports.
• Experience in creating ad-hoc reports by using Report Builder in SSRS.
• Knowledge and experience in designing, developing and deploying Reports and Dashboard.
• Experience in Dimensional Data Modeling and Cube development in SQL Server 2005 Analysis Services (SSAS).
• Designed and developed OLAP/Analysis services cubes, MDX scripts and OLAP cube performance tuning.
• Experience in Creating, Modifying Cubes, Measures, Dimensions Attribute relationships, Named Calculations and Hierarchies.
• Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008, MS Access, Sybase. ToolsSQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, SSIS, SSRS, BIDS, Database Engine Tuning Advisor WebASP, VB Script, JavaScript, XML OtherMicrosoft Office Suite (Word, Excel, PowerPoint and Outlook) Web ServersIIS 4.0/5.1, Personal Web Server NetworkingCDMA, MOBILE IP, DHCP, TCP/IP over

ADHOC NETWORKS: O/SWindows NT/2000/2003/XP, Windows 98/95/4.0, UNIX

Microsoft Technologies: .NET Framework, ASP .NET, VB, C#, WSS 3.0, MOSS 2007

Configuration Management: Visual Source Safe and VSTF

PROFESSIONAL EXPERIENCE

Confidential, NJ

SQL Server / BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data base using Erwin7.3 on business requirement and provided documentation.
• Involved in creating database scripts for database changes and also scripts for database objects migration to staging and production environments.
• Designed SSISPackages to extract data from various OLTP sources like Text Files, XML (Extensible Markup Language) Files, Excel and MS Access 2007 to data warehouse system (SQL Server).
• Used SQL Profiler for monitoring and troubleshooting performance issues in T-SQL code and stored procedures.
• Wrote T-SQL queries with teh help of Stored Procedures, Functions, Triggers, Cursors, Views and Indexes.
• Developed reports in MS SQL Server environment using SSRS 2005 in Business Intelligence Development Studio (BIDS).
• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using MS SSRS for teh end user requirements.
• Implemented role based security for various reports
• Involved in data transformations with aggregations and expressions
• Involved in enhancement of Forecasting cube using SSAS
• Involved in processing of CUBEs and Dimensions with incremental update option
• Involved in Dimensional data modeling to design data marts
• Involved in developing application modules using C#.
• Involved in designing and implementing teh Web Portal and Document Management System for our clients.
• Experience working as SharePoint administrator
• Used Visual Studio Team Foundation Server tool (VSTF) for source control
• Performed daily tasks including backup and restore by using MSSQL Server2008 tools like MSSQL ServerManagement Studio, MSSQL ServerAgent, and Database Engine Tuning Advisor.
• Implemented Constraints on tables for maintaining Data Integrity.
• Optimized queries by looking at Execution Plan for better tuning of teh database.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.

Environment: MS SQL Server 2005, T-SQL, SSIS packages, C#, MOSS 2007, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2003 server

Confidential, Detroit, MI

SQL Server Developer

Responsibilities:

• Reviewed product design (High Level/Low Level) for compliance with functional and technical specifications
• Analyzed business requirements and build logical data models that describe all teh data and relationships between teh data
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Backup and restore databases.
• Performed Unit Testing by creating test cases
• Involved in modification of existing reports
• Created Drilldown, Drill through and Parameterized reports
• Created SQL Server Agent scheduled Jobs for data transformations
• Responsible for trouble shooting of SQL Server Jobs and performance tuning of Jobs
• Responsible for weekly status meetings showing progress and future testing efforts
• Performed data transformations like conversions, classifications, merging of fields, derivations and derivations
• Validated change requests and made appropriate recommendations.
• Created SQL queries for data integrity to check if teh data is updated in teh tables and whether teh application runs smoothly
• Attended change control meetings and worked very closely with Business team to understand business requirements

Environment: Windows 2000/XP, SQL Server 2000, Microsoft Office, Visual Basic, VSS

Confidential, UK

SQL Server Developer

Responsibilities:

• System study and Business Requirements Analysis
• Involved in Installing SQL Server 2005 and creating users and Groups
• Designed data marts using Dimensional data model
• Designed teh FACT tables with 4 measures and 12 dimensions
• Created, Tested and deployed SSIS Packages for data migration into Facts and dimension tables in teh data mart from teh source data warehouse tables.
• Generated CUBEs using SSAS (SQL Server Analysis Services)
• Worked with MDX queries to verify teh data in teh CUBE
• Involved in CUBE processing with incremental and full process options
• Involved in transforming data from flat files and Oracle 9i
• Involved in code reviews meetings and designing sessions and get mentored from teh tech leads.
• Created Stored Procedures to and written complex queries to transform data
• Loaded teh data into data warehouse in form of Dimensions and Fact tables
• Developed complex reports using SSRS (SQL Server Reporting Services) and Crystal Reports
• Involved in testing of SSIS packages and reports

Environment: MS SQL Server 2005, T-SQL, SSIS packages, SSRS, MS Excel, Visio, Erwin, SQL Server Analysis Services, Windows 2003 server

Confidential

SQL Server Developer

Responsibilities:

• Understanding teh existing system and teh requirements
• Created DDL scripts, and tables, indexes, relationship constraints from teh physical models
• Involved in administration on Windows server
• Designed and developed reports using SQL Server 2000 Reporting services
• Created DTS packages to transform and transport data from legacy applications to teh centralized repository (SQL Server)
• Participated in user training and post implementation support
• Provided back-end support for functional testing and performance testing
• Involved in code review and unit testing of stored procedures

Environment: SQL Server 2000, DTS packages, SQL Server 2000 Reporting Services, Erwin, MS Office, VSS

Confidential

Responsibilities:

• Analyzed business requirements and build logical data models that describe all teh data and relationships between teh data.
• Validated change requests and made appropriate recommendations. Standardized teh implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access. Created and managed new security accounts.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2000
• Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created teh DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at teh server.
• Updated teh statistics info for both teh old and new servers.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000, T-SQL, DTS Designer, MS-Office, Crystal Reports, VSS