Business Intelligence Analyst Resume

SUMMARY

Professional experience of analyzing data, performing requirement gathering for ETL development and BI reporting in Fortune 500 Global IT and Consulting Company.
Profuse working experience with database integration, SQL for data extraction, MS Office and Excel report design.
Acquired practical knowledge of Data Visualization and Database/Statistical concepts, while pursuing Masters in Information Systems in Business Analytics from University of Texas, Arlington.
Conversant with Agile and SDLC methodologies, through the breadth of work experience with multiple project clients related to Banking Finance and Telecom.
Successfully involved in project management, designing, developing and implementing data - driven solutions to support in Project operations
Instrumental in Project Coordination in gathering essential information from meetings or documents, performing various administrative tasks and sending information summarized to upper management.
Effectively administered business services, script, enterprise application integration, enterprise information management, workflows and customer relationship management.
Perceived internship training and gained working experience as Analyst with one of the India’s leading software product development and services company.

TECHNICAL SKILLS

Programming language: SQL, T-SQL, Java, HTML5, CSS, Hive, Spark, Pig, Flume, Python, R

Data Management: Oracle 10g/11g, MS SQL Server, MS Excel, Hadoop, ETL

Reporting & Visualization: MSBI (SSIS, SSAS, SSRS), Tableau, Crystal Reports

Business Modeling Tools: MS Visio, Star UML

Other Tools: Oracle SQL Developer, Toad, MS Office, Outlook, MS Project, Visual Studio 2015, Eclipse, Informatica PowerCenter, IBM Bluemix, Jupyter Notebook, Anaconda, R studio

PROFESSIONAL EXPERIENCE

Business Intelligence Analyst

Confidential

Responsibilities:

Create, maintain and define ETL specifications and troubleshoot data movement and transformation challenges of loading data
Documented the plans for data collection, cleansing and creating mapping specifications for use by ETL development team.
Maintained SQL server database through which the inventory was maintained, and reports were developed with Tableau and advanced Excel functions including Pivot tables, V - Lookups.

Software Engineering Analyst

Confidential

Responsibilities:

Extensively worked on ETL process consisting of data transformation, data sourcing, mapping, conversion and loading.
Developed mappings that perform Extraction, Transformation and load of source data into target using various power center transformations to meet business logics in the mapping
Gained proficiency in writing queries and converting the ETL mappings into SQL.
Gathered requirements from business subject matter users and IT teams for implementing the Data Warehouse.
Monitored report orientation and structures with the use of advanced Excel functions including Pivot Tables, V-Lookups.
Developed mappings that perform Extraction, Transformation and load of source data into target using various power center transformations to meet business logics in the mapping.
Assisted in building the ETL source to Target specification documents by understanding the business requirements.
Performance tuning was performed at the Mapping level as well as the Database level to increase the data throughput.
Worked with relationship database models, schemas & entity-relationship diagrams (ERDs)
Involved in preparing Unit test plans and providing assistance to the testing and production support team in resolving errors.
Reduced number of incidences raised by client by providing L2 level support.
Organized knowledge sharing sessions for technical understanding among team members.

Task: ETL, Informatica, Excel, SSRS, Data Reports, SQL, Data Analysis, Test Plans, Unix, Agile

Intern

Confidential

Responsibilities:

Analyzed the user requirements and translating them into system requirements and functional requirements
Created ER schema diagram, tables, integrity constraints using MySQL.
Created Use Case Diagrams, Activity Diagrams, and Sequence Diagrams in MS Visio.
Performed manual front-end testing to check all functionalities of different modules.

Task: SRS, Test Plan, Use Case, Activity Diagrams, Java, SQL, MS Visio.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship