BI-Business Analyst /Technical System Analyst Resume

SUMMARY

Experience in the Design, Modeling, Development, Implementation and Support of SQL Server
Have extensively worked on writing complex queries, Views, Indexes, packages, stored procedures and functions.
Expertise in implementing full Software Development Life Cycle.
Understanding the Business requirements.
Experience in requirement gathering, analysis, finalizing implementation methodology business analysis, testing, and implementation of projects.
Extensive knowledge in Tuning SQL queries, MSBI (Microsoft Business Intelligence), OBI (Oracle Business Intelligence) and improving the performance of the Database.
Good hands - on knowledge of creating Multidimensional cubes using SSAS(SQL Server Analysis Services)
Used ETL tool SSIS (SQL Server Integration Services) to populate data warehouse from SQL Server OLTP databases and Excel files
Good understanding of design patterns for using SSIS for data warehouse
Used SSRS (SQL Server Reporting Services) to build and deploy reports from OLTP databases and OLAP cubes
Experienced in Creating jobs, SQL Mail, Alerts and scheduling SSIS Package using through automated process.
Good understating of batch jobs and configuration files used for SSIS package which varies by different environment.
Experience in ETL processes involving migrations and in sync processes between two databases.
Provided 24/7 onsite and offsite production support to major banking and financial institutions.
Author of major procedures for Global Plus, IntelliMatch and XSP systems for custody division.
Interface with auditors to provide quarterly user recertification reports and documentation for various systems.
Knowledge of UNIX (IBM/AIX) programming techniques related to the development and implementation of database.
Adaptive to Cloud Strategies based on AWS (Amazon Web Services)
Technical knowledge on EC2, IAM, S3, VPC
Excellent communication &interpersonal skills working within multi-diverse teams.
Hands-on experience in developing application with object-oriented programming language and relational database system.
Excellent interpersonal communication, problem solving, documentation and business analytical skills with an ability to adapt new technology quickly and a strong team player.
Acquired an excellent set of inter-disciplinary skills related to computer applications in business & manufacturing environments, including computer hardware, computer programming, and computing networks.
Demonstrated ability to quickly grasp new concepts, both technical and business related and utilize as needed.

TECHNICAL SKILLS

SQL Server Tools: MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS)

Databases: Microsoft SQL Server 2017, ORACLE 10g, MS Access

Operating System: Windows 10, UNIX(IBM/AIX)

Business/Software Packages: FIS - Global Plus, FIS - Vision Programming, Crystal Reports, MS Office Suite(Word, Excel, Power Point)

Languages: C++, Visual Basic

PROFESSIONAL EXPERIENCE

Confidential

BI-Business Analyst /Technical System Analyst

Responsibilities:

Developed coding for Employee vacation tracking Project in SQL Management studio
Prepare the code for migration to test environments and coordinate the environment builds.
Develop and maintain database design documentation, including database diagrams, data mapping documents, SQL code snippets etc.
Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.
Coordinated with front-end for implementing logic in stored procedures and functions.
Generated Reports using Variables, Expressions and Functions for the reports using SSRS with database as SQL Server.
Created and maintained user, roles, and groups and granted the privileges to users and groups as per the security and privacy requirement.
Worked on scheduled reports using subscriptions in SSRS.

Confidential

Technical System Analyst / SQL Developer

Responsibilities:

Performance and Query tuning of migrated Queries and Stored Procedures.
Managed the team and resolved technical issues faced by the team members.
Studied Access Project and migrated the tables and queries to SQL Server.
Developed queries and stored procedures using SQL server 2012 and managed changes.
Participated in code reviews and process improvement meetings.
Worked on nearly with operational SSRS report with consistent design guidelines.
Designed complex SSRS reports including drill-through, multiple column grouping, dynamic grouping, column and row visibility based on expressions, all with an emphasis on performance.
Creation of data transfer to mine information form excel worksheets to dump into database table for calculations.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship