SUMMARY

• 8+ years of solid BI and Database development experience with some Database administration(DBA) duties
• Experience with software development life cycle (SDLC) and project management methodologies
• Expertise in designing, implementing, maintaining, and documenting complex database applications, and data warehouse in financial environments
• Extensive experience with data modeling, logical and physical database design using Erwin
• Design entity relationship diagrams and dimensional data models
• Extensive experience with SQL Server and T - SQL, Oracle PL/SQL in constructing triggers, tables, user functions, UDF’s, views, indexes, user profiles, relational database models, data dictionaries, and data integrity
• Extensive experience with SQL scripts, stored procedures, triggers, functions, SQL Performance tuning and transactions analysis, thorough understanding of indices and statistics.
• Hands on Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000
• Experienced in the installation and configuration of SQL Server 2000 and SQL Server 2005
• Hands on Experience in Integration Service, Analysis Service, Reporting Service(SSIS,SSAS,SSRS)
• Extensively used Business Objects (BO) reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, filters, Ranking, Sections, Graphs and Breaks.
• Hands on Experience in Extracting and transforming Data with SQL Server
• Experience with establishing and maintaining security integrity controls in conjunction with the applications and security groups and assist in the design and implementation of development, testing, QA, and production environments.
• Excellent report creation skills using Microsoft Reporting Services
• Strong experience in design and construction of data marts and data views.
• Hands on experience Crystal Report, and Crystal Analysis
• Worked with Crystal Report for creating complicated reports including sub-reports, parameter based reports, graphical reports, formula based, well-formatted reports, drilling reports, analysis reports.
• Worked in a TFS (Team Foundation Server) environment.
• Industry working experience in SQL Server and Oracle database management, maintenance, performance tuning, and troubleshooting
• Extensive experience in providing Enterprise Tier-N Platform Services operational technical support
• Experience in UML, data-flow, Rational Rose, and DTS package design and construction
• Proficient with creating Use Cases, Sequence Diagrams, Component Diagrams, Collaboration Diagrams, Activity Diagrams, and Class Diagrams
• Excellent communication, presentation and interpersonal skills
• Strong troubleshooting and organizational skill

TECHNICAL SKILLS

Technology Database: SQL Server 2008 R2/2005/2000, Oracle 9i/10g T-SQL, PL/SQL, SQL PLUS SQL Server Integration Service (SSIS) SQL Server Reporting Service (SSRS) SQL Server Analysis Service (SSAS) OLTP, OLAP

Performance Tuning (SQL Profiler): Installation, Upgrade, & Migration ODBC, JDBC, OLE DB, DTSOperating Systems Windows Enterprise 2008/2003 Advanced Server/2000 Server/Windows 2000 Professional/Windows XP Professional/NT 4.0 Server

Tools: & Applications SharePoint Server MOSS 2007, Erwin 3.5/4.1, Toad, TFS (Team Foundation Server), VSS, CDC, Litespeed (Backup/Restore), Remedy, PVCS, SQL Loader, Pro *C, CRM Business Objects Crystal Report 8.5/9/10, XI R2 Visual Studio 2005/2008/.NET

Language: .net, C#, VB.net, ASP, UNIX Shell Scripting, Perl scripting

Protocols: HTTP, HTTPS, TCP/IP, FTP, IPX/SPX

PROFFESSIONAL EXPERIENCE

Confidential, OH

Sr BI Developer

Responsibilities:

• Collected surveys information, gathered requirement for end user reports.
• Installation and configuration of SQL Server Reporting Services (SSRS/SSIS/SSAS) 2005 and BIDS.
• Expert in creating Tabular, Matrix reports, List, Parameterized, Sub, Adhoc reports and Graph reports.
• Expert in creating rich format reports report navigation, linking .net and SQL Reports.
• Involved in ETL works before reports being created.
• Created T-SQL Tables, Views, triggers, stored Procedures and modified existing ones for report dataset.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Played a major role in deploying reports to report manager and production support of SSRS reports.
• Created forms in .net using C# and VB code, Data grid view for dataset.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• 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.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.(SSRS)(2005/2008).
• Involved in creating report models and applying row level security filters for report model.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the reports generation, cube refresh packages.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Experience in moving the data from heterogeneous data sources like oracle, xml etc to sql using SSIS.
• Hands on experience in using different transformations like fuzzy lookup, derived column transformation etc using SSIS.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Played a major role in the production support of SSRS reports, SSAS cubes and SSIS jobs.
• Involved in migrating SSRS, SSIS packages from SQL 2005 to SQL 2008.
• Designed SSRS 2008 reports with MOSS 2007 for directly deploying the report in SharePoint 2007.
• Worked in a TFS (Team Foundation Server) environment.

