SUMMARY

• Over 11 years of professional experience with execution, monitoring, reporting, resource balancing and project planning skills with ability to support multiple simultaneous projects in a matrix organizational structure.
• Experience in coordinating, negotiating and motivating internal team, outside vendors and offshore resources in support of timeline and IT project deliverables.
• Expertise in scope control, parallel development and fast tracking to manage the project stream under critical path.
• Over 8 years of Technical experience in development, maintenance and support, mitigating projects.
• Experience in all phases of software development life cycle SDLC from product definition to implementation including requirements and specification writing, design documentation, unit and system testing, optimization and performance analysis, quality assurance, developing prototypes, migrating, administering, security management, production supporting and training the end users on various platforms.
• Well acquainted with session partitioning and performance tuning of sources, targets, mappings and sessions to overcome the bottlenecks in mapping.
• Well appreciated work ethics to meet deadlines in fast - paced environment and function under high pressure with extremely short deadlines without compromising on quality of the deliverables.. Collaborate on multidisciplinary teams - business & technical.
• Diversified experience in implementation of business intelligence and data warehousing solutions in banking, finance, insurance domains and supply chain, sales and marketing sectors.
• Well versed in SAP Business Objects( XI R4, XI R3, XI R2, XI and 6.X) with hands on expertise in desktop intelligence, designer, reporter, web intelligence and Infoview
• Versatile in agile and waterfall development methodologies in project management
• Conducted end user training on SAP Business Objects 4.1 interface.
• Statistical analysis of data related to incidents, requests and changes in HP ALM/ JIRA
• Excellent at communicating with partner representatives to provide accurate reporting, data validations and information regarding the ongoing projects and initiatives including project metrics.
• Manage and support analytical data present in Teradata, Hadoop & AWS
• Tableau experience in Enterprise environment and Tableau administration.
• Troubleshooting advanced demonstration of diagnostic skills across a broad number of technologies and platforms.
• Very good organizational skill and ability to work without supervision to achieve project goals.
• Conducted and organized periodic end user training. Maintained the knowledge link with best practices and processes followed.
• Experience in Data visualization, Data analysis, Design, Development and Optimization of applications, databases, models and data warehousing.
• Tableau hands-on experience in Data Visualization and storytelling.
• Strong communication skills and experience of leading and mentoring medium sized project teams.

TECHNICAL SKILLS

Environment: Business Objects XI R4.1, XIR3,XIR2,6.5(Web Intelligence, Launchpad, Desktop Intelligence, Designer), Crystal reports XI, Xcelsius, Data Services, Active Directory, Oracle 10gSQL* Plus, WindowsXP/ 2008/2003/2000/ NT/98/95, Unix

Databases: Teradata 15.0, Oracle 11g/10g, DB2 8.0/7.0, MS SQL server 2008/12

Other Tools: Hadoop (HDFS, Hive, Pig)

Methodologies: Waterfall, Agile and Scrum

Dashboard Tools: Tableau 8.x, 9.x

Other Reporting Tools: SAP Business Explorer, (BEx) Analyzer, BEx Query Designer, SAP QAAWSLIVE OFFICE, Toad.

ETL Tools: Ab Initio, Informatica 9.1, Informatica Developer (IDQ), Metadata Manager.

Modelling Tools: ERWIN, ER Studio

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

SAP BI Developer/Analyst

Responsibilities:

• Manage, support and guard Bank analytical environment including Teradata, Business Objects, Tableau, Hadoop and AWS applications.
• Performed production support, user communication and training, improving processes and reducing risks.
• Supported project releases, defects and enhancements as the projects rolled through the delivery process.
• Versatile in agile and waterfall development methodologies in project management
• Regularly translated business questions into data analysis reports. Consistently defined new ways to use existing technology to achieve desired business results.
• Worked on complex, Data - driven assignments that require an ability to understand and navigate large data structures, manipulate and cleanse data by developing new ETL or ELT processes.
• Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
• Streamlined the business and technical teams to enforce data governance and compliance policies.
• Extensive experience in deriving data transformation, data lineage and data mapping between source to target systems and validating the same.
• Experience working on Hadoop Distributed file system(HDFS), Spark, Apache Hive, Hadoop Map Reduce framework and other Hadoop Ecosystem Tools.
• Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements translating business/functional requirements in to technical/data element requirements.
• Handle documenting Functional specifications, Business/ Technical requirements, design templates, development standards document, detailed design documents, Test cases, Test results and Production support documents.
• Experience in working with multiple departments/ Business units to solution designs meet short and long term/ future business requirements.
• Involved in gathering the requirements fro reporting from end to end.
• Responsible for analysis of the systems, meeting with end users and business units in order to define the requirements.
• Developed complex Business Objects reports supporting the business intelligence team.
• Develop and upload lineage to the first authoritative source and business metadata within Ab Initio Metadata Hub to identify downstream impacts of data.
• Created, documented and maintained logical and physical database metadata models in compliance with rapid response protocol for continuous upstream data changes.
• Work with lines of businesses to identify Data Quality (DQ) thresholds and requirements to implement within the DQ tool.
• Developed Hive analytical queries to extract business critical information as per the business requirements.
• Experience in migrating data to Hadoop from RDBMS using Sqoop & Kafka.
• Experience in developing HiveQL scripts for Data Analysis and ETL purposes and also extended the default functionality by writing Hive User Defined Functions (UDFs) for data specific processing.
• Exclusive experience in Hadoop and its components like HDFS, Hive, Impala & Beeline.
• Improved the HIVE queries performance by implementing partitioning.
• Experience in AWS platform such as S3, Redshift.
• Create and manage versions of the programs and documents using Github,knowledgelink/sharepoint
• Oversee other lines of business to ensure all data risk management activities are complete and within the assigned timelines.
• Identify and provide process improvements to enterprise tools as needed.
• Provided process improvement recommendations to upper management and the team.
• Managed, documented and performed code review, code walk through Unit Testing, Integration Testing, User Acceptance Testing and Post Production Validation.
• Incorporated custom logging mechanism for tracking metadata errors, resolving all issues and bugs before deploying the application.
• Tableau experience in enterprise environment and tableau administration.
• Ability to connect to different data sources from Tableau, presenting the good visualization of data, different ways of using the filters and parameters.
• Involved in conversion projects, which includes identifying the resources, coding, testing, data validation, documentation and maintenance.
• Worked with business owners to develop project plans, decide timelines for each phase, held meetings to discuss progress, issues and proposed solutions.
• Develop and share technical strategies that provide business process improvement and ensure scalability.
• Responsible for the Governance and Stewardship of Big Data in Cloudera.
• Installed Business Objects, Created repository, users and user groups.
• Involved in performance tuning of reports used indexing strategies.
• Created complex business objects reports using the universes as the main data providers.
• Worked extensively in developing complex canned and ad-hoc reports.
• Create Standard reports using features on Web Intelligence in BO 4.1 LIKE Optional Prompts, Functions, Alerters etc.
• Generated complex reports in Xcelsius per user requirement.

