SUMMARY

• Over 8 years of IT experience in complete Software Development Life Cycle and Agile Methodologies including Requirement Analysis, Design, Development, testing, Implementation .
• Strong Expertise in SQL Server 2000/2005/2008 components such as SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), SSAS(SQL Server Analysis Services).
• Expert in Migrating SQL 2000 databases to SQL 2005 and SQL 2008 using Migration tools.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors, derived tables, common table expressions (CTEs) and Triggers to facilitate efficient data manipulation and data consistency.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Expertise knowledge on Index tuning and hands on experience on Performance Monitoring
• Expert in Extracting and Transforming data using DTS in SQL Server 2000, SSIS in SQL Server 2008/2005,SQL Server Import Export Wizard, Bulk Insert Task and Bulk Copy Program(BCP).
• Experience in Importing/Exporting Data from various data sources like Excel, Oracle, DB2 and Flat file using DTS utility.
• Excellent command on subscriptions, report snapshot and report cache and built stylish Drill Down, Cascading, Parameterized, Drill through, Sub reports and Charts using Global variables, Expressions and Functions for teh Business Users using SSRS.
• Developing and deploying cubes with Star and Snow Flake Schemas using SSAS.
• Ability to deliver comprehensive BI through MS solutions including SharePoint Server (MOSS),Windows SharePoint Server 2003(WSS)
• Co - ordinate with DBA in regard to high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot, Log shipping, and Database Mirroring.
• Experienced in automating teh system by using Notification service and creating alerts, jobs and maintenance plans.
• Adept at interfacing with end users to gather requirements and produce functional requirements, Ample knowledge of Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008
• MS Access
• Visual Studio
• SSMS
• Query Analyzer
• DTS
• BI tools( SSRS
• SSIS
• SSAS)
• Bulk Copy program (BCP)
• SQL Server Management Studio
• Windows NT/2000/2003/XP/VISTA/2008
• Windows 7
• Linux
• Oracle
• Toad
• Erwin
• HTML
• XML
• JavaScript
• ASP.Net
• C#.NET
• Internet Information Server (IIS)
• MS Office

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

MS SQL Developer /BI ETL Developer

Responsibilities:

• Gather requirements and understand teh specifications of wholesale access certification needs.
• Designed and built prototype for access certification challenge on teh wholesale end to integrate with Enterprise access certification tool.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable teh applications to run better and reduce teh amount of time you need to spend managing them.
• Involved in improving performance by using filtered Indexes, Data snapshots for Reports building, regular dropping and construction of indexes.
• Good knowledge in analyzing Execution plan, Performan.
• Creating Database objects - Tables, Views, and Functions and developing Procedures for implementing application functionality at teh database side for performance improvement.
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & backup compression; SQL Server Auditing and MERGE statement in T-SQL and spatial data types provide powerful and easy to use application development enhancements.
• Worked extensively on SSIS Packages for extracting teh data of teh file system and transformed dat data and load it into OLAP.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging, Configuration Files etc.
• Designed, developed, debugged and tested SSIS packages, Stored Procedures, configuration files and implement best practices packages to maintain optimal performance.
• Developed and implemented error handling logics in all teh SSIS packages to handle bad data and avoid package failures.
• Developed SQL Server Integration Services (SSIS) packages to automate teh nightly extract transform and load jobs.
• Generated reports using SQL Server Reporting Services integrated and deploying them using web applications onto teh web servers.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Developed Tabular, Cross Tab reports, Charts reports, Parameterized, cascaded and sub-reports using SSRS.
• Used SQL Server 2005 to design, implement and manage data warehouses OLAP cubes and reporting solutions to improve asset management, incident management and data center services.
• Managed teh historical data in teh data warehouse from various data sources.
• Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.

Environment: MS SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, NYC

MS SQL BI Developer

Responsibilities:

• Worked on teh complete life cycle of teh project from design to implementation
• Translated user requirements into functional and technical requirements in coordination with teh Sr. Business Analyst
• Analyzed thebusiness requirement and functional specifications provided by teh data specialist
• Responsible for designing and maintaining a wide variety of daily, weekly, and monthly financial and analytical reports used by different departments within teh company.
• Responsible for making sure reports are scheduled and delivered in a timely manner
• Designed reports using proper text formatting, report headers and footers, and page size to allow for printable reports.
• Worked on SSIS for transferring data from Heterogeneous Data format to SQL Server.
• Created ad Hoc and parameterized various reports using SQL server 2005 reporting Services with data from SQL Server and MS Access as data sources
• Cleaned teh data and created fact and dimension tables, performed calculations required for teh reports using SQL Server 2005 environment and accomplished data modeling.
• Designed and architected of cubes for building reports using SQL Server Business Intelligence Development Studio to support business reporting and forecasting processes
• Designed and built teh dimensions and cubes with star schema using SQL Server Analysis Services (SSAS)
• Developed and designed cubes with around 45 dimensions, about 25 Measures and 20 calculated members, Design Dimensions and using teh MDX expressions for teh various calculated members, actions andKPI.
• 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.
• Extensively involved in theSSASstorage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.
• Documented teh complete data warehouse environment, including all dimension and fact tables, teh relationship between SSIS packages and teh target tables, which packages were valid and in use, teh relationship between teh jobs and SSIS packages, and teh relationship between teh source tables and teh OLAP tables used in teh SSAS Cube
• Created ad hoc SSRS reports in teh test environment for data validation
• Created dynamic Reports from teh cube using SSRS 2005, and stored procedures.
• Troubleshoot teh deployment of reports in teh test and production environment using SSRS

Environment: SQL Server 2005/2008, SQL server Reporting Services 2008, SQL Integration Services 2008, SQL Analysis Services 2008,Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL,ERWIN.

Confidential, Bellevue, WA

MS SQL/Report Server Developer

Responsibilities:

• Developed T-SQL code, Views, Functions and Stored procedure using T-SQL to get data from Different data and with best execution plan.
• Scheduled SQL jobs in SQL Server 2005 to generate alerts to teh subscribers to teh alerts in RAN 2G & 3G and CORE alerts.
• Created different user-defined functions using T-SQL Query for teh creating Datasets and Data Adapters to use them in SSRS 2008 and SSIS.
• Configured SQL Mailing Agent for sending alerts to teh subscribers by mails upon SSIS packages, SSRS reports2008 and T-SQL Stored Procedures.
• Involved in developing and deployed Reports from OLAP in SSRS with Charts and PIE Diagrams.
• Created Drill Down and Drill through reports with user defined parameters with sub reports, Pie diagrams and Charts in SSRS.
• Configured in report architecture and report security for reports in SQL Server Reporting Services.
• Involved in invoking reports created in SSRS to front-end like Share-Point server for teh managerial and client verification.
• Developed Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server 2005 Reporting Services (SSRS) in Crystal reports.
• Built advanced reports using query parameters, report parameters, filters, interactive sorts to compare teh rates among teh four major regions, to generate teh alerts history in active reports.
• Developed Templates for teh reports for teh managerial cadet so dat they need to drag and drop teh fields which they need exclusively for Non-technical person in SQL Server Reporting Services (SSRS).
• Created report models for ad hoc reports when teh end user wants to see teh reports on fly in SQL Server Reporting Services (SSRS) in Data Dynamics report with VB.NET.
• Created Ad-hoc reports for manager using SSRS to find all teh work items open for Developers.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in teh centralized Confidential SQL database.
• Migrated data from Heterogeneous Data Sources and legacy system (ORACLE (OSS), Access, Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS)
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
• Generated Crystal reports using SQL Server Reporting Services integrated and deploying them using web applications onto teh SharePoint web servers in Data Modeling.

Confidential, San Jose, CA

MS SQL Developer

Responsibilities:

• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.
• Developed Technical Design specifications and Source to Target Mapping (STTM) specifications for each legacy system interface with Enterprise system.
• Designed and developed physical and logical Data Models using Erwin and developed SQL Server Database objects including Tables, Views and Indexes.
• Designed, developed and deployed complex DTS packages to cleanse and transform data and load from legacy systems into teh Enterprise system SQL Server database.
• Used advance features of T-SQL to design and tune T-SQL to interface with teh databases and other applications in teh most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in Crystal Reports to enable report generation on teh fly.
• Designed and implemented Job scheduling, setting up alerts, User logins and access rights based on user roles, permissions and security requirements.
• Analyzed and designed disaster recovery and replication strategies based on business requirements.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Tested to optimize teh procedures and triggers to be used in production.
• Prepared Documentation of teh system.

Environment: SQL Server 2005/2000, MS-Access, DB2/UDB, ERwin7.1, VB Script, WIN2000/XP.

Confidential, Oaks, PA

MS SQL Server Developer

Responsibilities:

• Involved in Installing SQL Server 2000 with latest service pack.
• Extensively worked in creating Database, database objects such as view, table, stored procedure, trigger and function using T-SQL.
• Performance tuning of stored procedure.
• Wrote complex Join queries using T-SQL.
• Created teh Logical and Physical Data Model using Erwin tool.
• Created DTS Packages to integrate teh Business Logic and Data Transformations
• Transformed data using DTS packages, BCP utility and Bulk Insert statement.
• Created and saved DTS package according to requirements.
• Performance tuning of server and gave suggestion to senior developer.
• Created and managed index.
• Involved in Performance Tuning activities including Query Tuning and Index Maintenance.
• Monitoring teh application and database performance using SQL Profiler and Performance Monitor
• Used Index tuning wizard to get a better idea of implementing indexes on teh existing databases
• Created Database Maintenance Plans for Database Backups, Re-indexing and Data Integrity Checks
• Created SQL Server Jobs and Schedules for automated and timely execution of Daily, Weekly and Monthly processes.
• Created Windows Admin Scripts to monitor Disk and Tape Backups, Disk Space and Service Status for different servers and generate alerts.
• Created SQL Server Agent Alerts to monitor teh SQL Server Events and SQL Server Performance Alerts and notify teh Administrators of teh critical situations.
• Created Triggers to monitor activities on server as well as database and generate alerts and notifications.
• Created Stored Procedures, User-Defined Functions, Ad-hoc Scripts and Cursors on Development and Test servers for pre-deployment testing.

Environment: MS SQL Server 2000, Enterprise Manager, Query Analyzer, and System Monitor/Performance Monitor, Event Viewer, Database Maintenance Plan Wizard and Data Transformation Services, T-SQL, Third party Application, Windows 2003/2000 server, Window 2000

Confidential

SQL Server Developer

Responsibilities:

• Extensively involved in installing and configuring SQL server 2000.
• Transformed data using DTS packages, BCP utility and Bulk Insert statement as and when necessary.
• Improved Performance of databases by analyzing Indexes, Fill Factor and Fragmentation issues
• Monitored server critical issues including Response Delay, Locking/Blocking and Server Downtime.
• Created Scripts to monitor Backups, Drive Space, Log Size, Database Size and Service Status monitoring.
• Creation and Management of Jobs, Schedules and Sending Alerts using SQL Mail
• Gained expertise in Security Issues by creating Users and granting Permissions on various Objects
• Creation of Triggers to perform Data validations as well as Server level and Database level monitoring and Alert teh users with teh field status changes.
• Created database and database objects such as index, Table, stored procedure, view, trigger and function using T-SQL.
• Monitoring server performance by using Performance counter.
• Created complex Stored Procedures and Cursors to support applications using T-SQL.
• Prepared Estimates for Database Files and Table size growth. .
• Generated Reports for teh day-to-day as well as weekly/monthly purposes.
• Created Distributed Partition views Using T-SQL.

Environment: MS SQL server 2000, Windows 2000, Enterprise manager, Query analyzer, DTS, SQL profiler.