SUMMARY:

• 8 years plus of experience in BI Developer, with full life cycle of project in analysis, design, development and implementation of Business Intelligence solutions using Cognos, QlikView, Tableau and Robotic Process Automation (RPA). Worked as a RPA developer for 3 plus years, where built processes used Automation Anywhere & UIPath, to automate multiple Manual Processes to Robotic for large enterprise clients.
• Hands on experience with Agile (Scrum) software development and Waterfall methodology. Hands on experience in managing robot's workloads using Automation Anywhere & UIPath.
• Worked with mainframe, windows, web application and AS400 system application. End to end process automation using Automation Anywhere & UIPath. Worked closely with Process SME's to prepare Process Definition Document (PDD) & Solution Design Document (SDD) and educated SME's to work with Bots in production. Created different tasks on RPA and Proficient in handling Exceptions in Automation anywhere & UIPath.
• Experience in using various version management tools such as GITHUB. Proficient in developing Use Case Diagrams, Flowcharts, Behaviour Diagrams (sequence diagrams and activity diagrams). Having Good analytical, communication and interpersonal skills.

PROFESSIONAL EXPERIENCE

Confidential, Long Island NY

BI Developer

Responsibilities:

• Knowledge in all phases of SDLC such as Analysis, Design, Development, Integration, Implementation, and Maintenance.
• Modified complexed projects, tested in QA and published them to PROD.
• Worked on AS400 system application to complete the projects.
• Created PDD’s to understand business requirement.
• Fixed all the selector issues with web portals and tested in bits and pieces with a web site. Retested in PRODUCTION because no test data was available in QA test environment.
• Perform unit testing and integration testing before moving it to the PROD environment.
• Created unattended bot, with full life cycle of the project.
• Gather information from SME to understand business requirements, to create PDD. set up trigger in orchestrator.
• Modified SQL queries for the old projects and bring them to live.
• Used RE Framework templet to build the bot.
• Published, schedule and triggers.
• Created assets and run the processes from orchestrator.

Confidential

Automation Anywhere

Responsibilities:

• Worked closely with SME’s to understand business requirements and implemented optimal RPA solutions for the Operations team in delivering their day to day tasks.
• Delivered demos, technical trainings and support for new/existing clients
• Provided business analyst support expertise to Operations team to draft the RFI/RFP and POC stages and halp sales team to draft the RFI/RFP responses.
• Gather information from Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Documents).
• Worked closely with the SME’s and BA’s to analyze and understand the business needs and automate them into highly efficient one.
• Developed and implemented robust code for web applications using Automation Anywhere Tool.
• Used Credential Vault to login to the application and inspected element using Object cloning.
• Collaborated with the team across the organization to deliver robotic process automation solutions in a dynamic environment.
• Used different commands (pdf integration, terminal emulator,) to solve complex problems within the applications.
• Using MS access to structure PDF files from the excel file.
• Used Macro for sorting and filtering the excel columns using Automation Anywhere tool.
• Used Metabots to initialize the bot and fetch variables from the string file rather than directly hard - coding the values.
• Used object cloning and manage window control commands for onboarding the new customers and employers.
• Used Connection string to connect to the database and update them using SQL.
• Perform unit testing and integration testing before moving it to the PROD environment.
• Reading the data from the spreadsheet into the Automation Anywhere tool.
• Error handling is implemented using loops to ensure that the bot delivers reliable solutions for the business.
• Participated and reviewed the SDD and SOP to ensure the efficiency before the delivery.
• To implement, test and integrate the code using Github tool to deliver error free and highly robust.

Environment: Automation Anywhere 11.2,10.5, SQL server, Windows 2010, Excel, HTML, Git and JIRA.

IT Consultant

Confidential

Responsibilities:

• Created bots to implement Robotic Process Automation at Exelon, which automated multiple Manual Processes to Robotic processes in order to automate manual journal entries.
• Worked with Business Teams to create PDD (Process Definition Document) and developed separate SDD (Solution Design Documents).
• Created complexed Bots for Citrix based applications.
• Created bots for sending automate mails collecting log reports and Exception handlings.
• Worked with log file and used Excels as a database.
• Running Scheduling and Triggering the processes from Orchestrator
• Involved in bot deployment and maintenance.
• Resolved UAT and Production issues.
• Worked with onshore and offshore teams to resolved issues with awkward timings
• Assisted in the automation of business requirement using UIPath & Automation Anywhere.
• Collaborated with Business analysts to gather the requirement.
• Assisted in the creation of a new processes and procedures, and suggested improvements to current processes and procedures.

RPA Developer

Confidential

Responsibilities:

• Created bots for sending automate mails collecting log reports and Exception handlings.
• Worked with log file and used Excels as a database.
• Running Scheduling and Triggering the processes from Orchestrator
• Involved in bot deployment and maintenance.
• Resolved UAT and Production issues.
• Worked with onshore and offshore teams to resolved issues with awkward timings.
• Using MS access to structure PDF files from the excel file.
• Used Macro for sorting and filtering the excel columns using Automation Anywhere tool.
• Used Meta bots to initialize the bot and fetch variables from the string file rather than directly hard-coding the values.

Environment: MS Office (Word, Excel), UIPATH Orchestrator, Automation Anywhere & UIPathBI Report Developer Nov 2015 to Jan 2017

Confidential

Responsibilities:

