SUMMARY:

• Qualified professional, has 9+ years of extensive IT Experience in Data Warehousing and Business Intelligence applications in Financial Services, Property and Causality Insurance domain.
• Strong understanding of project life cycle andSDLCmethodologies includingWaterfall, KimballandAgile.
• Large amount of experience gatheringuser requirementsand translating them intotechnical and system specifications. Managing clients, vendors, and partner relationships.
• Proficient in developingEntity - Relationship diagrams,Dimensional Modeling,Star/Snow Flake SchemaDesigns and
• Expert in modeling Transactional Databases and Data Warehouse.
• Experienced withlogical and physical data modelingand database design usingErwin.
• Experienced in designing thedata conversion strategy, development ofdata mappingsand the design of Extraction, Transformation and LoadETLroutines for migrating data from non-relational or source relational to target relational.
• Strong experience in ETL usingInformatica Power Center 9.1/9.6 clients - Designer, Workflow Manager, Workflow Monitor and Repository Managerincluding administering, designing, developing and deploying ETL processes.
• Experienced in using SSIS tools like Import/Export Wizard and SSIS Package Designer.
• Proficient in Tableau Administration Tool for Configuration adding users, managing licenses and data connections scheduling tasks.
• Expertize in design and development of various dashboards/reports utilizing various Tableau Visualizations like Dual Axis Bar Graphs, Scatter Plots Pie Charts, Heat Maps, Bubble Charts, Tree Maps, Funnel Charts, Geographic Visualization and other making use of actions other local and global filters according to the business/client requirement.
• Expertise in Business Objects enterprise Products (Universe Designer, Desktop Intelligence, Web Intelligence, Info View, CMS, CMC & CCM) deployment and migration of Business Objects Universes and reports.
• Expertize in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drill-down, Dynamic grouping, graphical, and aging reports).
• Understanding & Working knowledge of CDC (Change Data Capture).
• Expertize in Alteryx Server installation, configuration, managing gallery admin, license management and Alteryx server backup & restore process. Converted MS access & SAS reporting logic into Alteryx workflows.
• Expertize in UNIX shell scripts to run the Informatica workflows and files SFTP with PGP/GPG encryption & decryption.
• Experienced in writing, testing and implementation of thePL/SQLtriggers,stored procedures, functions, packages and complexSQL queriesfor extracting the data to system.
• Experienced in implementing reporting applications using Crystal Reports, Business Objects and MS Access Reports.
• Experienced in documenting High Level Design, Low level Design, Unit test plan and Deployment documents.
• Experienced in using Automation Scheduling tools like Control-M and Windows scheduler.
• Implemented the command line commands likepmcmdandinfacmdto perform tasks from any machine in the Power Center environment
• Expertize in performing data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Expertize in generating Sub Reports, Standard, Mailing Labels, Cross Tab Reports and Graph Reports by using Chart expert of Crystal Reports.
• Expertize in creating various PL/SQL stored procedures, views, functions and temporary tables for data input to the Crystal Reports.
• Excellent interpersonal communication, documentation and presentation skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Experience in working in an onsite-offshore structure and effectively coordinated tasks between onsite and offshore teams.

TECHNICAL SKILLS:

Operating Systems: Windows XP/Win 7, MS-DOS, Linux and UNIX

Data warehousing: Star-Schema Modelling, Snowflakes Modelling, FACT, dimension tables (Normalization / De-Normalization Techniques)

ETL Tools: Informatica Power Center/Power Exchange 9.1/9.6, MS SQL Server Integration Services (SSIS)

Data Modeling: Erwin, MS Visio

OLAP/BI Tools: Business Objects XI 3.x, 4.2 (Universe Designer, DeskI, WebI, InfoView, Query Builder, CMC)Crystal Reports 2008, Tableau Desktop & Tableau Server and Alteryx Designer & Alteryx Server

Programming GUI: SQL, PL/SQL, VB Script, Batch Script, Java, HTML, XML, C, Python and UNIX Shell Scripting.

Tools: TOAD, SQL developer, SQL*PLUS, SQL*Loader, RAD, Eclipse, Secure CRT, BMC RemedyControlM, Win SCP and InfoBurst, Microsoft SharePoint, Surround SCM, Visual Source Safe.

WORK/ASSIGNMENT HISTORY:

BI Analytics Lead

Confidential

Responsibilities:

• Analyzed the tables and framed the query to get the success & error messages details with respect to carriers and quotes.
• Categorized the error based on LOB & carrier and classified the error as Underwriting, Technical & Mapping.
• Created various custom webi reports for success & error as per business needs.
• Worked on all the Mapping related errors with each insurance carrier and updated the mapping documents as needed.
• Created stories in pivotal tracker and assigned to respective developer group.
• Created custom error comparison webi report for business to see the difference after mapping fix.
• Working on Underwriting & Technical errors to minimize the count to show as assumptions & friendly messages based on the error nature.

Environment: s: Oracle 12C (Exadata), MS Access/Excel, Business Objects 4.2, ACORD XML, Pivotal Tracker

BI Technical Lead

Continental, Chicago

Responsibilities:

• Extensively used Tabadmin and Tabcmd commands in creating backups and restoring backups of Tableau repository.
• Created and managed/administer Tableau Sites, Groups, Workbooks and Projects, Database Views, Data Sources and Data Connections
• Did the maintenance and scheduling of Tableau Data Extracts using Tableau Server TabCMD and TABADMIN
• Experienced in Tableau server Installations/ Configuration, Upgrades, Patches, Change management, security, back-up, upgrade and restore process.
• Monitored server activity/usage statistics to identify possible performance issues/enhancements
• Scheduled the jobs using windows server task scheduler to create/Modify/Manage, controlM scheduler, SQL Server.
• Created VM alerts on Windows machine and monitored the servers for high process activity.
• Extracted physical query and analyzed performance using Tableau Desktop’s performance recording feature.
• Optimized Connections, Data Extracts, and Schedules for Background Tasks and Data Refreshes for corporate Tableau Server for better performance of the workbook reports.
• Tracked system stability and performance issues by monitoring primarily Wgsql and Vizql Server activity in all the primary servers as well as the worker servers.
• Built Customized Admin user views by connecting to the Tableau “Workgroup” database.
• Written python script using Tableau SDK to create & publish the TDE from trace sql without using tableau server.
• Implemented Alerts system to receive an alert for scheduled background refresh tasks.
• Designed various practical Data Visualizations, Charts, Dashboards, Prototypes and Demos, published it in various Tableau workbooks for Data & Analytical Projects.
• Created various Table calculations, hierarchal aggregate measures and parameters using Tableau desktop for the Data imports and blends without involving the ETL or Data Team.
• Performance optimization of the data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues.
• Document the standards and best practices for Development and administration of the tableau Platform
• Packaged the Alteryx Designer in SCCM and written a vbs script to manage the licensing process.
• Experienced in Alteryx server (controller, worker & gallery) node Installations/Configuration, Upgrades and Change management process.
• Created and managed/administer gallery, studios, collections, subscription, workflows, application and users/Artisans.
• Created ODBC/OCI connection on the worker node for the scheduled/published workflows.
• Created a script to automate the Alteryx server backup and restore using batch script.
• Assisted business users on the issues that they faced during the development.
• Converted the small excel application to the Alteryx workflow to run efficiently and faster.
• Developed complex Alteryx analytic application to model return on claim score using Alteryx.
• Performed text-mining on insurance claims data using Revolution Analytics.
• Published the data file to tableau using Alteryx tool.
• Participate in the architecture and design of features associated with collaboration and scaling of Alteryx across the enterprise.
• Using agile and best practice development methodologies, deliver solutions derived from client specifications and ultimate business needs.

Environment: s: Alteryx Designer 10.6, Alteryx Server 10.6, Oracle 12C (Exadata), MS Access/Excel, MS SQL Server.

ETL Technical Lead

Continental, Chicago

Responsibilities:

• Gathered requirements from business partners and created technical specifications
• Worked as a liaison between business and technical teams
• Created data models and database design documents for developers and end-users
• Designed and developed different models for aging claims.
• Led project to develop & deploy claim scoring engine application for actuarial & field agents.
• Designed the complex mapping to implement the claim key extraction logic based on business rules.
• Implemented the JAVA batch program for the rule engine calculation for those aging claims.
• Discussed with business on the different model output data required for reporting purpose.
• Enhanced the universe to include the newly created tables for reporting.
• Created new webi report and scheduled based on the business requirement.
• Created the view & package to flatten the row from model history table for reporting and analytics.
• Worked closely with testing team to ensure the business logic test case execution
• Worked in an integrated environment where application interacts with other applications, responsible for discussing requirements, cross impacts within interacting applications and teams.
• Provided Detailed Delivery plan, System Test Strategy, Deployment Strategy plan & Schedule for Merlin upgrade Project and production support after go live.
• Designed CDC connection between Merlin and Underwriters reporting tables.
• Coordinated development tasks with offshore development team and resolved technical issues faced during the course of project.
• Review the work of team member’s delivery and ensure it meets the required standards.
• Led the team end to end application life cycle of the project from providing development estimates, designing of modules based on requirements, creating project development plan, delivering deployable, supporting application after go live.
• Worked in an integrated environment where application interacts with other applications, responsible for discussing requirements, cross impacts within interacting applications and teams.
• Involved in performance analysis, fine tuning the application by appropriate changes in code both at database as well as Informatica ETL Mappings.
• Provided Detailed Delivery plan, System Test Strategy, Deployment Strategy plan & Schedule for Merlin upgrade Project and production support after go live.
• Created PL/SQL to automate the testing case execution when the table gets refreshed.
• Coordinated development tasks with offshore development team and resolved technical issues faced during the course of project.
• Review the work of team member’s delivery and ensure it meets the required standards.

