SUMMARY:

• Over 10 years of IT experience in Software development life cycle: system analysis, design, development, testing and implementation of projects in Finance, Unclaimed Property & other Financial Systems.
• Experience as a software developer & Analyst doing SQL analysis across various database systems.
• Sound knowledge of Data Warehouses and ETL/OLAP processes.
• Familiarity with SalesForce, other CRM Software, and in - house workflow management tools.
• Good command of MySQL, MS SQL, MS Access, Visio, Word, Excel Using Pivot tables, Excels macros &. Excellent at communicating with stakeholders and upper management to provide accurate reporting and information regarding the ongoing projects and initiatives.
• Ability to translate business requirements into defined tasks and technical specifications.
• 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:
• Project Coordination
• Analytical Skills: Data analysis on large amounts of data: facts, figures, and number crunching to see through the data and analyze it to find conclusions.
• Communication Skills: Present findings, or translate the data into an understandable document, write and speak clearly, easily communicating complex ideas.
• Critical Thinking: Analysis by looking at the numbers, trends, and data and come to new conclusions based on the findings.
• Strong Attention to Detail: Making sure data is precise & I'm vigilant in my analysis to come to correct conclusions.
• Math Skills: Decent Math skills to estimate numerical data.
• Understanding of processes flows and workflows, Process Lifecycle Management.
• 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.
• 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 MS SQL Server, MS Access, MySQL

TECHNICAL SKILLS:

Operating Systems: Windows Server 2008 R2, Windows 8/7, Enterprise, DOS, Windows NT/2000/2003/XP/98, UNIX

Languages: VB.NET, .NET Framework, Visual Basic 6, VBA, Asp.Net, SQL Server 2000, HTML, XML & PeopleTools7.5

Databases: Microsoft SQL Server 2000/2005/2008/2008 R2/2012, MS Access, MySQL, SAP Hana

Platforms/Tools: UNIX, Visual Studio.NET 2003 & SQL Server, ETL, SSIS 2012, Tableau

Hardware Platforms: IBM compatible PC s

PROFESSIONAL EXPERIENCE:

Confidential - Santa Clara, CA

Analyst - Data & Business Analyst

Responsibilities:

• Demonstrated Program Manager’s role in medium projects from collecting requirements to presenting Mock-Ups, preparing project schedules and working together with Scrum Master to ensure deliverables within each sprint is successful.
• As a Project Coordinator, Collaborated with offshore teams to ensure requirements were reflected & coordinated multi-organizational projects
• Responsible for updating the issue tracking and project management application, JIRA for BIM Services. Learning Agile methodology used by JIRA.
• Collaborate with business and technical stakeholders to understand requirements to create concise, cohesive, and comprehensive requirements documents.
• Managed and facilitated requirements gathering sessions with businessand IT stakeholders resulting in moderated, orderly, and efficient meeting to Identify and define business needs.
• Created sequence/process flows, Mock-ups and use cases documenting functional (FRDs) and system requirements (SRDs) & define business metrics so the team starts development phase ahead of schedule.
• Basic Data mining included: Execute data queries, analyze & compile data across multiple data sources in support of BI reporting needs, research the root cause then communicate the resulting insights with clarity for necessary actions on next steps.
• Ad hoc request to run reports and create Tableau dashboards to monitor the validity of data for POC.

Confidential - Holland, MI

Business Systems Analyst

Responsibilities:

• Actively involved in the Lawson upgrade with custom interface that needs to be migrated & test the data for a better Business process.
• Preparing with the Documentations and inventory needed to build complete solutions that include:

Confidential - Palo Alto, CA

Analyst - Data & Business /Developer DBAr

Responsibilities:

• Provide analytical support to Client by leveraging data mining tools & provide statistical analysis on products and operations to the organization through research, modeling and data mining.
• Created new tables, indexes, views, triggers, and user defined functions.
• Performed development of the T-SQL stored procedures, SQL reports and scheduled jobs, DTS for data migration jobs using ETL process.
• Provide support on ad-hoc requirements pertaining to Data Analysis using SQL queries & MS Access applications.

Confidential - Santa Clara, CA

Sr. Data/Business Analyst

Responsibilities:

