SUMMARY:

• Over 7+ years of extensive experience in Database Solutions and BI Solutions using Microsoft Technologies
• Extensive experience in Design, Development, Implementation & Administration of Database systems using MSSQL 2000/2005/2008 for both OLTP (Batch Processing, Online Processing) using DDL, DML, DCL commands for various business applications & Data warehousing Systems (SSRS,SSIS, SSAS)
• Experience in database programming in writing T-SQL Stored procedures, Triggers, Constraints (Primary Key, Foreign Key, Unique) Indexes and Batch Scripts using various DDL and DML commands.
• Experience in Writing Complex T-SQL Queries, Dynamic-queries, sub-queries, Complex joins.
• Experience in designing Database Models using MS Visio and ER-Win for both Relational and dimensional modeling
• Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s, DMFs and Query Execution Plans
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS), and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in conversion of packages from legacy systems (DTS to SSIS) and migrating, deploying the packages across Dev/UAT/Prod environments.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Good knowledge of Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using Analysis Services.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Excellent analytical/Communication Skills, Team Play and very much result Oriented

TECHNICAL SKILLS:

RDBMS/DBMS:

MS SQL Server 2000/2005/2008, Oracle 8i & 9i, MS Access 97/2000/2003, Sybase Server, Teradata V2R5, IBM DB2 UDB 8.2/8.0, Visual Source Safe 2005.

Operating Systems:

MS-DOS, Windows Vista/95/98/NT 4.0/XP/2000/2003 Server, UNIX, Linux 9.0

Programming Languages:

T-SQL, PL/SQL, Dynamic SQL, MDX, C, Visual Basic 6.0, VB Script, C# .NET, VB .NET, ASP .NET, ADO.NET, XML, HTML, DHTML, Shell Scripting, SQL * Plus

Data Modeling:

MS Visio, ERWIN 4.5/4.0, FACT& Dimensions tables, Physical & Logical data modeling, Star & Snowflake schema Relational, Dimensional and multidimensional modeling and De-normalization Techniques, Kimball & Inmon Methodologies, MS- Access.

Data Design Tools:

ER/Studio, ERWIN, MS Visio.

BI TOOLS:

SQL Server Reporting Services (SSRS 2000/2005/2008), SQL Server Integration Services (SSIS 2005/2008), SQL Server Analytical Services (SSAS 2005/2008), Data Transformation Services (DTS), Informatica, Visual Studio, BIDS

Tools/Database Utilities:

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest

Version Control:

Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), Remedy Change Management, Subversion

Application Packages:

MS Office, Microsoft SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007, ProClarity

Educational Qualifications: Bachelors in Electronics and Communications Engineering

MICROSOFT CERTIFICATION

• Business Intelligence Implementation and Maintenance with Microsoft SQL Server 2005 Enterprise Edition (Exam 70-445)

Professional Experience:

Confidential,VIRGINIA BEACH, VA
MS SQL/BI DEVELOPER JUL-09 – TILLDATE

Confidential, was founded in 1994 to respond to the growing need for private-sector partners in states managing healthcare programs for lower-income families and people with disabilities. Amerigroup is largest publicly-traded company focused exclusively on meeting the needs of those enrolled in publicly-funded healthcare programs, such as, Medicaid and Medicare.

Responsibilities:

• Responsible for gathering/refining requirements from the Business users for developing reports.
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS 2005 on windows server 2003.
• Created SSIS Packages to pull legacy data from Facets databases, Flatfiles and Excel spreadsheets.
• Created Complex Stored Procedures to tailor the Reporting needs.
• Responsible forcreating the reportsbased on the requirements usingSSRS 2005.
• Designedreport layoutsthat suits the requirements.
• Formatted the reports usingGlobal variables and expressions.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.

Environment: SQL MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005,
Windows 2003 Server, SSIS 2005, MS SQL Server 2000, Visual source safe, Facets.

Confidential,April 09 – JUL 09.
BLUEBELL, PA
MS SQL/BI DEVELOPER

The Project involved data conversion from mainframes to sql server 2005.

Responsibilities:

