SUMMARY:

• Over eight years of IT experience developing client/server and object - oriented applications utilizing GUI, RDBMS, business analysis, database design and technical support.
• Design, development and deployment of large software applications in both Client/Server and Web Server Environment.
• Comprehensive knowledge and experience in Writing SQL*PLUS scripts, PL/SQL Programs (Packages, Procedures, Oracle Objects and dB Triggers) and SQL * LOADER scripts.
• Hands on experience in creating database objects such as Tables, Indexes, Views, Indexed Views, Stored Procedures, Triggers, Cursors.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS, DTS, Bulk Insert, XML).
• Experience in Cube Optimization Techniques such as Cube Partitioning, Aggregation Wizard, Defining Hierarchies as well as usage based optimization
• Experience in implementing Calculated Members, Key Performance Indicators (KPIs), translations, perspective, and roles.
• Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).
• Experience in creating Drill down, linked, sub cascading Reports and Reports with Parameters using SSRS.
• Created Reports in SSRS with different type of properties like Chart controls, filters, Interactive sorting, SQL parameters etc.
• Demonstrated strong knowledge in performing various kinds of data analysis in Excel. Strong knowledge in building macros and extending the flexibility by adding functionally in VBA, Expertise in developing several reports and graphical solutions in identifying the hidden patterns and trends for various scenarios in organizational data.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Implemented Business Intelligence dashboards using MOSS 2007 Report Center and Excel Services producing different summary results based on user view and role membership.
• Created Calculator program using C# .net for personal knowledge.

TECHNICAL SKILLS:

Microsoft Technologies: SSIS, SSAS, SSRS (2005 & 2008), MS Power BI

Databases: MS SQL Server, Oracle 10G, MS Access

Software: SQL Server Business Intelligence Development Studio

Query Languages: T-SQL, MDX

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Support users for SSRS reports and SQL reports.
• Designed developed and maintained SSRS reports and excel data connection reports and reports’ subscriptions. (email and data driven subscriptions)
• Maintained and monitored users and reports usage on network
• Created SSIS packages to extract data from JDE and send SQL reports automatically into user folders on network.
• Monitored numbers of SSIS packages on daily, weekly and monthly basis as well trouble shoots the errors on packages.
• Created powershell scripts to split pdf reports (using pdf splitting application) from SSRS and distribute reports to user folders on network, based on the report subscriptions.
• Analyzed data for new online application.
• Created Impromptu reports and trained users on Impromptu report creation.
• Created Catalogs and defined joins of Impromptu Catalog.
• Assisted overseas team for development and data analysis as well reporting.
• Analyzed and presented data using Power BI and dashboard.

Environment: SQL Server 2000,2008,2012, Visual Studio 2005, 2010, Impromptu 8, Windows Powershell, Power BI.

Confidential, Jersey City, NJ

Developer

Responsibilities:

• Designed the business process flow and data flow models utilized MS Office (PowerPoint, Excel, Visio ) for an insurance firm.
• Assisted SharePoint team for development, utilized designer for forms, lists and workflow process. Also, created roles and granted users.
• Worked on project for a bank to design and develop a window based application for overseas customer and monitor their activity.
• Designed and developed SQL database and its objects (views, store procedures).
• Developed the Audit trigger for CDC.
• Transformed data from legacy to local SQL server with SSIS.
• Developed reports for team and management using SSRS.
• With C# designed and developed front-ends (forms, classes, icons, etc..)
• Designed and developed MS Access (used Macros/VB script) application for internal employee activity.
• Communicated with overseas management team for their requirements and feedback.

Environment: SQL Server 2010, Visual Studio 2010 & 12, MS Office, SharePoint 2010

Confidential, Middletown, NJ

Application Developer

Responsibilities:

• Designed and developed SQL server database and its objects (tables, views, store procedures).
• Created SSIS packages to bring data into SQL Server. (Using containers, derived columns, lookups, SQL Task, Merge, sort, Data conversion and conditional split).
• Written trigger to monitor CDC activity.
• Designed and developed front end with MS Access for end users to input their activity.
• Created SSRS reports for users and on-screen submission of their reports.
• Created pivot table reports for executive.
• Designed and developed MS Access based application for users to query their info and match it legacy system. Developed forms and reports using VB scripting/Macros.

Environment: SQL Server 2010, VB .net 2010, MS Access 2013

Confidential

Analyst/Developer

Roles and Responsibilities

• Designed and run daily reports to find out user error when order was taken by customer service by phone or order entered by customer from online.
• Designed weekly reports to summarize customer service data and online entries.
• Created SQL processes to provide management report on daily basis for daily price updates of parts.
• Created SSIS package and created SQL database to transfer data from Sybase into SQL server for analysis.
• Used Script component of SSIS with C# coding, export data from text file.
• Created auto-updated on daily basis, SSRS reports for management to view parts activity on daily and weekly.
• Analyze the data by month and generate the KPI reports with graph which shows a progress of entire year.
• Did ODBC connections of Sybase and Oracle data within MS Access and SQL server for reporting purpose and deploy the reports on SharePoint.
• Created forms with Macro and VBA in Access for data entry from Parts Administration.
• Configured SharePoint with User privilege for SharePoint List.
• Created custom forms for Sharepoint list using Sharepoint designer.

Environment: Oracle, Sybase, DB2, Sharepoint 2007, SQL Server 2012, MS Access, Sharepoint designer 2007.

Confidential, Piscataway, NJ

Application Developer

Roles and Responsibilities:

• Created a SQL databases to store the history of the contract and Issue Log to track of Issue and incidents.
• Enhanced the logical and physical database design to fit new business requirements, and implemented new design into SQL Server.
• Designed and Developed database objects such as Tables, Stored Procedures, Views, Triggers, and Indexes using T-SQL.
• Filtered and cleansed dirty data from SQL Server 2000 using complex T-SQL statements and implemented various constraints and triggers for data consistency.
• Created front end to display the data using VB.
• Created “Search” criteria to retrieve the history of the data also to modify the data.
• Using OLE/DB connection between MS Access and SQL Server to generate the report by criteria.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS and MS Access using Macros and VBA
• Created Pivot table reports in MS Excel.
• Created users and their roles.
• Extract the data from flat files and excel files and load into SQL database, utilizing SSIS.
• Tested and Debug the applications.

Environment: SQL Server 2005 & 2008, MS Access, VBA, MS Excel, Win XP

Confidential, NY

Business Intelligence/DataWarehouse Developer

Roles and Responsibilities:

• Collect data from multiple spreadsheet or text format and organize the data in date order as well by priority.
• Utilizing ETL tools to bring data from Oracle to SQL server.
• Created staging area model for analysis and upload the data from source using ETL.
• Created bad data file from SSIS, send bad data files to management for confirmation.
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Used C# scripts in Script component of SSIS to export data from flat files.
• Designed and developed SSIS pkg for database maintenance and using SQL agent run SSIS pkg automatically on daily basis to extract data.
• Created cubes and dimension in Analysis service. Defined facts and dimensions tables.
• Map and analyzed cube data with RDBMS database.
• Created calculated members and KPI within cubes.
• Created pivot table reports in Excel services using cube.
• Created canned and ad-hoc Reports using SQL Server Reporting Services with MDX queries.
• Involved in creating, maintaining and partitioning existing cubes for faster performance on both SSAS and SQL server management studio.
• Rendered reports from intermediate format to different formats like HTML, PDF, Excel, and XML.
• Configured SharePoint server for report deployments.
• Created data sources in SharePoint using Performance Point server and SharePoint designer.
• Created External content Type and SharePoint list using designer.
• Configured user level permissions on SharePoint.
• Analyzed and performed Data mapping which involves identifying source data field, identifying target entities and their lookup table id’s, and translation rules.

Environment: SQL Server 2008, BIDS 2008, Toad, SharePoint Server 2010, MS Excel, MS Access, VBA

Confidential, NY

ETL Developer/Data Analyst

Roles and Responsibilities:

• Downloaded the data files from various sites of NY State and prepare them for SSIS package.
• Converted data files into CSV or XLS format and save it on appropriate path.
• Created SSIS packages for performing data cleansing and removing duplicate data using Fuzzy Grouping and Fuzzy Lookup transformations.
• Run the database wizard to migrate 2005 db to 2008. Detach database from 2005 and attach into 2008 in development server.
• Created SSIS packages for the data transformation that included Aggregate, Sort, Lookup, Derived Column and Data Conversion.
• Ran the main SSIS package in the morning to load and refresh the databases in SQL Server.
• Ran the SSAS package to analyze data for reporting purpose.
• Analyze cube data for summary reports.
• Created SSIS packages to load billing data into SSMS which include the Look up and Conditional Splits from multiple files to make one table.
• Developed several reports using SSRS like drill through reports, linked and sub reports as well with MDX queries.
• Designed and developed the reports using Cognos.
• Created Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.
• Created various report in SSRS for management to view daily updates which include the updates in billing and status of a child or family.
• Deployed the reports on SharePoint

Environment: Windows XP, SQL Server 2005, Cognos, MS Access.

Confidential, North Bergen, NJ

Database Developer

Roles and Responsibilities:

• Transformed data from various data sources (SQL Server, Access, Excel and flat files) into SQL Server using OLE DB connection by utilizing ETL process from BIDS.
• Utilizing PL/SQL, Created stored procedures for efficient retrieval and manipulation of data for search engine.
• Created functions and triggers for efficient manipulation of data. Created Database schema. Created tables and normalized and created relationships between the tables.
• Defined defaults and constraints.
• Wrote stored procedures and views as required by the Application Developers.
• Created Indexes and updated the statistics to increase the query performance.
• Tuned the performance of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Scheduled jobs for running DTS packages, and created alerts for error reporting.
• Create SQL Server Database users and roles for database security.
• Involved in testing and fixing the system.
• Designed and developed MS Access application for Invoice using Macro and VBA.

Environment: SQL Server 2005, ODBC, Oracle 10G, Microsoft Visual Studio, Windows XP, MS Access, MS Excel, VBA.

Confidential, Secaucus, NJ

Application Developer/Database Developer

Roles and Responsibilities:

• Created tables and procedures.
• Monitored database.
• Tested and debugged database for problems diagnosis for inserting into tables.
• Developed the frames and modules to insert, update delete and to find the records from database using MS Access with VB scripting.
• Synchronized the data into current application. Transformed data from various data sources using OLE DB / MS Access connection by creating various DTS packages.
• Performed daily migration from SQL server to Oracle and Oracle to SQL server.
• Initiated backup the database on daily, weekly and monthly bases.
• Tuned the performance of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created SQL Server Database users and roles for database security.
• Defined constraints, rules and defaults for the tables.
• Created views as per the needs of the developers for easier implementation of the business logic.
• Implemented triggers to provide efficient data manipulation.
• Created complex stored procedures and functions to support efficient data storage and manipulation.
• Implementation and configuration of Siebel, including Gateway and Siebel Enterprise server and Web server.
• Configured .cfg to appropriate requirement.

Environment: s: Windows NT, MS Access 2000, Visual basic, SQL Server, Oracle 8i