SUMMARY:

• Over 15 years of IT experience in collecting requirements, analysis, designing, and developing software applications for major Confidential 500 companies and reputed clients.
• Demonstrated success and leadership in Systems and Data Architecture, Design, Product development, Programming, Enhancements, Data Analysis and System Testing.
• Extensive Database Programming writing Transact - SQL Scripts, Business Intelligence tools viz., SSAS & SSIS Packages, Stored Procedures and Triggers, Data Analysis and Data Reporting. and exposure to Data Warehousing tool Informatica, and experienced working in Reporting Tools such as Business Objects and crystal reports and SQL Server Business Intelligence Tool SSRS.
• Expertise in Microsoft SQL Server, Visual Basic, MS Excel, VBA, MS Access, Sybase, Oracle, ActiveX technology, VB Script, Crystal Reports & Business Objects.
• Extensive interaction with the Users, gathering requirements, Specifications, modifications and analyzing business to provide alternative solutions.
• Participated in the Data Architecture during the Design phase of the SDLC. Involved in various phases of the project including gathering requirements from end users to designing the logical design of the ER Model and developing the Physical databases in the RDBMS, defining Attributes, Entities and Relationships between them. Designed and created the DataFlow Diagrams and the flow of process on how the data gets from sources to the destination databases.
• Excellent communication, interpersonal, Leadership & People skills.

TECHNICAL SKILLS:

Operating Systems: Windows 98, 2000, Windows 7 Windows XP, Unix, MS-DOS.

RDBMS: Microsoft SQLSERVER 2012,MS.SQL SERVER 2008R2, MS-SQLServer 2005, MS-SQL Server 2000, ORACLE 9.0, MSDE 2000(SQL Server Desktop Engine), Sybase, and MS-Access 95, 97, 2000, 2002, 2007

Programming Languages/Tools: Visual Basic 6.0, MS Excel 2007, VBA, Crystal Reports, Business Objects, SQL, TSQL, PLSQL, PowerPoint.

Internet Technologies/Web Servers: VB Script, Java Script, ASP 3.0, HTML 4.0, ActiveX, IIS 4.0, MS-Visual Interdev 6.0

S/S: Microsoft certified professional. Querying Microsoft SQL Server 2012 .

PROFESSIONAL EXPERIENCE:

Confidential, Piscataway, NJ

Senior SQL Server and Business Intelligence Developer

Responsibilities:

• Coded several Stored Procedures and Several TSQL Scripts that provide as data sources for Reporting applications.
• Developed and enhanced several SSIS Packages for Incremental Loads and Full loads extracting data from Oracle and other SQL Server Databases.
• Coded several User Functions, scalar and table valued for code reusability.
• Implemented ETLC Logging, which enables logging of SSIS Packages runtime for easier trouble shooting and knowing which process/task took how much time and what tasks failed and what completed successfully.
• Implemented SQL Server and Environment Variable Configurations for portability across servers.
• Worked on their Data warehouse, developing SSIS Packages extracting data from Oracle Databases.
• Files and documents have been created and saved on Sharepoint Locations for easy distribution.

Environment: SQL Server 2008, Business Intelligence Studio 2008 R2, Perforce 2012, Oracle 11, Toad.

Confidential, Queens, NY

ETL and SQL Developer

Responsibilities:

• Created Mappings between Source systems and Target System based on the existing systems and new requirements.
• Created Tables/Entities with constraints and defaults and established entity relationships between them.
• Developed SSIS Packages that does Incremental loading of data from Oracle Source system Accela.
• Coded WebService tasks that calls Webservice for GEO Coding Addresses. Created XML Tasks that manipulate the XML Files using XSLT and loaded data from XML Source into SQL Server.
• Coded Stored Procedures using TSQL that processes the data and loads into destination system.

Environment: SQL Server 2012, Business Intelligence Studio 2005 R2, Team Foundation Server (TFS), Oracle 11, SQL Developer.

Confidential, Livingston, NJ

Senior Database Developer and ETL developer

Responsibilities:

• Developed SSIS Packages that bring in source data from varied sources such as XML Files, Excel Files, Flat Files and Other RDBMS such as SQL Server databases into the working SQL Server Staging database.
• Developed SSIS Packages that Processes the source data brought into Staging Database using Mappings provided and populate the Actimize Database based on the Actimize requirements.
• Written extensive DDL and DML SQL Scripts that Create, Update, Query and validate the data, performed thorough data analysis to analyze data brought in. Did Data validation and troubleshooting to identify erroneous data.
• Created Schemas and SQL Server Tables using Table Partitioning that hold the staging data and other Meta Data related to the packages.
• Created XML Configuration Files for the SSIS Packages and implemented SQLServer and Text File Logging for audit/ Tracking purposes.
• Written and altered Stored Procedures, User Functions and Database Views as per the requirements.
• Written SSIS Script Tasks using Microsoft Visual Basic and Written Technical Design Documentation.
• Created SQL Agent Jobs that runs the SSIS Packages using a Proxy Account and in UAT and PROD Environments Control M jobs are setup that call the SQL Server Agent Jobs.