• Involved in meetings with business users for gathering requirements.
• Created SSIS packages to pull legacy data from DB2, flat files, and spread sheets to Sql server 2005.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedure
• Developed complex stored procedures involving the Conversion logic.
• Implemented performance tuning and query optimisation using various SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• Had Hands on experience with Java Eclipse Environment.
• Used Tortoise SVN a version control software for windows to store, run, view, edit and revert back to different versions of the design in case of a system crash
• Created Various ETL packages using SSIS to execute the conversion process.
• Performed Backup and Restore operations on the databases.
• Configured and managedLinked Serversbetween SQL Servers and DB2.
• CreatedDistributed Partitioned Views, synonyms,Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Involved in trouble shooting and testing the Issues related to conversion.
• Documented all the conversion documents for Future Reference.

Environment: MS SQL Server 2005 Enterprise Edition, Windows 2003 Server, Business Intelligence Development Studio (BIDS), Tortoise SVN, Java Eclipse.

Confidential,Glenwood, Illinois Mar`08 - Apr `09
MS SQL/BI DEVELOPER (SSIS/ SSRS/SSAS)

Responsibilities:

• Gather and Analyze Business Requirements by interacting with end users.
• Created Functional specifications documents based on the requirements.
• Involved in the analyzing the architecture and data model of the Agresso system (ERP) and giving suggestions for creating indexes and triggers.
• Created transformation procedures to extract data from heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert
• Extensively worked on the stored procedures to migrate the legacy data on to the ware house accommodating various business transformations.
• Created SSIS packages to export the transformed data into the Agresso data model.
• Converted existing DTS packages to SSIS pacakages.
• Created MOLAP Cubes on SQL Server 2005 Analysis Services as an alternative prototype to an existing relational data mart
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Modifying report content and exporting reports in multiple formats based on the business requirements.
• Used various types of report layout options like charts (bars, lines, pie etc...), images, graphs, sub reports, hyperlinks etc to make them more attractive and understandable.
• .Documented all the migration process documents for Future Reference.
• Involved in code review and code review meetings.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005,
Windows 2003 Server, SSIS 2005,SSAS 2005,MS SQL Server 2000, Microsoft SharePoint server, Agresso (ERP),
Visual source safe.

Client: Confidential,
MS SQL/BI Developer(SSAS & SSRS) Feb07 – Jan08

The project involved developing sales reports and statistics to cover weekly, monthly, quarterly, and annual historical information for the Sales department.
Responsibilities:

• Actively supported business users for given requirements.
• Studied database diagrams and understood the relations between different database objects.
• Identified the database tables for designing the queries for the reports
• Responsible for Installation, Configuration, Security, Maintenance, Restoration of SSRS 2005 on windows server 2003.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
• Written complex stored procedures in the database and used them in the reporting services environment while creating Data sets.
• Identified the Data Source and defining them to build the Data Source Views.
• Implemented Drill down and drill through and developed reports with graphs.
• Experience in sorting the data, defining subtotals for the reports.
• Formatted the reports using Global variables and expressions.
• Developed reports from cubes using MDX
• Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history using the Report Manager.
• Applied Security to Web Server and Database Server that affects Report server installation. Manage Role-based security to reports and reporting resources
• Optimized queries and performancesusing various SQL Server tools such as SQL Profiler, SQL Performance Monitor, Execution plan and Index tuning wizard.
• Provide Documentation support on SSRS 2005 as assigned.

Environment: MS SQL Server 2005 Enterprise Edition, MS SQL Server Reporting Services 2005,
Windows 2003 Server, SSAS 2005, visual source safe.

Confidential,Madison, WI
Confidential,Aug 05- Dec 06 MS SQL BI Developer (SSIS/SSRS)

Responsibilities

