Business Analyst IT Resume Troy, MI - Hire IT People

Objective

Detail - oriented professional with 12+ years of experience and a proven knowledge of Commercial and Retail banking.
Aiming to leverage my skills to successfully fill the Senior Business Analyst role.

AREAS OF EXPERTISE

PROFESSIONAL EXPERIENCE

Confidential, Troy, MI

Business Analyst IT

Responsibilities:

Responsible to gather reporting requirements from different business users to land the data and build Data Marts.
Responsible to analyze legacy system data which should be brought into the Data Marts.
Analyze and document the data flow process from source systems to the target systems which includes derived fields with transformation logic required for reporting needs.
Responsible for Functional Requirement Document to list all the technical requirements and business rules required for the project.
Coordinate with the development and modeling team to help them understand the granularity of the elements required by the business and structure the database tables accordingly.
Validate the data flow from source systems into the Data Marts from the source system after the development is completed.
Support testing team in writing test cases
Experience using COTS product such as JIRA to track all the stories, tasks and defects for the SPRINT planning.
Schedule meetings to interact with business users and address their concerns.
Liaison between the business users and EDMA team.
Follow agile methodology to build all the tables in the DataMart.
Responsible to write SQL queries to validate the data between legacy system and the new modernized system.
Knowledge on data modeling, snow flake schema, star schema, SCD(Slowly Changing Dimensions).
Knowledge on Oracle PL/SQL
Knowledge on AML,CDD process and data analysis process.

Confidential, Detroit, MI

Intern

Responsibilities:

Worked on the Data warehousing applications, ETL Packaging and used Cognos tool for Reporting services.
As part of the Operational Risk Team, my contribution was towards standardizing the month end reports by merging the data stored in different excel files into one excel database in order to create dynamic dashboards.
Also, automated most of the manual process by having additional user interface features in the Workbook with backend code written in VBA.
Created Prototypes of user forms in excel to replace manual data entry into the excel worksheets

Confidential

Lead Software Engineer

Responsibilities:

As UNIX developer, worked in the desktop and web-based application project related to taxation.
Contributed towards conversion of the desktop to web-based project by writing new Perl scripts for multiple modules.
Responsible for build and configuration management of the projects.
Responsible for creating new installers for the new products and update the existing ones whenever an upgrade was required for the package using Installshield tool.
Responsible to write scripts to package all the files in required order using Installscript for deployment
Experience using TFS tool for version controlling of the files.
Experience working in the Agile Software methodology life cycle of the project.

Confidential

Senior Software Engineer

Responsibilities:

Maintenance of the existing Security application.
Porting of C++ code to support both 32bit and 64bit Windows Operating Systems.
Was responsible to package the code based on different web servers on different operating systems using UNIX scripts.
Worked on product releases for different OS supporting various web servers like IIS, apache, IHS, SJWS, Domino etc.
Created installers for new releases using InstallShield.