SUMMARY

• 7+ years of strong experience in the IT industry as a MS SQL Server Developer include experience in design, development, implementation and administration of database systems using MS - SQL Server 2008/2005/2000 for both OLTP & Data Warehousing Systems applications (SSRS, SSIS, and SSAS).
• Strong team player with excellent problem-solving skills and ability to take new roles, self-starter with excellent communication skills.
• Strong experience in OLAP, Data marts, Data warehousing, Operations Data Store concepts and ETL technologies.
• Experienced in high level business review Application such as HP BAC, HP Site-Scope & IP Monitor.
• Expert in developing T-SQL (DDL, DML) statements, Data Integrity (constraints), Rules, Performance Tuning, Query Optimization and Validation issues.
• Excellent experience in migration of data from Oracle, Flat file, Excel to Microsoft SQL Server by using SSIS and DTS utility
• Demonstrated expertise utilizing ETL tools, including SSIS, Data Transformation Services (DTS), ETL package design, and RDBM systems like SQL Servers, Oracle 9i/10g, and DB2.
• Expert in SSIS script transformations using VBScript and scheduling complex SSIS Packages for transferring data manually from multiple data sources to SQL server.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
• Extensive knowledge in design of logical and physical data modeling using Erwin tool and consistency check using DBCC utilities.
• Expert in generating drill down reports, parameterized reports, linked reports, sub reports, filters, charts using SQL Server Reporting Services and MS Excel.
• Experienced in creating Ad-hoc reports, data driven subscription reports by using Report Builder using global variables, expressions and functions and using SSRS and Microsoft Access for the reporting purposes.
• Expert in developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensive experience in Database activities like Data Modeling, Database design, development, database creation and maintenance, performance monitoring and tuning and troubleshooting.
• Highly experienced in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Solid hands on experience with Unix/Linux shell scripting.
• Database monitoring and tuning, application and queries using TKPROF, OEM, STATSPACK and custom scripts.
• Extensiveexperience in tuningcomplex OLTP database with several thousands of concurrent users.

TECHNICAL SKILLS

• MS SQL Server 2008/2005/2000
• SQL Server Integration Services (SSIS)
• SQL Server DTS
• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• Erwin4.x
• Oracle 9i
• TOAD 6.0
• VB6
• Microsoft Products MS Word
• MS Excel
• VSS
• MS Access
• MS Power Point
• T-SQL
• PL-SQL
• HTML
• XML
• C++
• JavaScript
• ODBC
• MS Visio 2003.

PROFESSIONAL EXPERIENCE

Confidential

Sr. Application Engineer

Responsibilities:

• Evaluate, design, implement and maintain simple database applications.
• Assist with system design reviews and software testing.
• Assist with data modeling.
• Provide input on simple and non-complex projects.
• Assist in administering activities related to data planning and development.
• Establish policies and procedures pertaining to the development, management, security, maintenance and utilization of database platforms.
• Provide Database Administrators with support as needed
• Provide training assistance on using database platform, draft training materials, instruction manuals, etc.
• Programming methodologies,
• Implementing vendor packages, supporting, and deploying them is key part of regular job activity.
• Devises or modifies procedures to solve complex problems considering computer equipment capacity and initiations, operating time, and form of desired results.
• Evaluates system needs of financial services departments.
• Develops block diagrams and logic flow charts. Responsible for gathering, validating and documenting business requirements for technology processes or systems.
• Perform other related duties such as Analyzing and troubleshooting SQL statements, code, and database objects
• Involved in performing Extraction, Transformation and Loading using DTS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility.

Confidential, Aurora Road, OH

Sr.SQL Server SSIS/ SSRS Developer

Responsibilities:

• Used SQL Script in writing various tables and generated the sales, Inventory and orders reports using Crystal reports.
• Created views to facilitate easy user interface implementation. Created Triggers to the base tables. Develop and modify database objects in accordance with gathered requirements.
• Played an active role during the requirements gathering, analyzing and designing of the system.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Created horizontal partitioning of data for different file groups.
• Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports using Crystal Reports.
• Configured and trained users to use Crystal Reports 9.0 version.
• Create parameterized Crystal Reports using Charts, Cross-Tab, Sub-report
• Responsible to support the issues with reports on the crystal enterprise environments (Development, UAT, Test and Production).
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes. Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs.
• Wrote MDX expressions to create name sets and calculated members Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.

Confidential, Orange, California

SQL Server Developer SSIS/SSRS

Responsibilities:

• Wrote various UNIX Korn and Bourne shell scripts to probe network backbone equipment and provide vital statistics about the availability and responsiveness of the network
• Used DTS jobs for importing data from legacy systems to the current model.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon.
• Involved in performing Extraction, Transformation and Loading using DTS.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility
• Used “SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements. Created interface stored procedures used in SSIS to load/transform data to PMS
• Developed reporting stored procedures used by application developers for displaying reports.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Involved in the support the specific needs of hedge funds, fund-of-funds, private equity funds and registered investment products .
• Plan,Implement and test disaster recovery system, using RMAN and custom written shell scripts. Create and maintain Oracle Data Guard configuration.
• Development and implementation of Backup and Recovery strategies
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Involved as a team member in designing this data model.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent
• Optimized cubes for better query performance.
• Aggregated cube with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Wrote MDX expressions to create name sets and calculated members

