Sr. Sql Analyst Resume
Santa Clara, CA
SUMMARY
- Over 8+ 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.
- 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.
- Testing responsibilities included creating and modifying test cases, record and analyzing test results.
- Expertise in designing and implementing relational databases.
- Outstanding communication skills demonstrated background working well with clients and co - workers in one-on-one and group settings.
- Good team-player with outstanding interpersonal and leadership skills and extremely quality conscience.
- Work experience mainly on Windows XP / 2003 / NT.
- Strong knowledge in predictive Modeling methods like Logistic Regression and Liner 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
- Completed 3 months full time in developing Windows-Based Application with Microsoft Visual Basic.Net at the Soft Origin.
- 3 months full time in-house on PeopleSoft - PeopleTools 8.x from (Enterprise Technology Solutions).
- 6 months full time in RDBMS (Microsoft SQL 2000) from NIIT.
- Attended 2 months program in Oracle 7.1, Forms 4.5 at Software Solutions Integrated (SSI).
- 3 years Diploma in Computer Science (Datapro Information Technology).
TECHNICAL SKILLS
Operating Systems: Windows Server 2008 R2, Windows 8, Windows 7, Enterprise, DOS, Windows NT, XP, Windows 2000/2003/XP/98, UNIX.
Languages: ADO.NET, VB.NET, .NET Framework, Visual Basic 6, Asp.Net, VBA SQL Server 2000, HTML/DHTML, XML & PeopleTools 7.5.
Databases: Microsoft SQL Server 2000/2005/2008/2008 R2/2012, MS Access
Platforms Tools: UNIX, Visual Studio.NET 2003/2005 & SQL Server (Enterprise Manager, Query Analyzer), ETL, SSIS 2012
Hardware Platforms: IBM compatible PC s
PROFESSIONAL EXPERIENCE
Confidential, Santa Clara, CA
Sr. SQL Analyst
Responsibilities:
- Execution of database queries and business processes against sensitive data to support customer needs using SQL/MySQL/SAP Hana & Data Services.
- Communicating between Business & System side.
- Triage incoming support tickets and identify appropriate actions.
- Determine which business processes must be followed depending upon the request of the ticket.
- Work with a team for guidance & support when necessary.
- Primarily working on Service-Now Incidents.
- Work with business Stakeholders with approval workflows.
- 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.
Confidential, NYC
SQL Analyst (DBA)
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 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.
- Created data mappings in Data Warehouse and designed a site map for approval from executive management.
- Involved in extracting the data from OLTP to OLAP using SSIS.
- Performed SQL Backup & Restore tasks on Various SQL Servers.
- Current Audit and 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.
- 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.
- 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.
Confidential - White Plains, NY
Software Developer
Responsibilities:
- 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 & maintained Report Manager and Report Server for SSRS.
Confidential - Princeton, NJ
Software Developer
Responsibilities:
- 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 and 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.
Software Developer & Tester
Confidential
Responsibilities:
- 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
- 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
Confidential
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.
Jr. System Administrator
Confidential
Responsibilities:
- 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.
- Prepared course material for worked on AP, AR and Base benefits modules
- Assisted students in completing their projects
- Fix SQR’s Crystal Reports to resolve bugs & Create SQR’s (AR Discount Calculations, Customer back feed, etc.), scripts for testing process and reports using People Tools 6.0/7.5.
- 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.
Jr. Developer
Confidential
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).
- 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.