• Executed database queries of business processes against sensitive data to support customer needs using MySQL/Access/Salesforce/SAP Hana & Data Services.
• As an Application Support analyst worked on incoming Service-Now tickets & was responsible to support, identify & triage incoming tickets appropriately.
• Determine which business processes must be followed depending upon the request of tickets/Incidents.
• Logging and tracking day to day issues per ticketing then document and communicate support issues clearly to our internal/external customers both on Business and System side.
• Worked with a team for guidance and support to provide any administrative or Data Quality support when necessary.
• Created & executed various ad-hoc queries for data analysis across databases on production server.
• Pro-actively collected datasets from various business stakeholders and manage the data.
• Performed Data Analysis to identify gaps & anomalies within the Data Set for the Data Quality team, SAP Hana team (BI), Revenue Reconciliation & the On-boarding/Off-Boarding teams since December 2014 using MySQL/Access/SAP Hana.
• Implemented Data changes systematically & sometimes manual
• Worked as a Business Analyst & Project Coordinator on the On-Boarding/Off-Boarding process interacting with business stakeholders for approval workflows, following Agile Scrum Methodology & updating necessary tracking system to ensure that project status is maintained with complete accuracy & coordinated those accordingly with HR/Facilities/Security teams & Participated in planning and testing of HRIS version updates.
• Communicated issues to my Project Managers on critical issues & status before creating/ distributing correspondence relevant to the business teams & OO project team.
• Worked closely with PMs/Developers on tracking/reporting while supporting the PAS system to define scope and requirements for system changes to be implemented by IT.
• Collaborated with Client Services team to ensure the collected information is sufficient for the Active Directory migration and provided data entry to support management ensuring accurate tracking & status of data collection.
• Worked on Data Services by creating jobs per ad-hoc requests from the SAP Hana team.
• Analyzed huge datasets for Waterfall comparison & Prepared Revenue reconciliation reports to support the Revenue Reconciliation project (FICO team) on a BI-weekly basis from Jan - Aug 2015.

Confidential - NYC, NY

SQL Developer & Business/ Data Analyst - Production Support

Responsibilities:

• 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 SQL Server 2000/2005/2008/2008 R2/2012.
• Supported marketing teams with marketing systems & 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.
• Worked on CRM Software, and in-house workflow management tools & creating rules.
• Designed over 20 reports to help quickly identify potential fraud and data errors resulting in 1M in saved revenue. Improved report function and automation cutting the processing time by over 40%
• 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.
• Created data mappings in Data Warehouse and designed a site map for approval from executive management.
• Created Hive Tables & loaded data into HDFS using AWS (Amazon Web Service) for a test run.
• Performed SQL Backup and Restore tasks on Various SQL Servers.
• Audit & Exception reports requirements were updated to automate and produce the Weekly Reports and sent to the specified users groups.
• Deployed Reports for Internal, Departmental & Executive Reporting based on the requirements using SQL Server Reporting Services 2012/2008r2. Maintained Report Manager and Reporting Server.
• 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 & 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 - White Plains, NY

Software Developer

Responsibilities:

• 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.
• Processed external files from Clients using ETL process.
• Supported marketing teams with marketing systems & performed analysis, detailed specifications, SQL database analysis and disaster recovery.
• 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 Confidential Users with the Confidential 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.

Confidential - Princeton, NJ

Software Developer

Responsibilities:

• 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

Jr. Developer & Tester

Responsibilities:

• Content testing experience & understanding of basic software testing processes and terminologies.
• Prepared and execute Test Cases & test web services and windows applications.
• Provide high quality testing and clear and concise feedback to development team.
• Log bugs and issues using tracking software.
• Work Confidential the test plan to provide feedback on overall usability.
• Explore new technologies and their application & Research solutions independently and solve problems.
• 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

Confidential

Programmer Analyst

Responsibilities:

• 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.

Confidential

Jr. System Administrator

Responsibilities:

• Creating new user login/password & changing passport and updating passwords every 3 months.
• Performance of recurring operational tasks related to the support of 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.

Confidential

Developer & & Documentation Specialist

Responsibilities:

• Prepared course material for worked on AP, AR and Base benefits modules
• Assisted students in completing their projects
• Troubleshoot Application Engine programs such as ARUPDATE, PAYMENT PREDICTOR etc.
• Involved in the payment module using SQR for AP, AR, GL, AM and PO modules
• Assisted with user manual and testing documentation for unit testing and integration testing.
• Development of the systems using Data Designer, Panel Designer and Menu Designer.
• People Tools, Windows NT Built in reports provided for viewing this information in the formats required by the users using
• Transferred the system and data from the development database to test database using Application Upgrader and Import Manager.

Confidential

Jr. Developer

Responsibilities:

• Investigate, Study, design and develop Cheque Issue System (CIS) & Stock Control System (SCS) 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).

Confidential

Jr. Programmer

Responsibilities:

• Involved in System Development of Computerizing the administrative function in the areas of Payroll, Loans, Leave Monitoring, Time Sheet Management, other Employee administrative tasks using Oracle 6.0 as back end on SCO UNIX and Forms 3.0, Reports and PLSQL.
• Performed system testing.