• Installation and Maintenance of MS SQL Servers, NT Servers, Windows 2000 Servers.
• Responsible for gathering/refining requirements from the Business users for developing reports.
• Configuration and Deployment of all the Reports(RDL,RDS) across various SDLC environments
• Involved in Collecting requirements from the User Community, Scope out Work and Timelines and development of Reports accordingly
• Involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs
• Created SSIS Packages to perform cube processing from staging area to Analysis Services cubes
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Developed Query for generating drill down and parameterized reports in SSRS 2005.
• Performed Report Testing and Verification as per Internal Reporting system requirements.
• Responsible for back up and Restoration of SQL Reporting Service.
• Created cached instances to improve the performance of multiple users.
• Assisted in some targeted performance tuning of a SQL server database that produced a very large increase in performance.
• Involved in various Transformations in SSIS Dataflow,ControlFlow using For loop Containers ,Fuzzy Lookups etc
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities
• Used Visual Source Safe (VSS) to store, run, view, edit and revert back to different versions of the design in case of a system crash
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.

Environment: VS2005, MSSQLServer2005/2000, SQL Server Analysis Services (SSAS), Reporting Services (SSRS 2000/2005), Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), Data Transformation Services (DTS), MDX,.Net, Visual Source Safe (VSS), MS Visio.

Confidential,Jun 04- Apr 05
Englewood, NJ
SQL Developer

Responsibilities:

• Analyzed the functionality, developed data model for Pharmacy Modules, using Erwin.
• Created Database, tables, relationships between tables, wrote Stored Procedures to insert the information of items received, issued, returned, and indents generated, expired items.
• Wrote Triggers to update the item status when item is issued, returned back from client, and sends a message when item goes below reorder level in stock.
• Implemented the indexes on columns having high selectivity, and low density to speed up the execution of data retrieval queries and stored procedures
• Developed database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and Indexes using T-SQL/PL SQL, SQL Analyzer and Enterprise Manager
• Wrote DTS Packages to transform daily and monthly jobs, like data on expired items, items below reorder level etc.
• Successfully tested and implemented Log Shipping, Technique used for standby server backup.
• Moved the entire phase from the Staging to the Production.
• Developed database, data extraction using Informatica tool
• Used SQL Server Profiler to trace the slow running queries and the server activity and with SQL performance tuning too.
• Analyzed and debugged jobs and procedures
• Performed Backup operations
• Used Crystal Reports to generate ad-hoc reports
• Used MS Sql reporting services to use daily report basis with client-server application.

Environment : Windows 2003, MS SQL Server 2000, SQL, T-SQL, SQL Query Analyzer, Profiler, Crystal Report 10.0., Erwin, Data modeling, MS sql reporting services XSLT processing and transformations, HTML, XPath, ETL, DTS packages.

Confidential,GA Aug 03– May 04
SQL DEVELOPER

Customized on-line ordering and tracking systems for itserve.com Online, This Portal provides the instructors immediate access to real-time information. The final content can either be printed digitally, duplicated and packaged in a CD-ROM or produce it in other mediums such as presentation boards and posters.

Responsibilities

• Create and maintain databases after logical and physical database design.
• Create database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Set database access privileges for different users and user groups.
• Perform optimization of SQL queries in SQL Server and Sybase system.
• Maintenance of clustered and non-clustered indexes.
• Create DTS Packages.
• Monitor SQL Server activity through profiler.
• Develop backup & restore scripts for SQL Server as needed.
• Performance optimization and normalization of database
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Maintain Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.
• Design and Develop reports in Crystal reports 8.5 for the various in-house systems.

Environment: SQL Server 2000, Visual SourceSafe, Crystal Reports.

Confidential,INDIA May’02 – July ’03

Responsibilities

• Designed databases for different projects and resolve database issues.
• Involved with Development and Testing teams in delivering the result to the production environment.
• Involved with Development Team extensively involved in the designing of Databases.
• Involved in updating and organizing data for different applications.
• Created and managed a number of databases on multiple servers.
• Daily support of all the databases including monitoring, alerting, and problem resolution.
• Created DFD’s, logical and physical diagrams using Erwin.
• Wrote error checking scripts for different applications.
• Involved in writing SQL stored procedures to enforce business logic.
• Was involved in developing a number of stored procedures, triggers and views using SQL Server 2000.
• Interaction with Development Team in fine Tuning the SQL and PL/SQL Codes.

Environment: Windows 2000/2003, MS SQL Server 2000, Erwin 3.5