SUMMARY

• 5+ Years of extensive experience in data warehouse complete life cycle using SQL Server 2005, SQL server 2008 suite of products SSIS, SSAS and SSRS
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration
• Experience in writing complex Stored Procedures, Indexed views and triggers for data consistency and manipulation.
• Experience in using tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Hands on experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Experience in Developing application security process creating users/groups, security profiles and application filters.
• Good knowledge on Normalization and De-Normalization techniques.
• Strong understanding of finance module and loan center application. Performed dynamic calculations, developed, reviewed, and optimized queries in SQL Server.
• Extensive SQL Development experience in a Banking & Healthcare environment & Financial with a strong understanding of data & analytics.
• Good Knowledge in creating cubes and dimensions, handling multi dimensional reports.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) (2000) and SQL Server Integration Services (SSIS) (2008/2005).
• Worked with writing the ETL process to implement the hybrid data environment using SSIS and custom query.
• Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Strong ability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2008/2005
• Skilled in sorting the data and defining subtotals for the reports.
• Good Knowledge in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization and Tuning.
• Good Knowledge in Kalido tool for Master Data Management.
• Experience in Documenting Existing Process, Creating and Analyzing Business Requirements, Functional and Technical Documents.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.
• Self-motivated, diligent with the ability to quickly adapt to new environments and changes

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, C++, VB 6.0, HTML, XML, Java, .Net

Databases: SQL Server 2000/2005/2008/ R2, Oracle 9i/8.x, DB2, MS Access, OLTP,OLAP, SQL Server Management studio (SSMS), SQL Profiler, Bulk Copy Program (BCP)

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services)

Other Software: MS Office- 2010/2007/2003 , Adobe Professional

Operating Systems: Windows / 98/2000/2003/ XP/Vista/7

Database Tools: SQL Plus, TOAD

Methodologies: Logical and Physical Database Design, UML

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server/BI Developer

Responsibilities:

• Actively participated in gathering Business Requirements and System Specification from system users.
• Implementation of MS SQL Server Management studio 2008 to create Complex Stored Procedures using T-SQL to evaluate result for the reports.
• Developed different Scripts for the Data analysts for verification of reports.
• Responsible for performing T-SQL tuning and optimizing queries for reports which take longer time in execution with SQL Server 2008.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Utilized Pivot tables to provide structure to Reports in proper format like months etc.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert for ETL purposes.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Created master ETL packages which include various packages in them and scheduled them to execute based on the given requirement time.
• Developed SSIS Packages to Consolidate date from various data Sources and also Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted xl to sql reporting .
• Involved in writing MDX queries for cubes in Business Intelligence Development Studio (BIDS), deploying them on the server.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose .
• Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports
• Modified the current database by removing unwanted columns and also adding proper constraints, rules and defaults to tables
• Created Indexes on tables for new database to faster retrieval of data for the Reports.
• Responsible for deploying reports to Report Manager and Troubleshooting for any error occurring in execution
• Used SSRS 2008 to create customized reports and ad hoc reports.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also emailing them to director and analysts to be reviewed in Excel Sheet.
• Generated DTS packages to schedule migration for old system data to a new system and verify by making different reports on new system
• Converting all existing DTS package old system to new system by adding extra SSIS task.
• Develop backup & restore scripts for SQL Server as needed
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Developed, monitored and deployed SSIS packages.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Maintained the physical database by monitoring performance, integrity and optimized SQL queries for maximum efficiency using SQL Profiler.
• Involved in all stages of the project life cycle, from Requirements Analysis through Design, Development, Testing & Implementation.

Confidential, Charlotte, NC

SQL Server BI Developer

Responsibilities:

• Created several prototypes using MS Access.
• Developed several data mapping (DB2 to SQL Server 2005) documents and data mining (SSIS transformation) documents.
• Created several ABI Reporting databases, tables and stored procedures using SQL Server 2005.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Created and managed Clustered indexes and Non Clustered indexes and optimized queries using execution plan
• Used various transforms in SSIS to load data from flat files, Siebel CRM and FTP to the SQL databases.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Developed reports for payment and BI Count to show organizational and seasonal comparison.
• Created several SSIS jobs and packages and executed those tasks.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Developed DTS packages to extract, transform and load into the Campaign database from OLTP database using SQL Server 2005 Integration Services (SSIS).
• Creation and scheduling of Maintenance plans (database and log backups and cleanups), DTS to SISS package conversions. Business Intelligence package design. Created tables and performed data imports and restores for successful migration.
• Loading data to the destination base tables.
• Involved in Data scrubbing/Cleansing/validating/Translating, and scheduling SSIS packages
• Developed windows schedule tasks for different data pulls and directly populate data to SQL Server by creating several ODBC connections.
• Transformed data from various data sources using OLE DB connection by creating various DTS /SSIS packages.
• Installed and Configured SQL Server 2005 and also Upgraded the existing database to SQL Server 2005.
• Created several test cases and involved in system testing.
• Built SSIS Packages for Processing cubes and Dimensions.
• Created Tabular and Matrix reports using SSRS.
• Responsible to provide production support to the client.

Confidential, WA

SQL Server Developer

Responsibilities:

• Created schema modification scripts to implement the logical design into SQL Server 2005
• Responsible for ODS production support and helpdesk.
• Participated in the migration of ODS from SQL Server 2000 to SQL Server 2005 and in converting DTS packages to SISS package.
• Transferred data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert for ETL purposes.
• Involved in the troubleshooting of Database performance issues and implementing necessary DB changes.
• Responsible for developing reporting stored procedures and ad hoc reports using Crystal Reports.
• Responsible for creating Test Cases, Test Plans and Release Notes.
• Developed, tested and implemented robust Disaster Recovery Plan.
• Planning and scheduling backup strategy to ensure reliable backup.
• Developed DTS packages to load policy feeds onto ODS.
• Responsible for developing and maintaining ODS run book
• Performed performance analysis, troubleshooting, and tuning for databases at client site.
• Worked in importing and cleansing of data from various sources like DB2, Oracle, flat files onto SQL Server 2005 with high volume data using SQL server integration services (SSIS).
• Tuning the Performance of Database (SQL Profiler), Query Optimization and Application tuning, Determining and Tuning the I/O and Memory Utilization, Replication Environment Configuration.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services.
• Developed several stored proc to handle large amount of data manipulation.

Confidential, Chattanooga, Tennessee

SQL Server (SSIS/SSRS)Developer

Responsibilities:

• Create Database objects including Tables, Triggers, Views, Stored Procedures, Data Modeling, Indexes and Rule.
• Created new Databases and maintained existing User / System Databases. Involved in Logical/Physical design of database and maintenance.
• Set Database access privileges for different Users and User Groups.
• Perform optimization of SQL queries in SQL Server.
• Import Data from MS-Access Database and XML to SQL Server Database.
• Maintenance of Clustered and non-Clustered Indexes.
• Create jobs and monitor job history for maximum availability of data and to ensure consistency of the databases.
• Create DTS Packages in SQL Server Database.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Perform database consistency checks at regular intervals.
• Monitor SQL Server activity through profiler.
• Develop backup & restore scripts for SQL Server as needed.
• Design and implementation of database maintenance plan
• Performance optimization and normalization of database
• Tuning and optimizing queries and indexes.
• Job, Scheduling, batch, alert and E-mail notification setting.
• Monitor SQL Server log files.