This is my profileContact via CazVidJashanpreet
IT Analyst
Contact
Competencies
Demonstrated experience with Cognos 11.
Demonstrated experience with Power BI.
Demonstrated experience with SQL Server.
Demonstrated experience with Oracle.
Demonstrated experience with DB2.
Education
Languages
Experience
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.