Environment: SQL Server 2005/2008 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, .Net(ASP, C#), Visual Source Safe VSS, XML, MS Office tools, SharePoint MOSS 2007, TFS.

Confidential, OH

Sr. BI / SQL Server Developer (CONTRACT)

Responsibilities:

• Performed business requirement analysis to derive function specification and use cases
• Designed physical and logical data models collaborated with team leader by using Erwin and Rational Rose
• Designed, implemented, and maintained very complex and large databases with all database respect to access methods, access time, validation checks, security management, device allocation, database organization, documentation, and statistical methods
• Conducted logical and physical database design including data modeling, maintenance, problem diagnosis and resolution
• Responsible for support the develop Team which are developing Applications.
• Created and developed the stored procedures, triggers and Functions to handle complex business rules, history data and audit analysis
• Conducted database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager
• Responsible for implement Replication
• Transfer Data using Integration Service(SSIS)/DTS
• Extract Transform Load(ETL) development using SQL Server Integration Services (SSIS).
• Dimensional Data Modelling and cube development in SQL Server Analysis Services (SSAS).
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Transfer Data From OLTP Database to OLAP Database.
• Creation of OLAP cubes using Analysis service (SSAS) and DTS scripts
• Created and administered multiple development, training and production databases
• Work with business teams and obtain relevant business logic to efficiently translate business requirement into code and improve the services in customer relationship management CRM.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Troubleshoot databases and custom application issues
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Managed the granting of access to operational and developmental application system databases
• Extensively used calculations, variables, Drill Down and slice and Dice for creating Business Objects reports.
• Worked in a SharePoint MOSS and TFS (Team Foundation Server) environment.

Environment: SQL Server 2000/2005/2008 Oracle 8i, 9i, 10g, Windows Enterprise Server 2003, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, FTP, SQL Server Integration Services (SSIS),Microsoft Reporting Services (SSRS),Business Objects reports, Crystal reports, SharePoint MOSS, TFS.

Confidential, PA

Sr. SQL / BI Developer

Responsibilities:

• Designed physical and logical data models collaborated with team leader by using Erwin
• Performed business requirement analysis to derive function specification and use cases
• Responsible for support the develop Team which are developing Applications.
• Created and developed the stored procedures, triggers and Functions to handle complex business rules, history data and audit analysis
• Transfer Data using Integration Service(SSIS)/DTS
• Transfer Data From OLTP Database to OLAP Database.
• Creation of OLAP cubes using Analysis service (SSAS) and DTS scripts
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Extensively used Business Objects (BO) reporting functionalities such as Master Detailed, Slice and Dice, Drilling methodology, filters, Ranking, Sections, Graphs and Breaks.
• Created and administered multiple development, training and production databases
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases
• Monitored strategies, processes and procedures to ensure the data integrity, optimized and reduced data redundancy, maintained the required level of security for all production and test databases
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning, and SQL Server clustering, managed database quality assurance including database consistency check
• Responsible for creating standards and operating procedures to maintain all databases
• Worked with development teams in the design of physical databases and in modification
• Ensured developers coordinated their efforts in managing and maintaining different application databases
• Troubleshoot databases and custom application issues
• Eased administrative work through automatic script performing daily/weekly backups
• Reduced systems downtime risk through automatic offsite backup and recovery over network
• Responsible for database security of the operational and developmental application system databases
• Responsible for implement Replication
• Designed, implemented, and maintained very complex and large databases with all database respect to access methods, access time, validation checks, security management, device allocation, database organization, documentation, and statistical methods.

Environment: SQL Server 2000/2005 Enterprise, Oracle 9i, Windows Enterprise Server 2003,Oracle 9i/10g, CRM, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, SQL Server Integration Services (SSIS),Microsoft Reporting Services (SSRS),Business Objects Crystal Reports, Oracle 9i.

Confidential, IL

Sr. SQL Server Developer/DBA

Responsibilities:

• Implemented and maintained database security.
• Created DTS packages for the loading the data.
• Used the reporting services to create, schedule and publish the reports required.
• Administrator tasks like managing users, roles, and profiles.
• Performed Database backups (operating system, flat file backups & export/import).
• Used Snapshot replication for creating multiple instances of a database for distributing the workload.
• Configured Snapshot Replication (Creating Distribution Databases, updating Publishers, creating & managing Publications, managing Replication monitors).
• Tuned SQL statements and SQL Procedures.
• Combined a few simple, unrelated Database Accesses to improve performance.
• Used Query Analyzer to optimize SQL Queries.
• Maintained the physical Databases by monitoring Performance, Space utilization and Physical integrity.
• Coded Procedures & User defined Functions in TSQL.
• Established and documented a complete Disaster Recovery Plan for the Database servers.
• Created Crystal Reports for Business Intelligence.
• Daily monitoring of the database performance and network issues.
• Rebuilding indexes on various tables.

Environment: Oracle 9i, MS SQL server 2000, Windows 2000, Crystal reports 6.5/8.0, Foglight, Enterprise manager, Veritas backup solution, DTS, SQL profiler.

Confidential

Sr. SQL Server Developer(CONTRACT)

Responsibilities:

• Designing and implementing the module based on the business requirements given by the business analysts.
• Generating Script files of the databases when ever changes are made to stored procedures or views or any other database objects and checking the objects in VSS.
• Used Visual Studio. Net to run the scripts in different environments of development databases and to check-in the scripts into VSS.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Managing the use of disk space, memory and connections.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Installing SQL Server service packs based on the errors and flaws that are found in the application.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.
• Creating and managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity.
• Server & Application fine-tuning & trouble shooting. Monitoring MS SQL Server performance and network issues.
• Administering the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Helping Development Team in deploying and testing the application, which uses SQL Server as a database.
• Database and Transaction log backups & restoration, backup strategies, scheduling the backups.
• Backing up system & user databases and restoring them when ever necessary.

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

Confidential

SQL Server Developer

Responsibilities:

• Database planning in relation to physical and logical data architecture.
• Analyzed business requirements and build logical data models that describe all the data and relationships between the 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.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created the DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, Lotus, XML in order to create and maintain a centralized data warehouse.
• Creation of OLAP cubes and DTS scripts.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2000 Enterprise Edition, Windows 2000 advanced server, IIS 6.0, .NET, Erwin, Microsoft Visio 2003, SFTP, Crystal Reports 6.5.