Environment: SQL Server2008R2, Business Intelligence - SQL Server 2008R2 SSIS, TSQL, MS Excel 2012, Visual Source Safe, Microsoft Visual Studio 2008

Confidential, Jersey City, NJ

IT Consultant

Responsibilities:

• Maintained and enhanced and built New SQL Server SSIS Packages to suit the changing requirements of the Users.
• Created Database Tables and written Sql Scripts to populate the data. Done extensive Data Reconciliation between the SQL Server and Oracle Applications by writing Complex SQL Queries.
• Set up various Control M Jobs and Provided Production Support making sure the Jobs ran fine that bring in data from other sources and run the processes.
• Helped in the conversion of Stored procedures from SQL Server to Oracle and also assisted in analysis of the current processes that need to be migrated.
• Studied the current SQL Server SSIS Packages to understand the ETL processes, worked on their enhancements and Data Reconciliation between the systems.

Environment: SQL Server 2005, SQL Server2008, Business Intelligence - SQL Server Integration Services (SSIS), TSQL, MS Excel 2010 Oracle PL/SQL, Control M, PL/SQL & SQL Developer IDE.

Confidential, NewYork, NY

SQL Server/BI Developer

Responsibilities:

• Worked at this Financial Client in their Investment Banking Division on their Banking applications, Analytics and Client Information warehouse related projects, Institutional Client Group applications etc.
• Extensively developed New SSIS Packages to ETL the data from varied sources into the databases. Revamped, Upgraded and Maintained their current SSIS Packages to accommodate new requirements or optimize the existing.
• Created and worked on various SQL Server Jobs that execute the SSIS Packages and provided support when in production.
• Helped in their SSRS requests and modified current Reports to enhance the Reports as per the users’ new requirements and also modify the Stored Procedures to bring in new data fields to the reports.
• Written various SQL Scripts and Stored procedures and created other database objects such as Tables, Views, Functions, and worked on various databases.
• Submitted various Change management requests using the Code Promotion Tool from Development to UAT to Production to migrate database objects across environments.
• Done quite a lot of data analysis using SSAS/Cubes, data cleansing, data reporting, data migration(ETL).
• Provided production support and provided quick troubleshooting and fixes to the jobs when failed.

Environment: SQL Server 2005, SQL Server2008, Business Intelligence - SQL Server Integration Services (SSIS), SSRS, SSAS, MS. Access 2007, VBA 6.5, VB Script, TSQL, MS Excel 2010.

Confidential

DataMart/Business Intelligence Specialist

Responsibilities:

• Converted SQL Server 2000 Analysis Services Databases/Cubes to MS. SQL Server 2005 Analysis services databases/Cubes using SSAS. Maintainance of SQL Server 2005 SSAS Cubes.
• Modifed and Maintained various SQL Server 2000 DTS Packages as per users requirements.
• Provided Production support to several job streams that do ETL processing and Cube processing in SQL Server 2005 and trouble shooting failed jobs and resolving issues. Set up automated jobs for new job streams.
• Developed Datasource Views, Dimensions and OLAP Cubes from the DataMart's dimension tables and Fact Tables and provided users with access to the cube data via reports in Excel.
• Created and modified and Maintained various SSIS packages that Extract Transform and Load from varied sources such as flat files, Access Databases, and Datawarehouse into SQL Server DataMarts.
• Created SQL Server Agent jobs that are scheduled nightly and sends out notifications to users on the status.
• Written SQL Queries and Scripts and Analysis of Table Objects and structures to migrate 2000 Objects to 2005.
• Generated Reports using SSRS and Cognos Reporting Studio as per user’s requirements.

Environment: SQL Server 2005, Business Intelligence - SQL Server Integration Services (SSIS), SSRS, SSAS, MS. Access 2007, TSQL, MS Excel 2010.

Confidential

Datawarehoue/ETL Developer/SQL Developer

Responsibilities:

• Written several SQL scripts to process the source data using TSQL statments such as DDL, DML statements, creating indexes, writing cursors etc.
• Linked servers have been configured and used for Data Migration from other database servers.
• Extensively used the SSIS (Sql Server Integrating Services) Business Intelligence Tool in SQL Server to create SSIS packages that would Extract, transform and load the data from the data warehouse repository and manipulate data using Data flow tasks, sql tasks, filesystem tasks etc. Part of the Data comes from the source systems and data in the additional data elements is populated based on the new business logic and joining multiple source tables.
• Stored Procedures & Views have been created to hide complexity from users and easy access to data .
• Once the data is ready the DOE reports are compared with State reports by calculating the variances and data inconsistencies are reported and fixed in the source systems on a weekly basis. Extensively written Transact SQL Statements to extract manipulate and update the data both using Script files and Stored Procedures. Data included Student demographic Data, Student Enrollment Data, and Student Exams/Tests Data etc. Once the final data is ready it is ftped onto a mainframe where the reports are generated and schools verify its accuracy.
• Using SQL Server Analysis Services (SSAS), past data from the Department's Data Warehouse has been analyzed. Using the OLAP data from past periods schools and students participation and performance data has been analyzed and compared. Using BIDS SSAS Projects have been created, data sources have been connected, creating data source views and defining cubes for data analysis purposes using OLAP and Datamining functionality of SQL Server BI tools.
• Created various adhoc reports for the Management using SSRS. Extensive data analysis was done to find data inconsistencies. Written VBA scripts to automate the file system tasks and worked on Flat File Transformations. Weekly Jobs have been scheduled using Sql Server Agent. The Project has been successfully implemented meeting the deadlines set.

