SUMMARY

• Qualified professional, TEMPhas 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 and SDLC methodologies including Waterfall, Kimball and Agile.
• 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 wiflogical and physical data modelingand database design usingErwin.
• Experienced in designing thedata conversion strategy, development ofdata mappingsand teh 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 teh 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 teh Informatica workflows and files SFTP wif PGP/GPG encryption & decryption.
• Experienced in writing, testing and implementation of thePL/SQLtriggers,stored procedures, functions, packages and complexSQL queriesfor extracting teh 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 teh command line commands likepmcmdandinfacmdto perform tasks from any machine in teh 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 teh Crystal Reports.
• Excellent interpersonal communication, documentation and presentation skills, and is experienced in working wif 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: /Utilities: TOAD, SQL developer, SQL*PLUS, SQL*Loader, RAD, Eclipse, Secure CRT, BMC Remedy, ControlM, Win SCP and InfoBurst, Microsoft SharePoint, Surround SCM, Visual Source Safe.

PROFESSIONAL EXPERIENCE

BI Analytics Lead

Confidential, Northbrook

Responsibilities:

• Analyzed teh tables and framed teh query to get teh success & error messages details wif respect to carriers and quotes.
• Categorized teh error based on LOB & carrier and classified teh error as Underwriting, Technical & Mapping.
• Created various custom webi reports for success & error as per business needs.
• Worked on all teh Mapping related errors wif each insurance carrier and updated teh 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 teh difference after mapping fix.
• Working on Underwriting & Technical errors to minimize teh count to show as assumptions & friendly messages based on teh error nature.

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

BI Technical Lead

Confidential, 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 teh 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 teh jobs using windows server task scheduler to create/Modify/Manage, controlM scheduler, SQL Server.
• Created VM alerts on Windows machine and monitored teh 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 teh workbook reports.
• Tracked system stability and performance issues by monitoring primarily Wgsql and Vizql Server activity in all teh primary servers as well as teh worker servers.
• Built Customized Admin user views by connecting to teh Tableau “Workgroup” database.
• Written python script using Tableau SDK to create & publish teh TDE from trace sql wifout 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 teh Data imports and blends wifout involving teh ETL or Data Team.
• Performance optimization of teh data warehouse by identifying and assisting in correcting EDW/BI performance bottlenecks and debug database application or data content related issues.
• Document teh standards and best practices for Development and administration of teh tableau Platform

Environment: Tableau Desktop, Tableau Server, Oracle 12C (Exadata), MS Access/Excel, MS SQL Server.

BI Technical Lead

Confidential, Chicago

Responsibilities:

• Packaged teh Alteryx Designer in SCCM and written a vbs script to manage teh 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 teh worker node for teh scheduled/published workflows.
• Created a script to automate teh Alteryx server backup and restore using batch script.
• Assisted business users on teh issues that they faced during teh development.
• Converted teh small excel application to teh 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 teh data file to tableau using Alteryx tool.
• Participate in teh architecture and design of features associated wif collaboration and scaling of Alteryx across teh 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

Confidential, 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 teh complex mapping to implement teh claim key extraction logic based on business rules.
• Implemented teh JAVA batch program for teh rule engine calculation for those aging claims.
• Discussed wif business on teh different model output data required for reporting purpose.
• Enhanced teh universe to include teh newly created tables for reporting.
• Created new webi report and scheduled based on teh business requirement.
• Created teh view & package to flatten teh row from model history table for reporting and analytics.
• Worked closely wif testing team to ensure teh business logic test case execution

Environment: Informatica Power Center, Oracle 10g, PL/SQL, UNIX, Business Objects XR3.1

ETL Technical Lead

Confidential, Chicago

Responsibilities:

• Worked in an integrated environment where application interacts wif other applications, responsible for discussing requirements, cross impacts wifin 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 wif offshore development team and resolved technical issues faced during teh course of project.
• Review teh work of team member’s delivery and ensure it meets teh required standards.

Environment: Informatica Power Center, Oracle 12C (Exadata), PL/SQL, UNIX, CDC

ETL Technical Lead

Confidential, Chicago

Responsibilities:

• Led teh team end to end application life cycle of teh 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 wif other applications, responsible for discussing requirements, cross impacts wifin interacting applications and teams.
• Involved in performance analysis, fine tuning teh 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 teh testing case execution when teh table gets refreshed.
• Coordinated development tasks wif offshore development team and resolved technical issues faced during teh course of project.
• Review teh work of team member’s delivery and ensure it meets teh required standards.

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

Sr. ETL/BI Developer

Confidential, Chicago

Responsibilities:

• Interacted wif 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 teh user to select teh values dynamically
• Created complexCondition Objectsfor easy reporting,Aggregate-Aware objectsfor better performance
• DevelopedBusiness Objects Universeswifclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Developed Crystal Reports for different teams and groups in teh 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 teh reports.
• Developed various database objects like Tables,ViewsandStored Proceduresby using Toad, PL/SQL in Oracle.
• Used InfoBurst and FileNet for teh report archival automation and report burst.
• Performed admin tasks related to users, groups, folders, and security usingCentral Management Console(CMC) and carried out teh universe/WebI/Crystal migration activities between environments.

Environment: s: Oracle 10g, TOAD, Secure CRT, SQL, PL/SQL, UNIX AIX 6.1, Business Objects XR3.1 (SP7), Crystal

Sr. ETL/BI Developer

Confidential, Chicago

Responsibilities:

• Lead teh team end to end application life cycle of teh project from providing installation, creating project development plan, delivering deployable, supporting application after go live.
• Worked wif underwriters on teh risk data setup for their modeling
• Setup teh 23 workstations and database server for RiskLink application and made available for 79 users using AD group and citrix XenApp.
• Setup teh flood/earthquake/storm data for European underwriter technicians
• Setup teh profiles for ERM & underwriters based on their roles.
• Worked wif ERM on teh excel tool for Terrorism and CAT pricing data model.
• Coordinated implementation tasks wif offshore team, helped out team members in resolving technical issues faced during teh course of project.
• Created process improvement tool that supports teh database operation (copy, delete, rename, attach/detach, archive and drop) between teh SQL Server 2008 databases for teh business needs.

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

Senior Developer

Confidential

Responsibilities:

• Involved in gathering and analyzing teh 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 teh 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 teh 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 teh standards while designing technical documents and developing Informatica ETL process.
• Generated queries using SQL to check for consistency of teh data in teh tables and to update teh tables as per teh Business requirements.
• Involved in Performance Tuning of mappings in Informatica.

Environment: 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 teh design, development, customer support and other data management team projects.
• Developed new and enhanced data marts business flow and implemented teh code changes into teh ETL process using SSIS.
• DevelopedBusiness Objects Universeswifclasses, objectsandcondition objectsand developedhierarchiesto supportdrill downreports.
• Worked on teh existing application issues and applied teh fix to improve teh performance and data quality in teh 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 teh Database as required by teh application.
• Identify new technologies or technological improvements to include in teh application to improve usability, stability and maintainability.
• Involved in Data Integration by identifying teh information needs wifin and across functional areas of an enterprise database upgrade andMigration wif SQL server Export Utility.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Worked wif Meta-Data Driven SSIS Packages to pull teh data from different Sources and load to Data mart.
• Experience in creating complexSSIS packagesusing proper control and data flow elements wif 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.