SUMMARY

• Over 8 years of experience in database administration, database design, development and support of SQL 2005/2000 in production and development environment.
• Extensively worked in OLTP & OLAP environments that include QA, Production and development databases in SQL Server.
• Hands on experience in all phases of SDLC (software development life cycle) involving Requirement analysis, Software design, development, implementation, testing, maintenance and Object Oriented Design (UML).
• Experience in Data modeling using data modeling tool (MS VISIO and Erwin).
• Good knowledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Expertise in writing Transact-SQLqueries, Creation of databases, Stored Procedures, create and use extended stored procedure using C# and SQL, Functions, Triggers, Views, Indexes, Schemas, Table, Joins, partitioning and Constraints.
• Having good experience in PL/SQL and experienced in Quality Center and other defect tracking tools for defect fixing and resolution.
• Experienced in Business Intelligence (SSIS, SSAS and SSRS), Data Warehousing and Dashboards.
• Having good experience in .NET Framework class libraries and tools for building Web services, as well as facilities for hosting services within Internet Information Services (IIS).
• Strong experience in Data warehouse, ETL- Extraction/Transformation/Loading, Data Analysis, Data migration (MS Access, Excel - MS SQL 2000/2005/2008 , DB2, Oracle), Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Data validation and Documentation.
• Experience in using SQL Server 2005 Integration Services (SSIS) to extract, Transform and Load(ETL) data and DTS (i.e. Import and Export) and Automate the ETL operations.(Automate the SSIS Packages and Import, Export).
• Used Bulk Copy Program extensively for transferring data from Text to SQL Server.
• Experienced in designing, building, analyzing, and optimizing performance of OLAP/ROLAP hyper-cubes to expose key performance indicators (KPI's) from a large data set using SQL Server 2005 Analysis Services (SSAS).
• Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, MDX Scripts and formulas, Refresh Strategy and Planning.
• Extensive experience in the automate tasks using activeX script and implement failure alerts using email.
• Experience in developing 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).
• Experienced in Dashboards and Scorecards.
• Experience in performing administrative functions including Backup and Recovery, Database Security, Indexing, Client/Server Connectivity (IIS web services), Running Database Consistency Checks, data loading, batch jobs, data unloading, user and application table management, Replication, Clustering and Log shipping, upgrades, creating databases/file groups/files/transaction logs, Performance Tuning, Disaster Recovery and Object Permissions.
• In-depth knowledge of ERP Applications including General ledger, Sales Order Processing, Accounts Receivable, Accounts Payable, Inventory Control, Purchase Order Processing, Process Manufacturing, Maintenance Management, Government, Public services sector management and High-volume eCommerce infrastructures.
• Excellent interpersonal skills working in teams with people from different cultures and backgrounds. And energetic with excellent analytical and organizational skills.

TECHNICAL SKILLS

Databases: MS SQL Server 2008, 2005, 2000, 7.0, MS Access 2003/2000, DB2, Oracle10g/9i/8i, Sybase and MySql.

Programming Languages: TSQL, PL/SQL, SQL, XML, XHTML, C#, C, C++, Java, Visual Basic 5.0, 6.0.

Operating Systems: Windows NT 4.0, Windows Server 2003, Unix and MS-DOS.

SQL Server Tools: MS Enterprise Manager, SQL Server Query Analyzer, SQL Server Management Studio, SQL Server Business Intelligence (SSIS, SSAS, SSRS), Development Studio and SQL Server Profiler.

Reporting Tools: SQL Server Reporting Services, Crystal Reports 10.0

Other Tools and Utilities: MS Visual Studio, MS Office 2000/2007, Informatica, Info path, Visual source safe, PVCS,, FoxPro and Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, FL

Sr. SQL Server Developer (SSIS, SSAS and SSRS)/DBA

Responsibilities:

