| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
BI DATA SPECIALISTContactPHONE NUMBER AVAILABLE EMAIL AVAILABLEProfileA well-organized, goal-oriented, highly motivated self-starter, effective team member with excellent analytical, troubleshooting, and problem-solving skills able to quickly adapt into the given role and deliver results in a timely manner.Key SkillsETLStatistical AnalysisData Quality AssuranceBusiness IntelligenceWriting SQL queriesPROFESSIONAL HIGHLIGHTS4+ years of working within Data Warehouse environments4+ years of experience with BI reporting, Power BI and SSRSExperience maintaining Enterprise Data Warehouse (EDW) in support of business intelligence analyticsExperience developing and maintaining data warehouse objectsExperience in data warehousing design, tuning and ETL/ELT process developmentProficient in SSIS process design architecting the flow of data from various sources to target.Experience in providing Logging, Error handling using Event Handler, and Custom Logging for SSIS PackagesExperience in deploying and scheduling SSIS packages across different environments.SDLC experience using the Agile and Waterfall methodologyExperience with data quality assurance and investigating data quality issues and developing improvement plansExperience with Business Process ImprovementExperience Building Business Process Flow DiagramsExperience in Planning and Organizing WorkflowsT-SQL development skills in Objects creation such as Tables and Views, User Defined functions, Indexes, Stored Procedures, CTE, Cursors and Triggers using SQL ServeExperience leading small project teams and working directly with clientsExperience with data mining, report creation, modeling, and trend forecasting.PROFESSIONAL EXPERIENCEBI Developer (Power BI, SQL, DW) Mar 2019 - PresentAbott- Irving, TXGenerate on-demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS) and POWER BI.Assist in development of data warehouse and ETL systems using relational and non-relational tools like SQL, No SQL and PostgreSQLDevelop periodic Dashboards and report for daily, weekly, monthly and quarterly.Create various types of charts like Heat Maps, Geocoding, Symbol Maps, Pie Charts, Bar Charts, Tree Maps, Gantts, Circle Views, Line Charts, Area Charts, Scatter Plots, Bullet Graphs and Histograms in Table Desktop, Power BI and Excel to provide better data visualization.Create Excel reports, Dashboards & Perform Data validation activity VLOOKUP, HLOOKUP, Macros, formulas, index match, Slicer with (Pivot table, Get Pivot Data, Dashboards), Power View, Power Map and Heat Map.Contribute to project plan development, offer input, manage projects and initiatives, direct assigned resources, communicate project status and ensure timely issue escalationEnsure projects comply with technology domain architecture, design and operate processes to help review ongoing activity against technology architecture and development standardsApply industry and technical knowledge to provide solutions that increase business results and minimize risk.Conduct pre- and post-implementation reviewsLead in knowledge transfer meetings with senior management team, other technical areas and business unitsEnsure that the design of data systems, including the Enterprise Data Warehouse, is optimal in order to achieve Business and Research goals and outcomesLead efforts to convert existing reporting tools to a standardized reporting infrastructureDevelop, implement and maintain reporting dashboards and scorecards, automated reporting solutions and other BI solutions to support tactical and strategic reporting needs of the organization.Assist with identification of data integrity problems and recommend solutionsWork with internal customers to capture requirements, design, create, document, manage and fulfill requests for on-going and/or ad-hoc reports, dashboards, and scorecardsServe as an Informatics Advisor to business leaders to support understanding of standardized measurement indicators and benchmarksCreate and deployed standardized financial reportingIdentify benchmarks and reporting tools necessary to compare operating performance to peers and the industryConsult with internal clients to identify, assess, and solve challenging business problemsDevelop data architecture plans and execute them in collaboration with Data Owners, Solution Architects & Technology LeadsTranslate advanced business analytics problems into technical and data design approaches that yield actionable recommendations across multiple, diverse domains. Create, maintain, and communicate current and target state data architecture for data domains within an assigned subject areaGuide application development teams in the data design of complex solutions and ensure that teams are in alignment with the organizations data architecture principles, standards, strategies, and target statesFacilitate the transition from high-level design to detailed implementation and support a project lifecycle with input from management where neededBusiness Intelligence Data Warehouse Developer (Power BI, SQL, DW) Aug 2017 - Jan 2019Collabrium Systems- PADefined, analyzed, designed, developed, tested, and maintained new software applications in support of the achievement of business requirementsElicited, documented, and modified software requirements and specifications throughout the software system life cycleResponsible for analyzing and amending software errors in a timely and accurate fashion and for providing status reports where requiredPerformed data warehouse design, including determining client requirementsDesigned dimensional star schemas, OLAP cubesAnalyzed data from operational systemsDesigned and documented ETL (extract, transfer, load) requirements; designing and documenting OLAP load routines; working with programmers to build ETL programs; and testing data loads for accuracy, completeness, and usefulnessProvided data warehouse user analysis and support and designs, creates, and manages the end user reporting layer creates user metadata documentationMarketed data warehouse resources to the client communityAssisted clients in creating reports in the data warehouse and OLAP environments and provides guidance to clients as neededWorked as a database designer for transaction systems, and designed concepts applied to normalized transaction databases and the data modeling techniques, and led client groups in data design and determining functional requirementsWorked with the IT department to develop an enterprise reporting environment including advising software and hardware decisionsProvided quality assurance of reporting dataManaged reporting users and user rolesBuilt new data procurement and data processing rulesDeveloped business reports and dashboards for operations, sales, and marketing usersMonitored analytical metrics and create automated alerts to trigger business responseImplemented new data analysis methodologiesTrained end users on new reports and dashboardsProvided technical expertise on data storage structures, data mining, and data cleansingBI Data Analyst (SQL, DW, SSRS) Nov 2016 July 2017Round Point Servicing Cooperation- Charlotte, NCGathered business requirements, definition and design of data source and data flows.Designed SSIS packages to bring data from existing OLTP databases to the new data warehouse by performing different kinds of transformations like lookup transformations, merge joins, fuzzy look ups, derived columns, merge join, conditional split, data conversion with multiple data flow tasks.Created complex SSIS packages using various transformations and tasks like Sequence Containers, Script, For-loop and For Each Loop Container, Execute SQL/Package, Send Mail, File System, Conditional Split, Data Conversion, Derived Column, Lookup, Merge Join, Union All, flat file source and destination, OLE DB source and destination, excel source and destination etc.Designed SQL database with control and audit schema tables to maintain historical data and error handling.Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production.Maintained and optimized the existing databases; monitor database performance and growth, performance tuning, generate reports according to the business requirements using SSRS and populate data warehouse using SSIImproved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.Designed, developed and deployed SSRS reports including parameterized reports, snapshot reports cached reports, drill down reports, drill through reports, linked reports, click-through reports, Sub-reportsDesigned and develop Dashboards and Reports using SSRS.Developing OLAP cubes by identifying tables (fact and dimension), Data Source and Data Source Views, attributes and dimension members using SSASDesigned and developed data warehouse, data marts and business intelligence using multi-dimensional models - star schema. |
