Summary

Over 8 years of IT experience in Confidential system analysis, design, development, testing and implementation of projects in Finance, Unclaimed Property other Financial Systems. Decent experience as a software developer doing SQL analysis across various database systems. Sound knowledge of Data Warehouses and ETL/OLAP processes. Good command of MS Word, Excel Using Pivot tables, excels macros MS Access. Excellent at communicating with stakeholders and upper management to provide accurate reporting and information regarding the ongoing projects and initiatives. Well organized strong work ethics and willingness to work hard to achieve employer objectives, a strong team player. Can run the extra mile to finish the job on time and can quickly adapt to any/aggressive environments. Seeking to work on a challenging position to utilize my Skills and abilities in IT Industry that offers professional growth and effectively contribute towards the growth of the Organization.

Strengths

• Testing responsibilities included creating and modifying test cases, record and analyzing test results.
• Expertise in designing and implementing relational databases.
• Good team-player with outstanding interpersonal and leadership skills and extremely quality conscience.
• Outstanding communication skills demonstrated background working well with clients and co-workers in one-on-one and group settings.
• Work experience mainly on Windows XP / 2003 / NT
• Strong knowledge in predictive Modeling methods like Linear Regression and Logistic Regression other Multivariate Techniques and possess good knowledge of tools like SAS and SPSS
• Software Testing , Creating Test Scripts, Access Reports Developer, Application Developer or QA Analyst
• Expertise in handling SQL queries and optimizing them in Oracle, SQL Server, MS Access and Teradata.
• Sound experience in programming in VB.NET VB.NET, SQL Server 2000/2005, SSIS 2012/2008r2
• Sound Relational Database concepts and extensively worked with SQL Server Ms-Access

Professional Skills

Professional Experience Performed for several clients on various projects:

SQL Data Solutions

Confidential

• Execution of database queries and business processes against sensitive data to support customer needs using SQL/MySQL.
• Triage incoming support tickets and identify appropriate actions.
• Determine which business processes must be followed depending upon the request of the ticket.
• Work with business stakeholders with approval workflows.
• Work with a team for guidance and support when necessary.
• Document and communicate support issues clearly to our internal/external customers.
• Create/run various Ad-Hoc queries for data analysis across databases on production server.
• Logging and tracking day to day issues per ticketing.

SQL Analyst Confidential

• Created data mappings in Data Warehouse and designed a site map for approval from executive management.
• Load data using ETL process dealing with different data sources MS Excel, MS Access and SQL Server, CSV, Flat Files etc. into target database by performing different kinds of transformations using SQL Server Agent to automate the SSIS 2012/2008r2 package execution. Tested and managed the SSIS 2012 packages.
• Create database objects such as tables, views, stored procedures, Triggers etc. for Analysis.
• Day to day processing external files from Clients, using ETL some using Legacy DTS Packages for some transfer of data between servers in a SQL Server 2000/2005/2008 environments
• Performed analysis, detailed specifications, SQL database analysis and disaster recovery, technical and end-user documentation, host communications interface design and performed on-line and batch testing of production support.
• Used MS Access database for MBS reporting and in testing for data manipulation.
• Ensured different internal external systems exchanged data according to the specification to transform data from enterprise data warehouse to SQL Server load data to fact tables.
• Performed SQL Backup and Restore tasks on Various SQL Servers.
• Involved in extracting the data from OLTP to OLAP using SSIS.
• Current Audit Exception reports requirements has been updated to automate and produce the Weekly Reports and sent to the specified users groups
• Refine quantitative methods to Analyze, cleanse, transform, manage and validate data, exploring and uncovering relationships through data Analysis.
• Deployed Reports for Internal, Departmental Executive Reporting based on the requirements using SQL Server Reporting Services 2012/2008r2. Maintained Report Manager and Reporting Server for SSRS to manage routine report production for clients.
• Been the Lead Contact since 2009 at the Semi-Annual external Audit on site visits at the NY location. Performed walkthroughs with External Auditors for SSAE 16 II Audit of reporting on the system for purposes of complying with internal control over financial reporting. Successfully completed the type II level examination type I confirming steps to evaluate the operating effectiveness of the controls for six consecutive calendar months.
• Financial reconciliation for various Corporate Mutual Fund Issuers with our TA clients.
• Fund Merger/Corporate Action analysis for client within our portfolio as it relates to Inventory.
• Create/run various Ad-Hoc projects and queries for our Executive Management Board using on SQL/Access per requirements. Created Macros for Overlays reports using efficient data retrieval techniques with successful testing.
• Participate in discussions review meetings involving the application creation to understand the requirements and provide the back-end functionality for the applications also, provide input into Business Requirements and Technical Design
• Troubleshooting Supporting Operations with the existing MSCRM Application used internally. Provided advanced data source view mostly for data quality analysis and business analysis utilizing these data warehouses, Client/Server application development and implementation.
• Involved in Migration process NY process to PA process , interacting with the team for Testing, coordinating, Documenting training on the existing NY processes. Travelled to PA to Train Data Analysts/ Business Analysts / Relationship Managers for the above on some tools processes.
• Undertaken detailed analysis of sample data provided by customers in order to develop project specifications, map account data to internal systems, undertake test conversions, and forecast resource requirements.