• Interacted with Customers, Business Analyst, Project manager and gathered and Peer Reviewed the Business Requirements, Software Requirement, Design (HLD’s, LLD’s), Developing, Testing and Maintenance.
• Performed Server installation and configuration using SQL Server 2005.
• Upgraded data from SQL Server 2005 to SQL Server 2008.
• Performed both logical and physical modeling of databases.
• Worked in 2- node Active/Passive Clustered Environment.
• Designed and developed Databases, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Developed ETL process, Designing and Implementing Data Warehouse.
• Involved in ETL development including source, destination, mapping, SCD(Slowly Changing Dimensional-Type1, Type2, Type3), and exception handling.
• Involved in Database portioning, Index partitioning, Range partition and Partitioned Table.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Involved in SQL Server replication strategies to support Disaster Recovery and Business Continuity.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Server Profiler and Database Engine Tuning Advisor.
• Supported EDW/CDWs 24x7 operation by being on-call as needed for data related issues.
• Automate tasks using active X script (similar to VB script). Be able to implement failure alerts using email.
• Involved in Object Oriented Design (UML, activity diagrams, Use cases and Object Modeling).
• Involved to develop the VB Script, C#, ASP. Net, VB. Net and .Net framework creation.
• Created and used extended stored procedure (pointing DLL using C#).
• Used MS Performance Point Server to improve performance by integrating monitoring, analysis, and planning.
• Snapshot Replication was been used to synchronize the data between their Different Stores.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard.
• Involved in Log shipping, Replication and Recovery Databases.
• Created and monitored database maintenance plans for checking database integrity.
• Giving the connection between front-end application and backend database (SQL Server) through IIS web services.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access, Oracle10g, text files and Excel files.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created jobs, alerts to run SSIS packages periodically.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Coordinated integration of data cleansing scripts with ETL and scheduling tools.
• Worked with different Loop containers and Tasks in Control flow tab.
• Worked with different dataflow source, Transformations and Destinations in Data flow tab.
• Involved in complete SSIS life cycle. Creating SSIS packages, building, Deploying and Executing the packages in both environment (Development and Production).
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Played a major role in production support of SSAS (cube refresh), SSIS jobs.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Involved in creating data mining solution (Model creation, Describes business problem, and run data through an algorithm) to make intelligent decisions about difficult business problems.
• Involved in writing MDX queries and performance optimization of the SSAS cubes.
• Experience in writing complex MDX queries for calculated members and measure groups.
• Experience in building Reports on Analysis Services cubes.
• Installation and configuration of SQL Server Reporting Services (SSRS) 2005 and 2008
• Designed and developed various complex reports such asDrill down, Drill Through, Sub Reports, Cross TabbedusingMS Reporting Services.
• Responsible for stylish design layout likePie charts,GraphsandLinked Reports.
• Involved in designingParametrized Reportsand alsocascaded Parametrized Reports.
• Prepared AD HOC reports through report builders.
• Involved in SSRS Manager to Managing SQL Agent Jobs creating and modifying data driven subscriptions, fine-tuning subscription execution.
• Developed Query for generating drill down reports in SSRS 2005.
• Based on Windows Script Host manipulated the files using VB Script.
• Created Windows Logins and privileges to User Accounts/Groups and objects.
• Used DBCC commands to troubleshoot issues related to database consistency.

Environment: SQL Server 2005/2008, MS Access, Excel, Oracle10g, Windows Server 2003, IIS, Visual Source Safe, Share point Server, Crystal Reports, Microsoft Performance point server, Net Frame Work, ADO. Net, VB.Net, ASP. Net, XML Parsing, XSLT, VB6, VB Script, Java Script and C#.

Confidential, Atlanta, GA

Sr. SQL Server Developer (SSIS, SSAS and SSRS)/DBA

Responsibilities:

• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Actively involved in designing the logical and physical architecture for Liberty group database.
• Designed and developed Databases, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Developed the PL/SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Created automated stored procedures for day end operations using SQL Server agent.
• Involved in SQL Server replication strategies to support Disaster Recovery and Business Continuity.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard.
• Involved in Log shipping, Replication and Recovery Databases.
• Created and monitored database maintenance plans for checking database integrity.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Involved in mock testing and Unit Testing and Integration testing.
• Involved to develop the VB Script, C#, ASP.Net and VB.Net.
• Created automated stored procedures for day end operations using SQL Server agent.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Server Profiler and Database Engine Tuning Advisor.
• Created SSIS packages using MS SSAS, Script Component VB, C# developed Star Schema using BIDS for ETL process.
• Designed and developedSSIS Packages (.dtsx files)to import and export data fromOracle 10g, Ingres, MS Excel, SQL Server 2005 and Flat files.
• Wrote MDX queries for Cube and Checked performance in SQL Server Profiler.
• Created stored procedures using PL/SQL as a data sources and data set for Cube building.
• Configured Dimensions, Measures and Measures Groups using SQL Server 2005 Analysis Services.
• Created and Configured OLAP Cubes using SQL Server 2005 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Identified and worked with parameters for parametrized reports in SSRS 2005.
• Designed and developed various complex reports such asDrill down, Drill Through, Sub Reports, Cross TabbedusingMS Reporting Services.
• Involved in designingParametrized Reportsand alsocascaded Parametrized Reports.
• Created and managed users, roles and groups and handled database security.

Environment: SQL Server 2005, Oracle 10g, Ingres, Excel, Teradata, MS Visio, T-SQL, Excel, Advanced Windows 2003 Server, IIS, Crystal reports, Visual Source Safe (Version Control Management) and Microsoft Access, ASP .Net, C#, VB .Net

Confidential, Atlanta, GA

Sr. SQL Server Developer (SSIS, SSAS and SSRS)/DBA

Responsibilities:

• Worked for internal client, gathering requirements, business analysis.
• Created Data Models using ERstudio/Erwin, implementing physical models for databases.
• Developed ETL process, Designing and Implementing Data Warehouse.
• Involved in designing the Dimensional Modeling (logical design technique) often used for data warehouses.
• Involved in Creating Data marts in Data Warehousing.
• Analyzed data from legacy systems for Data migration project (SQL 2000/Oracle - SQL 2005)
• Database creation, database tuning, and performance planning, backup planning, restoring and database administration.
• Created Clustered and Non-clustered Indexes for Query Optimization and also involved in Database Tuning.
• Created SSIS packages using MS SSAS, Script Component VB, C# developed Star Schema using BIDS for ETL process.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job
• Responsible for transferring the data using SSIS packages from OLTP to OLAP.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Teradata, Mysql, and Text files and Excel files) to SQL Server.
• Data migration (import & export - BCP) from Text to SQL Server.
• Configured Server for sending automatic mails to the respective individuals when a DTS process fails or succeeds.
• Published reports on MS SharePoint enterprise wide.
• Change Commands DBCC and worked with VLDB (Very Large Databases).
• Designed Cognos Query for reporting and presenting Sales graphs.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Was involved in performance tuning of databases and cubes.
• Developed Molap Cubes for data viewing and integrated external application iCube.
• Data migration Financial Statements (DB2 - SQL 2005)
• Worked on different phases to get other data models and data from different systems in one data warehouse.
• Project: Developed ETL process and Created Sales cube using BIDS.
• Project: Defined and Ad Hoc Reporting using SSRS (Trained Fulltime Resources) and Cognos.
• Project: Created Data Models for Enterprise suite.
• Project: Data Migration - Oracle, DB2-SQL 2005, legacy systems SQL 2000 - SQL 2005.