Environment: s: Informatica Power Center, Oracle 12C (Exadata), PL/SQL, LINUX

Sr. ETL/BI Developer

Confidential, Chicago

Responsibilities:

• Interacted with Business Users, Business owners to know their Business requirements in developing and modifyingUniverses accordingly.
• Designed, Developed and Maintained Universesby definingjoins, cardinalitiesbetween tables applyingcontexts and aliastables to remove cyclic dependencies
• Used@functions like @select, @where and @prompt functionto createpromptswhich helps the user to select the values dynamically
• Created complexCondition Objectsfor easy reporting,Aggregate-Aware objectsfor better performance
• DevelopedBusiness Objects Universeswithclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Developed Crystal Reports for different teams and groups in the organization to fulfill their business needs.
• Used pre-defined functions likestring, date, numeric, conversion and null functions of Crystal likeisnull, inrepeatedgroupheader, monthtodate, lastfullmonth, lastfullweeketc.
• CreatedCross Tab Reports,Pie and Bar Charts, and Parameter Reports,Running totals,Sub Totalsandembedded linked and unlinked sub-reportsto separate and organize key information and to promote reusability in data reporting.
• Export reports in various formatslike MS Excel, PDF, MS Word, Text and CSV
• Developed stored procedures inPL/SQLusingTOADto be used in the reports.
• Developed various database objects like Tables,ViewsandStored Proceduresby using Toad, PL/SQL in Oracle.
• Used InfoBurst and FileNet for the report archival automation and report burst.
• Performed admin tasks related to users, groups, folders, and security usingCentral Management Console(CMC) and carried out the universe/WebI/Crystal migration activities between environments.
• Lead the team end to end application life cycle of the project from providing installation, creating project development plan, delivering deployable, supporting application after go live.
• Worked with underwriters on the risk data setup for their modeling
• Setup the 23 workstations and database server for RiskLink application and made available for 79 users using AD group and citrix XenApp.
• Setup the flood/earthquake/storm data for European underwriter technicians
• Setup the profiles for ERM & underwriters based on their roles.
• Worked with ERM on the excel tool for Terrorism and CAT pricing data model.
• Coordinated implementation tasks with offshore team, helped out team members in resolving technical issues faced during the course of project.
• Created process improvement tool that supports the database operation (copy, delete, rename, attach/detach, archive and drop) between the SQL Server 2008 databases for the business needs.

Environment: s: Windows server 2008, SQL Server 2008 R2, MS Office 2010, Citrix XENAPP.

Senior Developer

Confidential

Responsibilities:

• Involved in gathering and analyzing the requirements and preparing business rules.
• Designed and developed complex mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in the Mapping Designer.
• Involved in debugging Informatica mappings, testing of Stored Procedures and Functions, Performance and Unit testing of Informatica Sessions, Batches and Target Data.
• Implemented best practices as per the standards while designing technical documents and developing Informatica ETL process.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the Business requirements.
• Involved in Performance Tuning of mappings in Informatica.

Environment: s: Informatica 9.1/8.6, Oracle 10g, UNIX AIX, SQL, T-SQL, PL/SQL, Toad, Mainframe, Control-M 7, Tortoise SVN and Flat files.

Developer

Confidential

Responsibilities:

• Contributed to the design, development, customer support and other data management team projects.
• Developed new and enhanced data marts business flow and implemented the code changes into the ETL process using SSIS.
• DevelopedBusiness Objects Universeswithclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Worked on the existing application issues and applied the fix to improve the performance and data quality in the data warehouse.
• Created and managed database objects including tables, indexes and procedures and tested programs using SQL, PL-SQL and SQL Loader for database applications.
• Developed reusable SQL queries and/or procedures and functions for complex data requests.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Identify new technologies or technological improvements to include in the application to improve usability, stability and maintainability.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade andMigration with SQL server Export Utility.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Experience in creating complexSSIS packagesusing proper control and data flow elements with error handling.

Environment: s: Windows Server 2003, PL/SQL, SQL-Server 2000/2005, Business Objects XI R3.1, SQL ServerDTS/SSIS Packages, ProClarity Desktop Professional, HP Quality Centre, MS-VSS.