Environment: SQL Server 2005, Business Intelligence - SQL Server Integration Services (SSIS), SSRS, SSAS, MS. Access 2007, VBA 6.5, VB Script, TSQL, MS Excel 2007.

Confidential

Database/SQL Developer cum Data Analyst

Responsibilities:

• Normalized Databases have been designed and developed from specifications to logical model to Physical Model. Databases have been created with SQL Server 2005 as the RDBMS. Tables and relationships have been designed and created to suit the data requirements.
• Written & executed several Transact SQL Scripts for regular data maintenance on SQL Server. Stored Procedures and User defined functions have been extensively coded and several Views with multiple table joins have been created for users to query and view the data by hiding the complexity. Triggers have been written to enforce data integrity.
• Using SQL Server Integration services (SSIS) and DTS data has been transferred from other several sources such as XML, Excel, Text, and other relational databases into the SQL Server Database and SSIS packages have been created to automate the data transfers through SQL Server Jobs. Several Jobs have been set up through the SQL Server Agent that are scheduled to run as nightly jobs. Using Linked servers data from other databases has been accessed, manipulated and populated into the current database.
• Several Business Objects reports have been created from Universes and scheduled the BO reports to automate delivery to email inboxes for daily data updates and data reporting needs from other sources.
• Developed several Reports using SSRS(Sql Server Reporting Services) in the Business Intelligence Development Studio environment. Liased with Project Management and Others department members to identify requirements to improve overall functionality and access of information to business users.
• Extensively used SSAS functionality for OLAP services. From the department Datawarehouse created Data sources and Data Source Views and cubes for generating the dimensional models that were deployed.
• Separately designed and developed a robust MS Access 2002 Application with Custom User Interfaces as Forms for Business Users ease to accessing SQL Server data and Reports without much assistance. In MS Access created several Tables, Forms, Reports, Macros and several VB Modules have been written to code the functionality. Tables from SQL Server have been linked into the Access Application to facilitate application distribution & data accessibility. With the design of the tables to change at times in SQL Server, implemented a unique functionality in the MS Access Application such that the tables are automatically refreshed by automatically relinking every time the user opens the Application rather than the user having to manually refresh the table links anytime a table design is modified.
• Also enhanced application functionality by automatically distributing new MS Access Database objects without having to distribute the main application again. To optimize performance several methods have been enforced such as setting up Indexes for quick data retrieval and using truncate statements for faster deletion of records. Done quite a bit of Windows Scripting(WSH) using VB Script for many adhoc tasks.
• Written numerous SQL Queries with inner/outer joins, written SQL Scripts coding Cursors for row by row manipulation of data, Create, Update and Delete Data Manipulation Statements etc. Aided in the development of disaster recovery plans for all data services via periodical backups. Documented system specifications and various other processes for future knowledge transfer. Been a frontline support of daily data procuring & processing jobs and for maintaining the data integrity and data reporting.

Environment: SQL Server 2005, SSIS, SSRS, SQL Server 2000, MS. Access 2002, VBA 6.5, VB Script, TSQL, Business Objects XI R2 Webi, MS Excel 2002.

Confidential

Data Analyst

Responsibilities:

• Data analysis, data cleansing, fixing their data inconsistencies, massaging the data and writing scripts to migrate the data onto Oracle. After the conversion to have their current systems run interim until all the functionality is available in the web based system, Oracle data has been downloaded back from the web based system into their Ms. Access by re-mapping.
• XML Format data has been imported into Access from the web application. Also created various reports in Crystal Reports accessing Oracle DBMS via stored procedures and also helped the users in their adhoc queries and reports. Developed an intensive Child Adoption Statistics Access database application for their immediate data tracking needs involving designing Relational Tables, Input Screens, Reports and setting up sql queries to retrieve data.
• Responsibilities included Developing SQL Scripts, Designing and Developing the Database Application, Writing Testing Scripts and performing rigorous Unit Testing to suit the users needs. Written stored procedures in Pl Sql for reporting purposes and written sql statements and PL sql blocks to query and update data in Oracle.

Environment: MS. Access 2002, VBA, Oracle 9.0, Toad, PL Sql, Crystal Reports, MS Excel 2002.