Environment: SQL Server 2005, Oracle 9i, DB2, MS Access, Excel, Windows Server 2003, IIS, Visual Source Safe, Share point Server, Cognos, Crystal reports, Net Frame Work, ADO.Net, VB.Net, ASP.Net, XML, VB6, VB Script, Java Script and C#.

Confidential, Dallas, TX.

Sr. SQL Server Developer (SSIS, SSAS and SSRS)/DBA

Responsibilities:

• Upgraded databases from SQL Server 2000 to SQL Server 2005.
• Actively involved in designing the logical and physical architecture for Liberty group database.
• Designed and developed Databases, Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views, Rules, Defaults and complex SQL statements.
• Created the Partitioned Table, Partitioned table orders.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Created automated stored procedures for day end operations using SQL Server agent.
• Involved in SQL Server replication strategies to support Disaster Recovery and Business Continuity.
• Scheduled Database and Transactional log backups using the Database Maintenance Plan Wizard.
• Involved in Log shipping, Replication and Recovery Databases.
• Created and monitored database maintenance plans for checking database integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Involved to develop the VB Script, C#, ASP.Net and VB.Net.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Performance tuning of SQL queries and stored procedures using SQL Server Profiler and Database Engine Tuning Advisor.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job
• Responsible for transferring the data using SSIS packages from OLTP to OLAP.
• Worked on DTS Packages, Import and Export Wizard for transferring data from Heterogeneous Database (Teradata, Mysql, and Text files and Excel files) to SQL Server.
• Configured Server for sending automatic mails to the respective individuals when a DTS process fails or succeeds.
• Configured Dimensions, Measures and Measures Groups using SQL Server 2005 Analysis Services.
• Created and Configured OLAP Cubes using SQL Server 2005 Analysis Services and Performance tuning MDX and dimensions design and scaling to large numbers of users.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Created and managed users, roles and groups and handled database security.