• Developed project documentation, testing materials, training materials, requirements gathering including downstream and upstream interface requirements and adhering to a project management methodology.
• Created repots in QlikView, Qlik Sense and Tableau and Cognos, and has Intermediate level skill in QlikView scripting.
• Designed, analyzed, and developed, coded, tested, debugged and documented programming to satisfy business requirements.
• Collaborated with Business analysts to gather the requirement.
• Interacted with Customers for requirement gathering, effective analysis and provide end-user training and knowledge transfer to SME’s.

Environment: MS Office (Word, Excel), Cognos, QlikView, Qlik Sense and Tableau.

IT Consultant

Confidential

Responsibilities:

• Worked on IBM OpenPages GRC Platform and integrated governance, risk and compliance platform
• Identified, managed, monitored, and analyzed risk across the enterprise in a single, integrated GRC platform (Cognos OpenPages).
• Created reports for Cognos Open pages and implemented them into GRC-Platforms.
• Created TEST Samples in Excel for clients Presentation.
• Created drill-through reports for detail reports, generated Various Reports (List, Crosstab and Chart).
• Created test data by using Enterprise Management, Audit Management, Risk Management, Compliance Management, Policy Management and Financial.
• Uploaded Namespaces and Regenerate the Framework and schemas.
• Consulted and communicated with off shore Team for updates of the projects.

Environment: MS Office (Word, Excel), Cognos, QlikView, Qlik Sense and Tableau.

IT Consultant

Confidential

Responsibilities:

• Developed Dashboards Reports in Cognos 10.2
• Developed Dashboards Reports using QlikView.
• Created Reports in Excel for client needs
• Involved in upgrades, PowerPlay Cubes, and ReportNet reports into Cognos 10.2
• Handled Complex Queries as separate Query Subjects Supported Multiple Languages and Multi currency using Parameter mappings.
• Updated various database changes into the Framework manger model.
• Designed and jobs to fine tune the metadata and built complex packages using various tool options.
• Built Metadata models using Framework Manager and Dimensional Modeling. Created Reporting requirement Document which contains information about Reporting structure.

Environment: MS Office (Word, Excel), Cognos and QlikView.

Confidential, MA

Responsibilities:

• Gatheird Requirements by participating in various user level meetings migrate all the Reports and Universes from SAP BO using Framework Manager by Importing Tables workflow analysis of the project and designed Meta models as per the Business Requirement.
• Used SQL Server and Oracle 10 & 11g as the data sources.
• Developed Database and Business Views for Meta Data Models using Framework Manager by Importing Tables, Views, creating short Cuts and Aliases. Specifying Dimensions, Levels, Hierarchies and Key values for data flow. Created joins, views and packages using Framework Manager to be used for report development
• Modified Metadata in the model by defining Filters and adding Calculations to better suit the requirements of the end users.
• Created Ad-hoc report using Query Studio and complex report using Report Studio.
• Developed Standard Reports, Charts, Drill through Reports, Nested Reports, Master Detail Reports, Bursting Reports and Multilingual Reports using Report Studio.
• Created pre-calculated columns in fact tables using PL/SQL Stored Procedures.
• Involved in the training and knowledge transfer of tool to the client.
• Created Query Prompts, Calculations, Conditions & Filters. Developing Prompt pages and Conditional Variables.
• Created New Jobs using Cognos Connection.
• Created User Groups and assigned user privileges using Cognos Connection.
• Unit testing and improving Report Performance.
• Trained Users on Query Studio for Ad-Hoc Reporting.
• Involved in Documentation for training and knowledge transfer of tool to end User

Environment: MS Office (Word, Excel), SAP BO, SQL, Oracle, Cognos and QlikView.

Confidential

Responsibilities:

• Developed reporting applications using Cognos Business Intelligence components, Report Studio, Framework Manager, Query Studio, Analysis Studio, and Cognos Connection.
• Used Framework Manager, Query Studio and Report Studio for model design, ad-hoc reporting and advanced report authoring to address healthcare related analysis needs.
• Interacted with Customers for requirement gathering, effective analysis and also to provide end-user training.
• Involved in data migration process between the two versions of Cognos. Creation of Calculations, Prompts, Conditions and Filters in a Report Studio Reports.
• Created different Joins according to User requirements in reports

Environment: MS Office (Word, Excel) and Cognos

Confidential

Responsibilities:

• Business Intelligence Applications using Cognos Tools, Cognos 8 BI, Report Net (Framework manager, report studio, query studio and Analysis studio
• Developed Dashboards Reports in Cognos.
• Involved in data migration process between different versions of Cognos.
• Involved in version upgrades and Migrating Impromptu Catalogs, PowerPlay Cubes, and ReportNet reports into Cognos 8.
• Built Metadata models using Framework Manager and Dimensional Modeling. Extensively worked on developing various kinds of reports in Cognos 8 Report Studio, Analysis Studio and Query Studio.
• Involved in modeling the Data and tuning up the database queries Involved in all phases of the project life cycle and gatheird and documented users’ needs for Cognos solutions.
• Developed and tested Reports in Report Studio and Query Studio.
• Created pre-calculated columns in fact tables using PL/SQL Stored Procedures.
• Created complex reports (multiple queries joined together to create one output, manual SQL with custom joins) using Report Studio.

Environment: MS Office (Word, Excel) and Cognos 8.4 & 10