We provide IT Staff Augmentation Services!

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.

Hire Now