Environment: SQL Server 2005/2000/7.0 , Mysql, Excel, Teradata, Visio 2000, T-SQL, Excel, Advanced Windows 2000 Server, IIS, Crystal reports, Visual Source Safe 6.0 (Version Control Management) and Microsoft Access, ASP .Net, C#, VB .Net

Confidential, Huntersville, NC

SQL Server Developer/DBA

Responsibilities:

• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Wrote complex queries, triggers and stored procedures, views and user defined function.
• Design and implement database logical and Physical Schemas.
• Created the Partitioned Table, Partitioned table orders
• Responsible for database tuning using normalization and application tuning
• Maintenance of Development, System test, Assemble test and Integration Servers and databases.
• Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.
• Developed the PL/SQL programs.
• Used Quality center (Defect tracking tool) for Bug fixing and resolution details.
• Involved in mock testing and Unit Testing and Integration testing.
• Worked on DTS Package, DTS Import for Transferring data from Oracle and Teradata.
• Query tuning, Index Tuning and performance tuning
• Created custom and standard reports using Crystal Reports.
• Developed parameterized crystal reports existing reports for presentations using cross-tab reports, running totals, and alerting.
• Created and modified stored procedures to Create Reports.

Environment: Windows 2000 Server, MS-SQL Server 2000/7.0, Oracle, TeraData,Visual Basic6.0, ASP, VB Script, Java Script, IIS, Visual Source Safe and Internet Information, Server 4.0, Crystal Reports, Informatica, Microsoft Access FTP Communication

Confidential

SQL Server Developer/DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in writing T-SQL programming for implement Stored Procedures and Functions for different tasks.
• Wrote complex queries, triggers and stored procedures, views and user defined function
• Design and implement database logical and Physical Schemas
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks
• Updated Database Statistics and Re-indexing
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
• Snapshot Replication was been used to synchronize the data between their Different Stores
• Data migration (import & export - BCP) from Text to SQL Server
• Converted DB2/400 Database to SQL Server using DTS Package and used DTSRUN.
• Created Triggers to enforce data and referential integrity
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers
• Incorporated business logic using stored procedures while converting from DB2 to SQL SERVER.
• Maintained SQL Script for creation of Database Objects
• Designed Different kinds of Transactions for the application (OLTP)
• Used DTS migrated the tables to the Data Warehouse
• Installation, upgrading, maintenance and administration of LANs and WAN
• Conducted product evaluations of upgraded and hardware and software; identifying strengths, weaknesses, and potential benefits
• Developed testing and upgrading disaster recover plan for IT, and assuring integration with company’s disaster recovery plan
• Carried out training in software and hardware operations

Environment: Microsoft SQL Server 2000, DB2, Visual Studio 6 Technologies (XML, JavaScript, HTML, Microsoft Visio 2000, Microsoft Visual SourceSafe and Windows 2000/XP)

Confidential

SQL Developer

Responsibilities:

• Upgraded SQL Server 7.0 to SQL Server 2000. Also Performed SQL Server 2000 Installation
• Worked on Client/Server tools like SQL Server Query Analyzer to administer SQL Server
• Created Database Maintenance Planner for improving the performance of SQL Server which covers Database Integrity Checks, Updated Database Statistics and Re-indexing
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery
• Designed DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database
• Data migration (import & export - BCP) from Text to SQL Server
• Clustered Server and Load Balancing to maintain the Redundancy of Servers
• Configured IIS Server for the XML programming which was a new level of SQL 2000
• Configured Exchange Server for sending automatic mails to the respective people when a jobfailed or succeed
• Configured Commerce Server for capturing the Web Log details of the User
• Moved the entire phase from the Staging to the Production
• Created Triggers to enforce data and referential integrity
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers
• Designed Different kinds of Transactions for the application
• Maintained SQL Script for creation of Database Objects
• Documented business rules, functional and technical designers, test cases and user guides.
• Conducting training for users.

Environment: Microsoft SQL Server 2000/7.0, Microsoft Windows 2000 Server, Microsoft Visual Basic and Microsoft Access 97/2000.