Confidential, Albany, NY

SAP Business Objects Developer/ Analyst

Responsibilities:

• Involved in full project life cycle implementation (requirement gathering to production phase).
• Responsible for interacting with the client, understand & gather both business & technical requirements, design templates, development standard document and detail design documents, testing & troubleshooting.
• Involved in extensive testing of reports during version migration of business objects.
• Involved in performance tuning of business objects reports by tuning the sql
• Involved in the installation of business objects repository, creation of user ids, implementation of security features and management of repository.
• Extensively used Designer to design various universes for different business groups. Created classes, aliases, help text, simple reports and complex reports using cascading prompts, decode objects etc.
• Specified the standards/ best practices for universes like maintaining design consistency. also defined standards for tables, charts etc.
• Test and install executable programs on Unix platforms.
• Developed various Metadata and operational definitions.
• Presented advanced training to the users to enable them to develop ad hoc reports.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.
• Created data quality and traceability documents for each source interface.

Confidential, Stamford, CT

SAP Business Objects Developer/ Analyst

Responsibilities:

• Prepared specification document based on business requirements.
• Developed complex reports, graphs and other data analysis solutions on cutting - edge business intelligence technical platforms(Business Objects).
• Designed, developed and managed business objects universe & reports in both Development and Production environments.
• Worked on business objects version migration XI R2 to XI R3 version.
• Responsible for analyzing, designing, implementing & maintaining complex components of reporting business intelligence information systems that support critical business operations.
• Interacted with business users, business owners, and ETL/database team to determine their business views in developing and modifying universes/reports accordingly.
• Extracted data and developed reports from several disparate data stores.
• Integrated technical and application components to meet business requirements.
• Take regular backup of systems and perform maintenance.
• Intuitively tested and troubleshooted the upgrade to a new environment
• Provided timely support both ongoing and during the integration and acceptance testing phases.
• Published reports to user community through Business Objects Web Intelligence interface.
• Exported the universe and reports between development, test and production environments.
• Involved in extensive testing of reports during development and migration
• Built graphic powerpoint presentation of reports in live office.
• Developed data model, SQL Queries, SQL Query tuning process and Schemas.

Confidential, Baltimore, MD

Business System Analyst, SAP Business Objects Developer

Responsibilities:

• Performed business support responsibilities to include productionmonitornig, file maintenance, ad hoc reporting, and consultation with internal and external users.
• Participated in the implementation stage for Rate Quote Consolidation (RQC) project including Broker Portal and Broker Express.
• Assisted to develop documents and to communicate alternative workarounds for system defects until system solutions can be implemented.
• Gathered business rules and requirements for developing business Objects reports both in DESKI & Web Intelligence from Facets & Rate Quote Consolidation(RQC), its a PEGA based application
• Designed, developed and managed Business Objects universe & WEBI reports in both Development and Production environments.
• Experienced in Facets application to store analytical data that enables fast and easy retrieval, display and grouping of information.
• Familiarized with ClearQuest defect management system.
• Participated in a functional & design specification collaborative meetings.
• Implemented and trained business users on reports.
• Developed Standard Operating Procedures (SOPs) necessary for training associates in various business areas affected by new release prior to implementation.
• Supported production implementation process which including shakedown cycle that are executed to verify that the integration and user acceptance testing environment were correctly configured and that all the basic functionalities for the Broker Portal could be performed.
• Experience in automating the checking of broker licenses in BUCS Database.

Confidential, Columbus, Ohio

Business System Analyst, SAP Business Objects Developer

Responsibilities:

• Designed strategic plan and scope for implementation of multiple projects with various clients simultaneously.
• Developed work - flow charts and diagrams to ensure production team compliance with deadlines.
• Coordinated with systems partners to finalize designs and confirm requirements.
• Performed system testing and supported the end users in User Acceptance Testing
• Consistently met deadlines and requirements for all production work orders.
• Created complex Business Objects reports.