| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name ,AZBI/ETL/Database Developer PHONE NUMBER AVAILABLEEMAIL AVAILABLESUMMARY14+ years of experience in Information Technology with emphasis on Business Intelligence and Data warehousingWorked as a Senior Developer for many clients providing end-end Dev/SupportWorked on Agile Methodology Process for more than 9 years with Cross Functional Business teams2+ years of Healthcare Experience including Facets TriZetto, RxClaim, Valencia, Medforce, CMS and AAHProvide process improvements and solutions to Development & Administration13+ years of strong experience in developing Complex reporting solutions using Cognos BI 10.2/8.4/8.3/7.3 and other BI tools including Tableau, Business objects and Crystal ReportsWorked as Cognos Architect role for Clients. Strong Experience on all Cognos BI Products including Workspace, Workspace Advanced, Report Studio, Query Studio, Framework Manager, Metrics Studio, Transformer. Business Insight and Business Insight AdvancedInstalled and Configured all Cognos BI products in Production and all other environmentsExperience on installing and Configuring TM1,have integrated Cognos BI security with TM1Experience in data warehousing concepts, data modeling and OLAP.Strong knowledge on Ralph Kimball and Bill Inmon Datawarehouse Strategey.Strong Data Modeling Experience to meet the complex reporting requirements.Experience in Business Objects Desktop Products (Supervisor, Designer, Business Objects Reporter) and Enterprise Products (Web Intelligence and Application Foundation).Basic Knowledge of ETL Mappings and Workflows OWB, informatica, Microsoft DTS and Humming Bird-Genio and Oracle DBAProduction support (Level1, Level 2 and Level 3) and Training to end usersStrong SQL experience in MS SQL Server, Oracle, SSIS, Teradata and follow Database Naming StandardsExperience in Requirement Analysis, Design, Development, Testing and Implementation of SoftwareQuick Learner of Business Processes and TechnologiesExcellent interpersonal communication skills, team player with commitment to excellenceExperience in working with clients to gather requirementsEDUCATION:Harvard Business School- Digital Strategy and Innovation 2020M.S- Computer Science, University of Alabama in Huntsville, United States, May 2008.B.E- Computer Science, Bharathiar University, India, Apr 2003.CertificationsIBM Certified Designer Cognos 10 BI Reports and Cognos 10 BI AdministratorSkills and KnowledgeDatabasesOracle10.x/8.1/8i, MS SQL Server 2000, DB2, MS Access,TeradataETLHumming Bird. Oracle Warehouse Builder (OWB), Informatica,Microsoft DTS, Microsoft SSIS PackagesBI ReportingCognos Analytics 11,10.2, Cognos Insight, Workspace, Workspace Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Advanced, Cognos8.3(Report Studio, Query Studio, Framework Manager, Transformer Analysis Studio, Event Studio, Metrics Manager),Cognos ReportNet 1.1 MR2,Cognos Transformer 7.3,Cognos Power Play 7.3, Cognos Metrics Manager 2.1, Cognos Visualizer 7.3,Business Objects 6.1b, Web Intelligence, Crystal Reports Tools, TableauLanguagesC, C++, VC++, SQL, PL / SQL, Java, PHP,UNIX BasicsGUIVisual Basic, FACETS,SalesforceOther ToolsToad, Chameleon, Google Earth (Kml)FunctionalFinance, Healthcare, Hospitality, Telecom, Retail and BankingPROFESSIONAL EXPERIENCE:Genuent-NOV client,Houston,TX July 2020 to Till DateRemote Cognos DeveloperCreated Reports and Models using Cognos 11 and Framework ManagerWorked on T-SQL,SQLWorked on their internal systems,databases and Datawarehouses including Oracleand SQL Server database on AzureCRST Inc Feb 2020 to July 2020Currently undergoing Informatica TrainingCognos TM1 self-TrainingRiskonnect Inc,Scottsdale,AZ(Remote and Onsite)Cognos Administrator Nov 2019 to Jan 2020Cognos 10.1 to 11 migrationSalesforce support and Cognos Production supportFix FM packages,reports including DashboardsRTI International Durham, NC Mar 2019 to Nov 2019Cognos Lead /Database DeveloperTools: Cognos 10,11+, SQL Server,SSIS,PowerBI,BSP,Cognos TM1,Accounting HubWorked for Workforce, Revenue and Projects DataWorked on to understand the reports requirements and other systems including Acct Hub RevenueInstalled and administered Cognos 11.x versionCreated Stored procedures,views,packages,Dashboards,reportsWorked on Mapping documents, Analysis and UATWorked on analyzing the SSIS packages for data issues and understandingWork on TSQL proceduresHave experience in Database naming covetiHave done TM1 security implementation on IBM Cognos ServersInstalled and Configured IBM Cognos AnalyticsProvide full support on Cognos Maintenance with other teamsGermania Insurance Brenham,TX May 2018 to Feb 2019Sr.Cognos Developer/Database DeveloperTools: Cognos 10 & 11 Oracle and SQL ServerWorked for Insurance Reporting and other internal systems including Guidewire and other applicationsWorked on data including Auto, Property and LiabilityWorked on to understand the reports requirements and other systemsCreated Reports,Dashboards,using Cognos Report StudioFollowed Scrum MethodologyWorked on Mapping documents, Analysis and UATJohnson & Johnson, Bridgewater, NJ Nov 2017 to Feb 2018Sr.Cognos DeveloperTools: Cognos 10.2.2 & 11, Tableau,Corporater, Oracle and SQL ServerWorked for SCM/ Financial Reporting ProjectWorked on to understand the reports requirements and other systemsCreated Reports using Tableau and CognosFollowed Scrum MethodologyWorked on Mapping documents, Analysis and UATHCSC, Chicago, IL Sept 2017 to Nov 2017Senior Cognos Modeler/ DeveloperTools: Cognos 10.2.1 & 11, Oracle, Teradata, Aptitude Accounting HUB database, BIG DATAWorked for Financial Services Division Reporting ProjectWorked on to understand the reports requirements and other systemsPOC on development/security/reports solutions using Tableau/Cognos suite of productsFollowed Scrum MethodologyWorked on Mapping documents, security templates and Framework documentationErp Global Inc, Troy, MI Apr 2017 to Sep 2017Sr Cognos Developer/Database DeveloperFinancial Reporting ProjectTools: Cognos 10, Cognos TM1,SSIS,SSRS, Oracle 11gCognos BI 10.2 & Cognos TM1 Administration and Production support.Have installed configured Cognos BI, Cognos TM1, Cognos PlanningProvide Level1, Level2 and Level3 Support, provide solutions to Administration and DevelopmentDesign, Develop, Build and Test Cognos ReportsDeveloped Report Studio reports queries, filters, conditional formatting, aggregations,CVS Health Nov 2014 to Mar 2017Senior BI/Developer/Database DeveloperTools: Cognos 10, SSIS. FACETS, SSRS, Oracle 11g, MS-SQL Server, Medforce, RxClaim, Valencia, TeradataInteract with Business users to gather requirementsWrite BRD, Approach, Design and Unit Test Case documents for Medicare Part D ProjectsDeveloped AENO, Out of Area, Routed Calls, Discrepancy, Undeliverable Mail & healthcare reportsProcess Improvements within the teamDesign, Develop, Build and Test Reports. Provide Solutions to DevelopmentDevelop reports using SQL technology including Oracle and SQL server and other BI toolsProduction Operations Support using HPSM tickets and regular reportsWork on Healthcare systems including Facets-Trizet to and other internal systems and perform reporting based on itWorked on Facets which includes Medicare Part D Data, Member Enrollment data, Eligibility Data, RxClaims, Configuration Data, Plans and Groups, Part D Events.Understanding of Facets Data model (Subscriber Eligibility, Customer Service, Groups, Plan)Cognos Reports, Report Studio, Query Studio, Workspace, Workspace Advanced, Analysis Studio and Transformer CubesHPSM Incident and Problem ManagementCreate, Build and Test Microsoft Sql Server Integration Packages for reporting.Work on Automation of Queries using Microsoft SSIS packages.Develop, Design Packages using SSIS for various projects.Perform analysis on various source systems including Medforce, AS400, Datawarehouse, MS-Access and other systems and develop reports.Worked on Medforce Databases and other Rxclaims systems, created reports for Paper Claims Processing.Wayne State University, Detroit, MI Sept 2014 to Nov 2014Senior Report Writer/Cognos Architect/BA/Database DeveloperTools: Cognos 10.2, Oracle 11gGather reporting requirements with SMEsDesign, Develop, Build and Test Cognos ReportsDeveloped Reports for Development and Alumni Affairs DepartmentCreated Reports on Family Gifts, DonorsPerformed Analysis using reports and Oracle QueriesWork on Databases-OracleCognizant Technology Solutions US Corp Mar 2008 to Sept 2014Comerica Bank, Detroit, MI May 2013 to Sep 2014Lead Cognos /BIDW/Senior Developer/Administrator/ArchitectCognos BI 10.2 & Cognos TM1 Administration and Production support.Have installed configured Cognos BI, Cognos TM1, Cognos PlanningProvide Level1, Level2 and Level3 Support, provide solutions to Administration and DevelopmentDesign, Develop, Build and Test Cognos ReportsDeveloped Report Studio reports queries, filters, conditional formatting, aggregations,Calculations, block variables, Drill down, drill through, Page Set, etcCreated Reports for Loan Applications, Credit Cards,Refferals and for SalesHave worked on Framework Modeling ChangesManaging 21 applications which are developed using Cognos suites of ProductsHave developed dimensions,cubes using Cognos TM1 using input files as sourceHave added users to Cognos TM1,Cognos BI & PlanningIncident, Problem and Requests Management through Service DeskCo-ordinate with Offshore team and Business usersEducate users on using Cognos Workspace Advanced and other Cognos ProductsAnalysis of Incidents and fixing/providing solutionsWork on Databases including Oracle, DB2 and SQL ServerWorked on Lifecycle Manager and BSP MetaManageCrawford Insurance-Chicago, IL Sep 2011 to May 2013Lead Report Developer/Database DeveloperAnalysis of Reports sources from Business Objects and other Oracle reportsInteract with Client to get requirementsPerform Gap AnalysisMapping between Source and Target systems for Reporting needsCreation of Reports using Cognos tools including Report Studio, Query Studio and FMDeveloped Complex reports using Report StudioUnit TestingAssign work to team membersProvide technical support to Cognos DevelopersCo-ordinate with Offshore teamArthur J Gallagher, Chicago, IL May 2011 to Sep 2011Sr Cognos Developer/Database DeveloperAnalysis of Reports sources from Hyperion, SQL and access reportsCreation of Reports using Cognos Report Studio and Query StudioFramework Model changes using Facts and DimensionsUnit testing of Cognos ReportsAAA Insurance, Phoenix, AZ - Oct 2009 to May 2011Cognos Developer & Administrator/ArchitectCognos 8.4.1 Administration and Production supportBuilding, Scheduling and Monitoring Cubes using Batch scriptsDeployment of Reports, Cubes and portal pages between Dev and Production environmentsImplementing Security and Enabled Single Sign OnAnalysis of Reports issues in Production Worked on Transformer Power Cubes ChangesUpgraded the Cognos Environment from Cognos 8.3 to 8.4 and 8.4 to 8.4.1Installed Cognos 8.4 on a multi-server environment and configured with IBM WebSphereInstalled and Configured Cognos Go DashboardInstalled and Configured Metrics Server, Designer and created metric storeInstall of Fix packs and hotfixes for Cognos BI products.Moved the metric files from SQL server database metric store to Oracle metric store through CognosUse of Maximo for managing Change in ProductionSupporting startup and shutdown of Cognos Services during Security patching.Cognos 8.1 Planning Administration-Adding users and running Admin links, GTPDeveloped few reports on Audit and few reports for ETL Job Status using Informatica TablesCUNA Mutual Group, Madison, WI Aug 2009 to Oct 2009DW/BI Test LeadInteracted with clients on getting the testing requirements.Analyzing their source systems,ETL approach and Business Objects ReportsDefined the scope of testingDesigned the flow of testing which includes the testing approach on ETL and Business Objects Reports.Involved in system testing on the ETL source systems which involves testing from different stages, i.e. testing from source to staging and from staging to EDW and from EDW to Data marts.Involved in analysis on some of their ETL mappings.Tested the Business Objects reports by writing SQL queries on the backend.Involved in Defect Triage Meeting with the Development teams to work on the defects found during testing.Worked on HP Quality Center 9.2 for test case execution, creating and logging the defects.John Hancock Insurance, Boston, MA Aug 2008 to July 2009Cognos Architect/Developer/Lead/Administrator/Database DeveloperInteracted with SMEs on getting the requirements.Analyzing of clients Crystal Reports, source tablesCreating Oracle Stored Procedures using PL/SQL Programming language.Creating Cognos Framework Models and Reports using Framework manager and Report Studio.Creation of Filters, prompts, calculations in Report studioDevelopment of Cognos Reports, Test and Deliver.Installed and Configured Cognos 8.3 suite of products including Cognos Go Office!Portal Administration and Worked on Security Users, Groups and RolesConfigured Audit Reporting.Scheduled Reports using inbuilt Trigger functionality and using EventsExported and Deployed Packages, Report Specifications from Development to Test and Production Environments.Written technical and end user documentation on Cognos.Trained the Clients on Framework Manager.Installed the patch update for Cognos 8.3Code reviews and UATTravelers Insurance, St Paul, MN Mar 2008 to Jul 2008Architect/Developer/LeadAnalysis of Requirements.Developed Framework models based on their Data Models.Developed Cognos Reports according to customers requirements. Extensive amount of portal customization and integration with their web application was done as part of the requirementsInformation Technology Systems Center, Huntsville, AL Aug 2006 to Dec 2007Graduate Research Assistant (Part Time)Designed and develop web pages using JSP, JavaScript and PHP to render dataWorked on web services using Apache Axis and Java. Involved in creating wsdl files and generating server and client stubs and writing client interface using JSP.Worked on Oracle and My SQL 5.0 databasesWorked on Open source mapping Tools such as Chameleon and Map Server.Involved in Creating Maps for Map Server using Shape files.Worked on Google Earth using Kml files.Designed the user interfaces using JSP(Java Server Pages) and HTMLAcademic Project, University of Alabama in Huntsville May 2007 to Aug 2007I-Quest (An Intelligent Query Structuring Based on User Browsing Feedback for Semantic Retrieval of Video Data)Created User interface using Asp.net and Vb.net.Embedded video player on web.Wipro Limted, Dubai Jan 2006 to Jul 2006Data Warehouse/ Senior Cognos Developer /Database DeveloperPerformed system analysis, design, development, coding, generation of reports, testing and documentation.Collected requirements from clients, prepared requirements document, followed up and developed new report templates as per the client requestInvolved in Logical and Physical Data model and created Business models using Framework ManagerUsed Cognos Connection for organizing, security, scheduling and distributing reports.Building models and publishing packages in Framework Manager to the Report Net server.Created cubes from multiple iqds using Cognos TransformerCreated drill thru reports from Cognos Power Play to Cognos Report netCreated Scorecards, (KPIs) and Dashboards using Cognos Metrics Manager and Cognos VisualizerImplemented security for Cognos Transformer, Report net, Metrics ManagerTrained the Clients in CognosSupported UATData Warehouse Developer (Cognos/Business Object/ETL)Wipro Limited, Bangalore, India-Mar 2004 to Dec 2005Hospital Client, Wipro Limited, India -Apr 2005 to Dec 2005Telecom Client, Wipro Limited, India, (Jul 2004 to Apr 2005)Retail Client, Wipro Limited -(Mar 2004 to Jul 2004)Analysis of the specifications provided by the clientsInstallation of Cognos suite of Products.Cognos Administration- security, scheduling and distributing reports.Creation of Framework models using Framework ManagerBuilding models and publishing packages in Framework Manager to the ReportNet server.Development of filters, calculations, prompts, conditions, and created various reports, using Cognos Report Studio.Created cubes using Cognos TransformerPerform Oracle DBA activities, importing, exporting and backupCreated both summary and detail reports using Cognos Powerplay and ReportnetImplemented security for Cognos Transformer, Reportnet, Metrics ManagerCreated drill thru reports from Cognos Power Play to Cognos ReportnetInvolved in Logical and Physical Design of the databaseReplicated the Logical Data models using Cognos Framework Manager.Replicated the Reports using Cognos suite of Products.Experience in designing and building Universes, Classes and objects using Business ObjectsCreated Cardinalities, Joins and Aliases for resolving Loops and checked the Integrity of the Universes.Perform Oracle DBA activities, importing, exporting and backupExported the universes to the Repository for making resources available to the users. Created reports for various Portfolios using the Universes as the main Data Providers.Used Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulaes etc.Experience in BO Reporter, Designer and Supervisor modules, Query Panel and Data Provider.Created universes including universe parameters, objects and classes in BO Designer.Used Designer Module to Create prompts and queries, applied Aliases to remove cyclic loopsBackups and Recovery in Test Environment using Oracle (DBA activities).Unit and module testingMaintaining VSS (Visual Source Safe) |
