Bi Developer And Consultant Resume
OBJECTIVE:
To be the fulcrum in your effort to lift the organization
PROFESSIONAL SUMMARY:
Worked in an environment where I had to be BI developer and consultant along with other tasks like administering windows and Linux server, Database maintenance and Network trouble shooting. Flexible and versatile in adapting to any new environment with a strong desire to keep pace with latest technologies. Excellent problem solving, communication, analytical, interpersonal skills and ability to perform independently or as part of a team.
TECHNICAL SKILLS:
Operating Systems: Linux( Centos & Redhat 6 Ubuntu10.10),Windows 2003,2008, XP,7
Application Servers: Microstrategy 10.10, Axpert, Informatica Power Centre, Power BI
Languages: C, C++, Java, PHP,HTML,CSS, R
Databases: Oracle 10g, MYSQL, Vertica, Netezza
PROFESSIONAL EXPERIENCE:
Confidential
BI developer and consultantResponsibilities:
- Designs and develops integrated solutions to meet business requirements or enhance performance.
- Provides escalated technical support to customers by handling systems - related issues; may provide on-call technical support telephonically and/or electronically.
- Analyzes and resolves program support deficiencies and conducts testing to enhance performance.
- Gather, describe and prioritize requirements with client business stakeholders
- Provides technical consultation on current and proposed systems to other organizations and clients.
- Work with Users to create MicroStrategy Reports to meet user requirement
- Performs repairs, maintenance and upgrades of existing systems using solutions in accordance with standard operating procedures. Investigates and resolves matters of significance.
- Provides work guidance to less experienced personnel.
- Guiding end user to develop Dossiers
- Managing MicroStrategy Server
- Perform Administration Activity
- Work on enterprise Manager and command manager
- Perform Upgrade Task
Confidential
BI developer and consultantResponsibilities:
- Interaction with business users for requirements and FRS Documentation .
- Creating presentation for Business Users .
- Responsible for translating the Business requirements into technical specifications.
- Trained user community in basic and advanced Visual Insight reporting skill.
- Mock up and prototype the Visualization and Data set Preparation .
- Development and Testing ETL Mapping and Workflow.
- Build schema objects in Microstrategy for adhoc reporting
- Create and maintain dashboards and reports
- Created Facts and different types of attribute using MIcrostrategy Developer
- Created hierarchies, metrics and filters using MicroStrategy Desktop.
- Administration of Microstrategy Environment
- Experience in creation of Advanced Prompts, Transformation metrics and Level Metrics for creating complex reports.
- Creating Dynamic Enterprise Dashboards and Documents.
- Involved in creating different Metrics, Filters and Prompts.
- Created Reports using Consolidations, Custom Groups.
- Formatting Reports using thresholds, Banding, Renaming and Auto Styles.
- Tuning the Microstrategy Environment
- Work on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet Designer and Transformation Designer.
- Development of mappings that perform Extraction, Transformation and load of source data into target tables using Source Qualifier, Aggregator, Filter, Router, Sequence Generator, look up, Rank, Joiner, Expression, SQL, Normalizer and update strategy to meet business logic in the mappings
- Work on Mapplet development when needed.
Confidential
BI developer and consultantResponsibilities:
- Interaction with business users for requirements and FRS Documentation .
- Creating presentation for Business Users .
- Responsible for translating the Business requirements into technical specifications.
- Trained user community in basic and advanced Visual Insight reporting skill.
- Mock up and prototype the Visualization and Data set Preparation .
- Testing of Dimensional and Fact loads by studying the scripts
- Propose New Business Use case for new upsell Strategies by studying the Data availably in the Schema
- Build Story Line in Dashboards to address Churners and revenue impact from them
- Build Story Line in Dashboards for Cross Sell and Upsell Customers
- Work on Statistical Model - Churn and Survival Analysis models
- Create and maintain dashboards and reports
- Created Facts and different types of attribute using MIcrostrategy Developer
- Guide junior Developers
- Created hierarchies, metrics and filters using MicroStrategy Desktop.
- Administration of Microstrategy Environment
- Experience in creation of Advanced Prompts, Transformation metrics and Level Metrics for creating complex reports.
- Involved Design, development and finalize MicroStrategy Reports by creating unit testing and matching to the client requirement
- Creating Dynamic Enterprise Dashboards and Documents.
- Created Cubes for faster and frequently used dashboards.
- Involved in creating different Metrics, Filters and Prompts.
- Created Reports using Consolidations, Custom Groups and Drill Maps.
- Formatting Reports using thresholds, Banding, Renaming and Auto Styles.
- Tuning the Microstrategy Environment
Confidential
BI developer and consultantResponsibilities:
- Involved in interacting with business users for requirements.
- Involved in Informatica mapping development.
- Responsible for translating the Business requirements into technical specifications.
- Trained user community in basic and advanced Visual Insight reporting skill.
- Prepared user documentation for hands on training of end user community. business requirements to create High Level Design document.
- Creates storylines through analysis to identify problems.
- Created Facts and different types of attribute using MIcrostrategy Desktop
- Created Mobile dashboard with transaction service
- Created hierarchies, metrics and filters using MicroStrategy Desktop.
- Experience in creation of Advanced Prompts, Transformation metrics and Level Metrics for creating complex reports.
- Involved Design, development and finalize MicroStrategy Reports by creating unit testing and matching to the client requirement
- Creating Dynamic Enterprise Dashboards and Documents.
- Created Cubes for faster and frequently used dashboards.
- Involved in creating different Metrics, Filters and Prompts.
- Created Reports using Consolidations, Custom Groups and Drill Maps.
- Formatting Reports using thresholds, Banding, Renaming and Auto Styles.
- Designing Reports with color coding using conditional formatting.
- Crated mapping in Power Center for specific business requirement
- Crated workflows using mappings in Power Center for specific business requirement
- Production Support for daily activities
Confidential
BI developer and consultantResponsibilities:
- Created schema objects using MicroStrategy Desktop
- Created Informatic power center mappings and Workflows
- Created Public objects using Microstrategy Desktop
- Worked in Report and Dashboard development
- Worked on Visual insight.
- Worked on Mobile Dashboard Development
- Provided admin support for Microstrategy Projects
- Worked on cubes for faster display of results
Confidential
BI developer and consultantResponsibilities:
- Created schema objects using Microstrategy Desktop
- Created Public objects using Microstrategy Desktop
- Worked with Informatic development team for day today activities
- Worked in Report and Dashboard development
- Provided admin support for Microstrategy Projects
- Involved in Migration of Projects
- Worked in Development of Mobile Dashboards with transaction services.
- Worked with database team for redesigning Database tables to meet reporting requirement
- Worked as a First line of Contact for support work.
- Worked on Upgradation of microstrategy project.
- Worked on documentation of the Project during sign off.
- Provided Production Support.
- Worked with Multiple teems to during configuration of mobile server.
Confidential
BI developer and consultantResponsibilities:
- Created schema objects using Microstrategy Desktop
- Worked with database team for redesigning Database tables to meet reporting requirement
- Created hierarchies, metrics and filters using Microstrategy Desktop.
- Experience in creation of Advanced Prompts, Transformation metrics and Level Metrics for creating complex reports.
- Involved Design, development and finalize Microstrategy Reports by creating unit testing and matching to the client requirement
- Creating Dynamic Enterprise Dashboards and Documents.
- Involved in creating different Metrics, Filters and Prompts.
- Created Reports using Consolidations, Custom Groups and Drill Maps.
- Formatting Reports using thresholds, Banding, Renaming and Auto Styles.
- Designing Reports with color coding using conditional formatting.
- Created user-defined Subtotals using Subtotal editor for Requirements.
Confidential
BI developer and consultantResponsibilities:
- Created Facts and different types attribute using Desktop
- Created hierarchies, metrics and filters using Micro Strategy Desktop.
- Experience in creation of Advanced Prompts, Transformation metrics and Level Metrics for creating complex reports.
- Involved Design, development and finalize Microstrategy Reports by creating unit testing and matching to the client requirement
- Creating Dynamic Enterprise Dashboards and Documents.
- Involved in creating different Metrics, Filters and Prompts.
- Created Reports using Consolidations, Custom Groups and Drill Maps.
- Formatting Reports using thresholds, Banding, Renaming and Auto Styles.
- Creation of link report as per the business requirement.
- Have done the fact extension as the requirement.
- Designing Reports with color coding using conditional formatting.
- Created user-defined Subtotals using Subtotal editor for Requirements.
- Attending weekly client meetings to understand and recommend the business solutions and update of status to the client on a weekly basis.
- Reduced the run time for the reports by monitoring the VLDB properties.
- Report Testing Automation was also done using Bad Boy automation tool
- Gathered requirements for look and feel and data for the Dashboards
- Create Security Roles and provide different MSTR access to different set of users
- Created security roles, schedules, User's and Group's with their desired privileges as per the requirement.
- Involved in creating security filters to end users to access data based on their privileges.
- Experience in VLDB settings and report tuning techniques.
- Have duplicated the project so that we can have a backup
- Create Security Filter to restrict data access from user
- Handling and maintaining Linux and Windows server
- Taken database backups on monthly basis.
- User management in Linux and Windows Environment
- Solved Hardware and software related problem in servers.
- Installation / troubleshooting of various operating systems such as win-98/ XP/ 2003 server and Linux(flavors)
- Installation and Configuration of Oracle 10g Server Software.
- Cloning and database refreshes from Hot / Cold and RMAN Backups.
- Taking Backup of database using Logical (Export & Import), Physical (Hot & Cold) and RMAN Backups
- Worked in Visio and MS Office
- Trained in Six Sigma--Minitab
- Working experience in Sonicwall firewall.
- Trained freshers on Microstrategy.
Confidential
BI developer and consultantResponsibilities:
- Creation Dashboards as per the requirement.
- Creation of Reports to meet the specification.
- Providing support for the Microstrategy projects.
- Creation of forms and reports as the customer requirement.
- Import and Export of Tablespace’s in Oracle.
- Installation of SQL Servers
- Configure Microstrategy software suit at customer location.
- Network and Infrastructure maintenance.
- System administration
- End user training on Microstrategy tool usage.
- Provide onsite support when needed.
- Maintain ISA firewall