Este é o meu perfilContato pela CazVidEste perfil está escrito em inglês
Jashanpreet
IT Analyst
Contato
Competências
Demonstrated experience with Cognos 11.
Demonstrated experience with Power BI.
Demonstrated experience with SQL Server.
Demonstrated experience with Oracle.
Demonstrated experience with DB2.
Formação acadêmica
Idiomas
Experiência
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.