Systems Analyst Resume
MO
SUMMARY:
To obtain a Full - time position that provides me with an opportunity to progress in my career with the skills acquired and contribute to the growth of the organization.
TECHNICAL SKILLS:
ERP skills: SAP ECC 6.0- SD, PP, MM, HR, and FI/CO
BI skills: Data Warehouse construction, ETL, Analytics, Reports, SAP BW/BI, Business Explorer, Query Designer, Analyzer, SSRS, SSIS, SSAS
Business Objects: Xcelsius, Crystal Reports, Web intelligence, SAP Mobile Platform, SAP HANA, Desktop Intelligence, SAP NetWeaver, SAP Enterprise Portal, Visual Composer, Web Dynpro
Analytical Tools: SAS Enterpriser Miner 7.1 (Data Mining)
Programming Skills: C, C++, VB 6.0, C# using Visual Studio 2010, ASP.Net, Core Java, HTML, PL/SQL, XML
Databases: MySQL, SQL Server 2010/ 2008/ 2005/ 2000 , MS Access
Operating Systems: Software:
Windows 7, Windows Vista, 98, XP, Linux, DOS: MS Office 2012
PROFESSIONAL EXPERIENCE:
Confidential
Systems Analyst, MO
Responsibilities:
- Gained knowledge on Microsoft Business Intelligence tools (SSIS/SSRS/SSAS)
- Hand on experience in creating packages using SQL Server Integration Services (SSIS) using MS SQL Server BI tool to migrate data between different sources
- Hands on experience in creating reports using SQL Server Reporting Services (SSRS)
- Knowledge in writing stored procedures, T - SQL queries using joins using MS SQL Server 2012/2008R2
- Good exposure on Business Objects reporting tools Universe Designer, Info View, Web Intelligence, Desktop Intelligence and Crystal Reports.
Confidential
Product Assurance Engineer
Responsibilities:
- Followed Agile Development (Scrum) Methodology in the execution of the projects
- Maintained records in Excel Spread Sheet, export data into SQL Server Database and cleaned the data using SQL Server Import and Export Wizard
- Created Tabular Reports, Matrix Reports, and drill down, drill through reports using SSRS.
- Hands on experience in design and development of SSRS Reports in SQL Server 2008
- Created complex Stored Procedure/Functions and used them directly to generate reports
- Generated reports that can handle dynamic grouping and dynamic sorting for the purpose of efficient and clear view of the reports
- Scheduled monthly/weekly/daily reports to run automatically onto the Dashboard for managerial purposes
- Created test cases and performed System Integration Testing on various environments and operating systems and logged the defects in the Change Synergy tool
- Created various artifacts, generated and executed reports for IMS train simulator
- Actively participated in User Acceptance Testing, conducted defect management and defect fixing
- Performed code reviews and Unit testing for the modules based on ADA using Green Hills compiler