Confidential, New York

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Developed and created logical and physical database architecture using ERWIN.
• Transformed complex business logic into Database design and maintaining it by using SQL objects like Stored Procedures, User Defined Functions, Views, T-SQL Scripting and Jobs.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Created SSIS packages to import data from MS Access, Excel to SQL 2005
• Filtered bad data from legacy system using Derived column, Lookups, Fuzzy Lookups, Conditional split.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using BCP in staging database from MS Access, excel.
• Responsible for patches for the operating system, building startup shell scripts, managing the automation of CRON jobs and managing file systems
• Developed scripts to migrate data and the database objects to/from multiple sources.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Created effective functions, appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Maintained the physical database by monitoring performance, integrity and optimize SQL queries for maximum efficiency using SQL Profiler.
• Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).
• Built different types of chart reports using SSRS for the business requirement like column chart, Pie Charts.
• Created SQL Server Integration Service (SSIS) packages between enterprise databases and Third party data source to transfer data.
• Migrated data from different data sources.
• Created SSIS package to automate maintenance, database back up, update statistics, re-build indexes as well as create error log for event during data load.
• Responsible for the creation and the maintenance of Analysis Services objects such as cubes, dimensions and MDX queries.
• Created report Model on SSAS Cubes as well as changing default configuration on existing Cubes.
• Configured replication servers and transactional replication between production and standby server for high availability / disaster recovery.
• Actively involved in gathering and analyzing stakeholders requirements.

Confidential, Oaks, PA

SQL Server SSAS/SSIS Developer

Responsibilities:

• Our team is responsible in building and maintaining interface packages' build on SSIS to transform periodic transactional feed to DSS system (Data Warehouse).
• Enhanced PMS data model to in corporate new reporting on SEI wealth management system requirements
• Build mapping document to map all the data elements from SEI wealth management system to PMS.
• Created interface stored procedures used in SSIS to load/transform data to PMS
• Developed reporting stored procedures used by application developers for displaying reports.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
• Involved in the support the specific needs of hedge funds, fund-of-funds, private equity funds and registered investment products
• Responsible for performance tuning of stored procedures using SQL Profiler and Database tuning wizard.
• Created and schedule SSIS packages to load the data form SEI wealth management system to PMS data staging environment and then to PMS live environment.
• Responsible for the creation of reports/cubes using SQL Server 2005 Reporting Services and Analysis Services
• Performed operating system and database performance monitoring and tuning.
• Tested and analyzed relational and OLAP data
• Implemented proper business and IT constraints during each transformation within SSIS environment container and logging them to error and control total tables to ensure accuracy and consistency.
• Enforced different business constrains and rules using triggers and check constraint.
• Build packages for data reconciliation between SEI wealth management system and PMS and logging them for auditing purposes.
• Set up Transactional REPLICATION to transmit changes for multiple Subscribers.

Confidential, Chicago, IL

MS SQL Server SSAS/SSIS/SSRS Developer

Responsibilities:

• Participated in developing logical model and implementing requirements on SQL Server 2000.
• Created the database for the reporting team.
• Data Migration from Oracle Database and flat files into SQL Server 2000 using DTS Packages and BCP.
• Solved T-SQL performance issues using Query Analyzer.
• Created and managed schema objects such as Tables, Views, Indexes, Procedures and Triggers.
• Created Backup and Restore operations for migrating database from one server to another.
• Created Database Triggers to implement business requirements.
• Created complex Stored Procedures and Functions to support the front-end application.
• Optimized SQL queries for improved Performance and availability.
• 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.
• Ensured Data Recovery, Maintenance and space requirements for physical Database.
• Reorganize database structures as needed, automate procedures at regular intervals.
• Optimized long running Stored Procedures & Queries for effective data retrieval.

Confidential

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in requirements gathering, analysis, design, development, change management,
• Developed backup restore scripts for SQL Server as needed.
• Upgraded to latest version from SQL server 7.0 to 2000.
• Written various stored procedures for the purpose of application development.
• Tuned SQL statements (Using Indexes) and Stored Procedures.
• Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
• Disaster recovery and database maintenance plan.
• Replication of data using Transactional method.
• Data conversion from Text File into SQL Server Table.
• Created constraints and validated database integrity.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Designed and implemented user log in and security.
• Extracted Data from MS Access and Oracle.
• Created many complex Stored Procedures / Functions and used them in Matrix Reports.
• Creating reports and hosting it in thewebfor the users.
• Created reports for the senior management.
• Involved in java coding with java developers
• Tested successfully all store procedures on SQL 2000 server