Este es mi perfilContactar vía CazVidEste perfil está escrito en inglés
Jashanpreet
IT Analyst
Contacto
Competencias
Demonstrated experience with Cognos 11.
Demonstrated experience with Power BI.
Demonstrated experience with SQL Server.
Demonstrated experience with Oracle.
Demonstrated experience with DB2.
Educación
Idiomas
Experiencia
IT Analyst
ExpertiseinBIModelingandReportAuthoringusingCognos11,Cognos10.2,Cognos10.1,PowerBI., HaveworkedwithIBMCognosReportStudio(version11,Cognos10.2.x,Cognos10.1.x)to design,modelanddevelopreportsanddashboards,aswellaswritingTransact-SQL(T-SQL)queries, ExperienceinworkingwithvariousdatabasesthatincludeOracle,SQLServer,andDB2Databases., ProficientatusingPowerQueryandPowerBIDesktopalongwithgoodamountofknowledgeinwritingandworkingwithMicrosoftPowerBIDAXcodetoimplementbusinesslogicwithinPowerBI reports, AsBIanalystworkedcloselywithbusinessstakeholderstoidentifybusinessrequirementsandalso collaboratedwithdataengineerstoidentifyandacquiredata., Strongcommunicationandabilitytotellastoryviahis/her/theirreportingskillsasrequiredto communicateacrosstechnicalandnon-technicalaudiencesandtosuccessfullybuildanddeliveradvancedreportingproducts., GoodunderstandingofdimensionalmodelingofStarSchemas,Snow-FlakeSchemasMethodologiesforbuildingenterprisedatawarehouses., ExpertiseindevelopingComplexReports(List,Crosstab,Drillthrough,Master-Detail,Charts,Maps,multi-querymulti-promptreports,burstreports)andDashboardsinCognosReportStudio,AnalysisStudio,aswellascreatingeventsandtasksinEventStudio., WorkedwithOn-siteteaminUSAandhaveexperienceinunderstandingandworkingwithOn-site/Offshoreenvironment, CollaboratedwiththeclientDataandAnalyticsteamstopreparethedatatoaddressalltheiranalytics/reportingneeds., CompetentindeploymentofCognosPackages,Reports,DashboardstootherenvironmentsusingeclipseandGITtoappendourreportstorepositoryormergeintotheexistingbranch., Performedtroubleshootingandappliedcorrectiveactionstoresolveissueswithmigratedreportsand dashboardsdiscoveredduringpre-releasetesting., Demonstratedexperienceworkinginateamenvironment,contributingtoteammeetingsonworkprogress,communicatingrisksandissues,providingresultsfromworkassessments,andexplainingtechnicaltaskstonon-technicalteammembers, HavehandledPowerBIprojectsalso,andcreatedreportsusingPowerBiDesktopandpublishedto servicestodevelopinteractiveandvisuallyappealingdashboardsforbusinessdecisionmaking., Strongtroubleshootingandproductionsupportskills, WorkedinbothWaterfallandAgileframeworkprojects., ContributedandprovidedguidanceontheentireBIapplication’sdevelopmentlifecycle.
Senior BI Analyst
ComprehendedbusinessrequirementsinBIcontextanddeveloped/migrated10+reportstoCognos11inlessthan6months., DevelopedPowerBIReportsandDashboardsfordifferentteams., HandleddiscussionsandmeetingswithBusinessforupcomingandongoingReportingRequirements.AlsocoordinatedmanyscrumcallswithProductownersforaccommodatinganychangesinbetweentheongoingSprints.Hadactivediscussionsandpresentedfeasiblesolutionsforintermittentchangestotasksassigned., Providedstatusandactedasthepoint-of-contactforalltheAnalyticsTeam.
Senior BI Analyst
ProficientlydevelopedanddeployedCognos10PDFandEXCELreportsforDBStakeholdersMeetings., StructuredComplexChart/Graphicalreportsusingconditionalformattingandvariable selections.
BI Technical Lead
HiredasCognosSeniordeveloperforRequirementGatheringandFeasibilityofAngularJSWebServicesintegrationwithCognos11reportsandDashboards., InteractedwithRollsRoyceClientsfromtheUKforCognosrequirementsandtheirexpectationswiththetool., WaspartofScrum&ProjectBacklogmeetingsanddailyStandupcalls., DocumentedandpresentedDesignforCognosreportsforIntegrationwithWebUIiframes.
BI Technical Lead
ProficientlydevelopedanddeployedCognos10PDFandEXCELreportsforDBStakeholdersMeetings., DevelopedComplexChart/Graphicalreportsusingconditionalformattingandvariable selections., WorkedinanAgilewayofworkingandwaspartofScrummeetingsandstandupcalls., Testedreports,forpeerreviews,todeliverdefectfreecode., CoordinatedforIntegrationtesting,UAT,andsmoketestingandsupportedduringProductiondeployments., ActiveTeamplayerinproject., PlayedTeammembersinateamof4witheffectivecommunication,negotiationandclienthandlingskills., Createdstepbystepdocumentsforreportsandpackages., Documenteddetailedandlow-leveldesignforPackagesandReportsasandwhenrequestedbyCustomer.
BI Consultant
CoordinatingClient-OffshoremeetingsandgatheringrequirementsfromClientforUpcomingprojects., MonitoringSSISjobsanddataloadingduringUStimings., ResponsibleforSSRSStandardreportsubscriptions.MaintainingReportsubscriptionsforintendedaudience., CoordinationwiththeOffshoreteamfordailystatusandupcomingactivities., HandledWeeklyClientmeetingsforcapturingnewrequirementsandfutureprojectsfortheteam., Proficientlyhandledad-hocqueriesrelatedtodataissuesorSSISjobsfailedhavingcriticalseverity., ReviewingTechnicalDesignDocumentsandUnitTestCasesforSSISandCognos., HandlingSSISpackageenhancements/queries., Monitoringcriticaljobsanddataloads., InvolvedinCognosMaintenanceActivitiesandTroubleshootingad-hocCognosreportrelatedincidents.
Cognos Developer
InvolvedinrequirementgatheringandDevelopedtechnicalspecificationdocumentsbasedonfunctionalrequirements., AnalyzingthespecificationsprovidedbytheclientsandDevelopingspecificationdocumentsforreportsasperclientrequirements., DesignanddeveloptheFrameworkManagermodelsandpublishthemintoCognosConnections., DevelopedReportsusingConditionalFormatting,CascadingPromptsandReportBursting., DevelopedList,crosstab,drillthrough,master-detail,chartandcomplexreportswhichinvolvedMultiplePrompts,Filters,multi-page,multi-queryreportsagainstmultiple databases.Usedfiltersforefficientdataretrieval., DevelopedMulti-dimensionalmodels(cubes)usingTransformer., DevelopedmodelsinframeworkmanagerandcreatedIQDtousethemassourceto transformer(tobuildcubes)., ExtensivelyworkedoncuberefreshingonaDaily/Weekly/Monthlybasis&workedonDataValidations., Design&developmentofthereportsusingCognos8ReportStudio,QueryStudioandAnalysisStudio., InteractedwiththeEndusersonaregularbasisforresolvingissuespertainingtothe reports., CreationofDashboard/Reports/ActiveReportsusingrelationalmodelingaswellasOLAPmodeling., InvolvedindeploymenttoUATandProduction.