Computer Systems Analyst Resume
2.00/5 (Submit Your Rating)
CAREER OBJECTIVE:
To work in a challenging environment where I can upgrade my knowledge, enhance my skills and thereby working towards the goal of the project.
EXPERIENCE SUMMARY:
- I am a goal - driven IT professional with 7 years of experience in various Microsoft technologies.
- Experience in Design, Development and Testing of BI applications, Windows applications, web applications and console applications.
- Good Knowledge in Airlines Domain, Health Care Domain, Retail Domain and Telecom Domain.
- Excellent troubleshooting techniques and problem-solving skills
- Professional in MS SQL Server and Oracle Relational Databases and expertise automating the existing manual extraction and reports.
- Experience in developing the scripts and stored procedures on sql server to generate the reports as per the requirements.
- Expertise in creating Stored procedures and ETL packages to replicate the data, extract data from source file(s)/database to Destination databases.
- Experience in design & developing the enterprise reports using SSRS - generated the drilldown reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2012/2014.
- Expertise in Version Control Tools like Microsoft TFS, Serena Dimensions and GitHub.
- Experience in creating .net application builds and BI deployments for SIT, UAT and PROD.
- Excellent verbal, written and presentation skills with a strong urge to learn and enhance skill sets.
AREAS/APPLICATIONS:
- Travel Tourism & Hospitality
- Revenue Recognition
- Health Care
- Instance Case Management System
- Retail
- Hazardous Waste Compliance System
- Oracle Forms Migration Application
- Telecom
- Frontier Data Migration
- Broadband Technology Conversion System
- Media & Information Services
- Consolidated Authors Payment System
TECHNICAL SKILLS:
- Windows XP/Vista/7
- C# .net
- J2SE
- Python
- Unix
- HTML
- XML
- SQL Server
- Oracle
- Mongo DB
- SSIS
- SSRS
- Microsoft Visual Studio
- Microsoft Team Foundation Server
- Microsoft SQL Server Management Studio
- Business Intelligence Development Studio / SSDT
- IPMS
- PL/SQL Developer
CAREER PROFILE:
Confidential
Computer Systems Analyst
Responsibilities:
- Participating in Product Backlog meetings to understand the requirement and analysing the same against the existing system to see how the new requirement can fit in and doing the impact analysis to figure out what all components must be changed.
- Analysing the requirements and developing the system as per the design.
- Implementing the solution as per the approach document and agile development Methodology.
- Preparing implementation strategy for implementation of the programs. Dividing and coordinating the work between various teams per the implementation strategy.
- Preparing Data models, Use Case diagrams, Process flow diagrams, whatever is applicable per the requirement.
- Develop Stored procedures and ETL packages to replicate the data, extract data from source file(s)/database to Destination databases.
- Design & Develop the enterprise reports using SSRS - generated the drilldown reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2012/2014.
- Develop dashboards, ad-hoc reports, data driven subscription reports using report builder in SSRS.
- Unit testing of developed APIs, execution and verification of the test results. To carry out Localization testing per TCS Localization methods during the application roll out across different locales.
- Assisting the client in User Acceptance Testing (UAT), getting bug reports from the client and co-coordinating with development and QA teams for bug fixes and bug fixes releases and getting the UAT clearance.
Confidential, Honolulu, HI
Computer Systems Analyst
Responsibilities:
- Review of Business and IT Requirements
- Analysis and documentation of requirements with Business
- Providing the Low-Level Design and Estimation for upcoming Projects and Enhancements.
- Conducting design reviews and to arrive at design patterns/solutions and reviewing artifacts created by peer team members.
- Coding the programs to meet the business specifications.
- Ensuring process compliance to CMM guidelines - Make sure all the Coding, Testing and Documentation processes are developed as per TCS and Client quality standards.
- Unit testing and Integration testing of the Client and the Server.
- Design and development of validation tools.
- Collection and setting up of Test Data.
- Communication with offshore team through daily status calls.
- Resolution of critical issues through defect triage calls.
- Demonstrations to UAT Clients highlighting the new functionalities and tools developed.
- Status reporting to the project management.
- Delivery of Quality products on time to the clients by effective monitoring.
- Root Cause analysis of defects and Documentation of ‘Critical issues and lessons learnt’ during the release
Confidential, Louisville, KY
Computer Systems Analyst
Responsibilities:
- Create and deliver a design document for the data dictionaries and record layouts for each application in the IT stack and deliver the document in Microsoft Word format.
- Provide unsynchronized data extracts in flat files, following layouts defined by the customer.
- Provide 1st synchronized data extracts in flat files, following layouts defined by the customer.
- Provide 2nd synchronized data extracts in flat files, following layouts defined by the customer.
- Develop data queries and Code scripts required for service migration of Confidential retained customers.
- Develop application code enhancements required to remove logic or s for sold regions.
- Develop the ssrs reports as per the business requirements.
- Load the data from the source systems using SSIS packages.
Confidential, Temple Terrace, FL
Web Developer
Responsibilities:
- Interacting with clients/Stakeholders to gather project requirements.
- Developing code for windows application and web application UI screens using Microsoft .Net Framework 4.5.
- Preparing high-level and low-level design document for the application screens.
- Analyzing the problems and providing the permanent fixes for user identified problems and live fixes
- Coordinate with expert groups for special support.
- Implementation Support and Support plan.
Confidential, Littleton, Colorado
Solution Developer
Responsibilities:
- Attend the transition sessions conducted by Thomson Reuter’s associates and give the play back sessions.
- Create stored procedures to load the data from different tables using Sql Server 2008 and SSIS packages.
- Create the reports using SSRS and Crystal reports as per the client requirements.
- Implementation support and support plan.