Confidential

Software Developer at Equiseach Services

• Processed external files from Clients using ETL process. Worked on the initial conversion for an ETL process integrating financial data on an ongoing daily basis.
• Designed and implemented tables, Created Indexes, Stored Procedures, Functions, Triggers and DTS Packages to transfer data between servers in a SQL Server 2000/2005 environment.
• Used SQL Server Agent to automate the SSIS 2008r2 package execution. Tested and managed the SSIS packages.
• Reviewed developer SQL code to ensure adherence to client standards and general best coding practices.
• Define design data sourcing to build the data source views and flows for data mining.
• Maintained the CR change Request of the company. Created Test plans, Test case, and Test scripts to test systems for data corruption, SQL errors. Documented bugs and feature request.
• Involved in the on-site Audit and did walkthroughs with the External Auditors for the SAS 70 Type II Audit in 2007 2008.
• Coordinating with the IT teams of Various Transfer Agents in order to understand the business needs and setting up objects accordingly.
• Trouble shooting Supporting Equisearch Users with the Equisearch Services Internal Application. Worked closely with Accounting, Sales Research departments to determine business rules for a smooth flow of business as usual
• Identified and added the report parameters and created the reports based on the Business requirements Client requirements using SSRS 2008r2. Configured and maintained Report Manager and Report Server for SSRS.

Confidential

Software Developer at Berlitz International

Confidential is a company that works as a source needed for effective language instruction, whether for business or personal enrichment.

• Involved in Designing Development using C interface for LDAP database using Novell Netware .Net technology.
• Developed Scripts for replicating the data from Sybase Database to SQL Server Database.
• Worked with the Onsite/Offshore model.
• Worked on DTS Packages. Performed SQL Backup and Restore tasks on Various SQL Servers.
• Involved in designing developing the site using Microsoft Content Management 2001.

Environment and Tools:

Microsoft Content Management 2001, Visual Studio.Net, .Net Framework1.1, C , LDAP, ADO.Net, SQLServer2000, Crystal Reports for VS.Net, MS SQL Server, MS Access, HTML, JavaScript.

Confidential

Software Developer Tester at Prudential

Unit testing and Integration testing of application

• Worked on the Infoline Resume Maker windows based application for the company's HR department to store the resumes, details of the candidate, etc. Using VB.NET, SQL Server 2000

Software Programmer at Prudential

• Created Base Classes, Objects and Front-End.
• Worked on Approval System basically an Online Approval System, Containing Child Systems like Leave Management System, Attendance Approval, Desktop Shift, Conference Rooms, etc.
• Implemented Concepts in Classes using VB.NET, ADO.NET

Programmer Analyst

• This project TDS Tax Deduction Service was developed as a part of my VB.Net curriculum.
• This was an automation work done for the Firm and the transports business logic was implemented.
• Generated reports if the values of the State government's deducted values are in the nut shell.

Jr. System Administrator at Prudential

• Creating new user login/password changing passport and updating passwords every 3 months.
• Performance of recurring operational tasks related to the support of an enterprise infrastructure, including, LANS, WANS, routers, servers and workstations. Included tasks such as system loads, data backup and restoration, startups, shutdowns software installation. Shutting down and restarting PeopleSoft system Application Server, Database Server Web Server .
• Worked PL SQL,UNIX environment
• Cleaning up cache files for system performance.
• Administering access control to data sets and applications, and provide authorization of user IDs, accounts, etc. assistance/support, request management knowledge maintenance.

Developer Training Documentation Specialist

Confidential

Jr. Developer at Contacts

Confidential Investigate, Study, design and develop Cheque Issue System Stock Control System according to Client requirements

• Used Oracle 6.0 with Forms 3.0, Reports1.1/2.0 PL SQL,UNIX environment
• Perform Unit Integration Testing, Implementation Documentation User manuals .

Jr. Programmer

Confidential