SUMMARY

• 7 + years of experience in IT industry as a SQL Developer.
• Around 7+ years experience in database design and development on MS SQL 2005/2008 based Database Objects and Microsoft SQL server Business Intelligence applications (SSIS/SSAS/SSRS).
• Excellent knowledge in RDBMS concepts and constructs along with database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers in T - SQL.
• Well versed in defining Data sources for creating Data Source views.
• Strong experience in developing SSIS Reports. Developed Standard Reports, Sub Reports, Cross Tab Reports, Drill down Reports, Used various Charts and graphs like Bar Chart, Line graphs, Pie Charts.
• Experienced in data loads, database integration/conversations, performance tuning and optimization.
• Experienced in Data Modeling Relational, Multi-Dimensional Modeling and involved in creation of Star Schema and Snowflake dimensional schema.
• Proven ability in Performance Tuning, Query Optimization and running Database.
• Worked on administrative tasks such as data loading, batch jobs, data unloading, backup and Recovery, user and application table management, upgrades, creating databases/File groups/files/Transaction logs.
• Expert in ETL, Data warehousing & OLAP Technology.
• Expert in using tools such as Bulk copy (BCP) and Data Transformation Service (DTS) and SSIS with SQL server 2000/2005.
• Design and developed SSIS (ETL) and SSAS (OLAP) MDX developing components.
• Hands on experience in implementing and consuming web services.
• Proficient in creating SQL server report, handling sub reports and defining query for generating drill down reports using SSRS 2005/2008.
• Experienced in creating SSIS and DTS packages for ETL purposes.
• Extracted and transferred source data from different databases like OLEDB providers like DB2, MS Access, Flat File, Excel, Oracle and Automate the ETL.
• Provided technical support to internal developer and meet standards of Client.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possesses strong analytical skills.

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

MS SQL Server/SSIS Developer

Responsibilities:

• Designed high level ETL architecture for overall data transfer from the source server to the destination server which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Developed SSIS Packages to load Confidential GROUP INSURANCE load data into database and flat file using SSMS 2008 R2 and BIDS 2008.
• Responsible for creating SSIS package which extract data to single flat file from different data-source.
• Created Log Files so that in case of Package failures the errors could be troubleshooted.
• Responsible for maintaining and scheduling Packages.
• Helped design and implement processes for deploying, upgrading, managing, archiving and extracting data for reporting.
• Migrate / redevelop Data Transformation Services (DTS 2000) packages to SSIS 2005/2008 for server enhancement.
• Designed ETL architecture for overall data transfer from source server to the enterprise services warehouse.
• Created SSIS packages to load customer information from flat file.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, data dictionary and Metadata using SSIS.
• Have a very Good Experience with all the Control Flow and Data Flow tasks in SSIS.
• Worked with financial systems team members to document systems and process environments.
• Created Technical and Functional documents including detailed description and screenshots showing functioning of the package.
• Administered SQL Server security, SQL server automatic e-mail notification and SQL Server backup strategy and automation.
• Responsible for elevating and automating successful code to production environment

Environment: MS SQL Server 2005/2008, MS SQL Integration Services 2005/2008, Reporting Services(SSRS), Analysis Services(SSAS), DTS,XML, HTML, MS Visio, MS Access 2003, VB.Net, MS Excel, Window XP, MS word, Oracle 8i/9i.

Confidential, Bronx, NY

MS SQL Server/ BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
• Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2008.
• Wrote SQL scripts to Insert/Update and Delete data in MS SQL database.
• Involved in table and index partitioning for performance and Manageability.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization
• Involved in migrating databases from MS SQL server 2005 to MS SQL server 2008.
• Created schemas, views, stored procedures, Triggers and functions for Data Migration.
• Created complex and dynamic SSIS 2008 (ETL) packages and used Analysis Services (SSAS) processing task to update the cube with current data.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created the ETL (SSIS) packages and scheduled them.
• Modifying scripts to handle automated Loading/Extraction and Transformation (ETL) of data using (SSIS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Database and Billing Systems.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases.
• Wrote SQL queries and stored procedures to generate data for reports.
• Deployed and configured the reports in the Report Server.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Created and Implemented triggers in T-SQL to facilitate consistent data integrity of the database.
• Created Non-Clustered indexes to improve query performance and query optimization.

Environment: MS SQL Server 2005/2008, C# MS SQL Server Integration/Reporting Services 2005, WSSF.

Confidential, Portland, Oregon

MS SQL Server/SSIS Developer

Responsibilities:

• Developed complex stored procedures and macros in T-SQL.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
• Reviewed and fine-tuned stored procedures and macros before production migration.
• Created various Database Objects - Tables, Indexes, Views, and Roles
• Created, optimized, reviewed, and executed Teradata SQL queries to validate transformation rules used in source to target mappings/source views, and to verify data in target tables.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Actively involved in creating / managing Alerts, Operators and Jobs through SQL Server Agent.
• Fine-tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005/2008, Teradata SQL Assistant, Oracle 9i, MS SQL Analysis Services 2005/2008, MS Excel, Visual Studio 2005/2008, VZAI Reporting Tool, ERWIN

Confidential

MS SQL Server Developer

Responsibilities:

• Created Database Objects in TSQL - Tables, Indexes, Views, and Roles.
• Created Customized Stored Procedures, Triggers, and Cursors.
• Involved in job scheduling using MS SQL server Agent.
• Prepare and set up environment for Disaster recovery.
• Transformation of data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS).
• Data conversions from legacy systems to SQL server Using DTS.
• Wrote DTS scripts for data transfer.
• Responsibilities also included transferring of customer, personal financial history information from various ODBC driver files to SQL server database files using DTS.
• Performed Data transfer (Import & Export) using BCP.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using Execution Plan.
• Generated Daily, Weekly and Monthly reports for the analysis of managers and end users.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Designed and created views for security purposes, implemented rules, defaults, and user defined data types.
• Designed index, statistics and optimized queries by using execution plan for performance tuning of the database.

Environment: MS SQL Server 2005, XML, T-SQL, Stored Procedures, C